Setting up a JDBC connection to remote SAP HANA system

To establish a JDBC connection to a remote SAP HANA system, you need to configure the correct port number and use the appropriate JDBC driver.

Port Configuration

You are using the correct port number for instance number "00". Port number 30015, where 00 represents the instance number of your HANA system. The port format follows the pattern 3<instance_number>15 for SQL connections.

JDBC Driver Setup

Use the HANA client JAR file ngdbc.jar instead of the generic SAP JAR file. This driver is specifically optimized for HANA database connections and provides better performance and compatibility.

Example

Here's how to establish a JDBC connection to a remote SAP HANA system ?

try {
   Class.forName("com.sap.db.jdbc.Driver");
   String url = "jdbc:sap://xx.x.x.xxx:30015/DBNAME"; // IP Address of HANA system followed by Port number
   String user = "your_username";
   String password = "your_password";
   
   Connection cn = java.sql.DriverManager.getConnection(url, user, password);
   Statement stmt = cn.createStatement();
   ResultSet rs = stmt.executeQuery("CALL Test.STORED_PROC");
   
   // Process the result set
   while (rs.next()) {
      System.out.println("Result: " + rs.getString(1));
   }
   
   // Close resources
   rs.close();
   stmt.close();
   cn.close();
   
} catch(ClassNotFoundException e) {
   System.out.println("HANA JDBC Driver not found");
   e.printStackTrace();
} catch(SQLException e) {
   System.out.println("Database connection error");
   e.printStackTrace();
}

Connection URL Format

The connection URL follows this pattern: jdbc:sap://<host>:<port>/<database_name>

• host ? IP address or hostname of the SAP HANA system
• port ? SQL port (typically 3<instance>15)
• database_name ? Name of the target database

Conclusion

Successfully connecting to a remote SAP HANA system requires the correct port configuration, the ngdbc.jar driver, and proper connection URL formatting. Always handle exceptions appropriately and close database resources to prevent memory leaks.