SAP HANA - Java Driver (ngdbc.jar)

About

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

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

Trace

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.

_


Powered by ComboStrap