JDBC Works only with User SYSTEM

[schardosin]

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

[carlsoane]

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

[jonas_rabello]

Thank you Carl.

This was what I needed. My connection finally worked.

[former_member486811]

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

[schardosin]

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!