Connect to SAP HANA 2.0 using JDBC
I’m trying to connect to SAP HANA 2.0 using JDBC. I took the driver
ngdbc.jarfrom the Eclipse plugin that I installed in Windows.
Problem is that I always get the same error
[Connection refused: connect], -813even when I set a random IP address in the connection string.
You seem to try to connect to the SystemDB of a multi-database-container (MDC) setup of HANA. As the SystemDB is special and don’t run in an indexserver process, you would use a different port (…13) to connect to it. However, usually one would want to connect to a tenant database instead. For this, the jdbc URL needs to contain then name of the database as a parameter. The HANA documentation contains the details on this.
Lars, if I use port 39013 instead of 39015 everything works perfectly, including user SYSTEM and other users, why is that?