Skip to Content

JDBC Works only with User SYSTEM

Hi,

I am facing a really weird behavior, in Hana Express Edition I can only connect using JDBC with the user SYSTEM.

I have created a bunch of other users, all of them are able to login using the workbench or console tools, but by using JDBC, I can connect only with SYSTEM user.

Is there any configuration for that? This is new to me, using SCP or any other Hana instance I have never faced this problem.

Steps:

1) Create a user: create user TEST password TEST

2) Try to login using workbench (works successfully).

3) Try to connect using JDBC. It gives [10]: authentication failed

The strange part is that with SYSTEM user it works, I have also granted admin roles to my new user, even with that the connection doesn't work.

I would appreciate any help here.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 24, 2017 at 09:06 PM

    Dear Rafael,

    Did you change your first login password for the new user while trying to connect with JDBC?

    We did several experiments internally, so far the scenario we get the same error messages is to use initial password for newly created user with JDBC connection.

    Besides, it's required to change the initial password for new created user by default.

    Should you have more issues, please do not hesitate to contact us.

    Best regards,

    Joice

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Joice,

      thanks for replying!!!

      Yes, I have changed the password in every test, I am able to login using the Development Workbench (and it asked to change the password only in the first time), but it sill doesn't work for JDBC.

      The only difference I have in my scenario is that I am using Docker, I thought it was something related to the exposed ports, but I have tried to connected a java application running inside the container and even with that, it is not able to connect using JDBC, but if I go to the development workbench, it works fine, and most important, using SYSTEM I am able to login in any scenario.

      I am able to provide you the docker image if you would like to test it.

      Thanks a Lot!

  • avatar image
    Former Member
    Aug 16, 2017 at 11:10 PM

    Hello Rafael:

    Did you follow these instructions for building your jdbc connection string.

    Here is an example for how to connect to the systemDB on an HXE server with the user "SYSTEM" and the password "manager".

    jdbc:sap://localhost:39013/?databaseName=SystemDB&user=SYSTEM&password=manager

    Thanks,

    Carl

    Add comment
    10|10000 characters needed characters exceeded