About

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

Articles Related

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

java -jar ngdbc.jar

See Trace a JDBC Connection on the Command Line

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.