Java Web App Connection with Hana HXE VM installation

[former_member361514]

Hi,

We are trying to run our app in the server with neo-javaee6-wp-sdk, that we want to connect to the HANA Express Edition (running in a VM on the same system). We were able to open a db tunnel to this HXE host in Eclipse, but we were not successful in creating a jdbc connection on app deployment.

We provided the following url details in the connection.properties file of the LJS.

javax.persistence.jdbc.driver=com.sap.db.jdbc.Driver
javax.persistence.jdbc.url=jdbc:sap://192.168.99.101:39015/
javax.persistence.jdbc.databaseName=SYSTEMDB
javax.persistence.jdbc.user=SYSTEM
javax.persistence.jdbc.password=xxxx

Please let us know what is the right approach to establish this connection.

Thanks!

[pfefferf · Accepted solution]

The JDBC port for a HXE 2.0 installation ist 39013 (instead of 39015).

Regards,
Florian

[former_member361514 · Accepted solution]

Thank you! this worked. I guess either i need to update my HANA libraries in Eclipse or there is a bug in the library.

As when i selected the system in the systems view, the properties view gave me these details.

Thank you,
Mona