DataGrip connecting to SAP Hana via JDBC? Follow
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
Please sign in to leave a comment.
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.
Thank you very much. Connection is working.
here is feature request for the SAP HANA support.