DataGrip connecting to SAP Hana via JDBC?

Answered

Hi

Has anyone here already successfully connected SAP Hana via JDBC driver in DataGrip?

I have created a new "user driver" in DataGrip. The driver files is the ngdbc.jar driver, the URL templates are as follows:

 

By Port:

jdbc:sap://{host::host}:{port::30015}[;failover1:{Failover Port 1:identifier}][;failover2:{Failover Port 2:identifier}][/{database::database}]?[currentschema={Current Schema:identifier}]

 

By Instance:

jdbc:sap://{host::host}:3{Instance Number:identifier:00}15[;failover1:{Failover Port 1:identifier}][;failover2:{Failover Port 2:identifier}][/{database::database}]?[currentschema={Current Schema:identifier}]

 

Unfortunately, I get the following error when connecting:

 

Connection to SAP Hana - *********** failed: Exception in thread "main" java.lang.InstantiationException at java.base/jdk.internal.reflect.InstantiationExceptionConstructorAccessorImpl.newInstance(InstantiationExceptionConstructorAccessorImpl.java:48) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at java.base/java.lang.Class.newInstance(Class.java:584) at com.intellij.database.remote.RemoteJdbcServer.main(RemoteJdbcServer.java:14) . Exception in thread "main" java.lang.InstantiationException at java.base/jdk.internal.reflect.InstantiationExceptionConstructorAccessorImpl.newInstance(InstantiationExceptionConstructorAccessorImpl.java:48) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at java.base/java.lang.Class.newInstance(Class.java:584) at com.intellij.database.remote.RemoteJdbcServer.main(RemoteJdbcServer.java:14) 

 

Could anyone help me out? 

 

Thank you so much

 

3 comments
Avatar
Yuriy Vinogradov
Comment actions Permalink

hi, we have added basic support of SAP HANA, so please update to the most recent version 2021.1.1 and create data source via (+) -> Other -> SAP Hana and check if it works with bundled driver or not.

1
Comment actions Permalink

Thank you very much. Connection is working.

0
Avatar
Yuriy Vinogradov
Comment actions Permalink

here is feature request for the SAP HANA support.

0

Please sign in to leave a comment.