SAP HANA - Java Driver (ngdbc.jar)

1 - About

Jdbc connection information on HANA. The driver comes with the client installation

3 - Connection Parameters

  • Driver: com.sap.db.jdbc.Driver
  • URL: jdbc:sap://<server>:<port>[/?<options>]
  • Port = 3 + instancename + 15

Example:

jdbc:sap://" + servername + ":3" + instancename + "15/" 
jdbc:sap://localhost:30115/?currentschema=myCurrentSchema
jdbc:sap://localhost:30013/?databaseName=tdb1&user=SYSTEM&password=manager -- Multidatabase environement

See SAP HANA Developer Guide for Studio - Connect to SAP HANA via JDBC

4 - Trace

5 - DataType Mapping

SAP HANA allows each Java object to be converted to specific SQL types using the JDBC method PreparedStatement.setObject or RowSet.setObject.

Some conversions may fail at runtime if the value passed is invalid.


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap