Connect Using the SAP HANA JDBC Driver

Ensure that you have a Java Development Kit (JDK) installed and make sure it is accessible from your path. Details on which Java versions are supported can be found in SAP note 3006307 - SAP HANA Client Supported Platforms for 2.7 and Oracle Java SE Support Roadmap.

A few options include:

• Java JDK such as Java SE 11 (LTS)

• A SAP supported version of the OpenJDK

To verify that the JDK is correctly set up, run the following:

java -version
javac -version

If these commands fail, ensure that the folder they are located in, is included in your path.

The SAP HANA driver for JDBC is a Multi-Release JAR file and as such supports multiple versions of Java. It is available in the client installation folder at C:\SAP\hdbclient\ngdbc.jar and in the maven repository.

1. Run the following command for version information. If needed, adjust the path to match the installation location on your machine.

   java -jar C:\SAP\hdbclient\ngdbc.jar -v
   

   java -jar ~/sap/hdbclient/ngdbc.jar -v
   

2. Run the command again without the -v to open the configuration window, which provides driver information and the ability to set trace information:

   

   The JDBC driver has a different version number than the rest of the SAP HANA interfaces.

   The trace options are further described at JDBC Tracing and Trace Options.

3. Run the following and use either connection details stored in the user store or specify the connection details.

   java -jar C:\SAP\hdbclient\ngdbc.jar -k USER1UserKey -o encrypt=True -o validatecertificate=false -c "SELECT  * FROM HOTEL.CUSTOMER"
   
   or
   
   java -jar C:\SAP\hdbclient\ngdbc.jar -u USER1,Password1 -n your_host:your_port -o encrypt=True -o validatecertificate=false -c "SELECT  * FROM HOTEL.CUSTOMER"
   

   java -jar ~/sap/hdbclient/ngdbc.jar -u USER1,Password1 -n your_host:your_port -o encrypt=True -o validatecertificate=false -c "SELECT  * FROM HOTEL.CUSTOMER"
   

   

See JDBC Command-Line Connection Options for additional details on parameters of ngdbc.jar.

1. The following commands create a folder named java, enter the newly created directory, create a file named JavaQuery.java, and open the file in notepad.

   mkdir %HOMEPATH%\HANAClientsTutorial\java
   cd %HOMEPATH%\HANAClientsTutorial\java
   notepad JavaQuery.java
   

   Substitute pico below for your preferred text editor.

   mkdir -p $HOME/HANAClientsTutorial/java
   cd $HOME/HANAClientsTutorial/java
   pico JavaQuery.java
   

2. Copy the following code into JavaQuery.java:

   import java.sql.*;
   import com.sap.db.jdbc.Driver;
   public class JavaQuery {
       public static void main(String[] argv) {
           System.out.println("Java version: " + com.sap.db.jdbc.Driver.getJavaVersion());
           System.out.println("Minimum supported Java version and SAP driver version number: " + com.sap.db.jdbc.Driver.getVersionInfo());
           Connection connection = null;
           try {  
               connection = DriverManager.getConnection(  
                   //Option 1, retrieve the connection parameters from the hdbuserstore
                   //The below URL gets the host, port and credentials from the hdbuserstore.
                   "jdbc:sap://dummy_host:0/?KEY=USER1UserKey&encrypt=true&validateCertificate=false");
   
                   //Option2, specify the connection parameters
                   //"jdbc:sap://10.11.123.134:39015/?encrypt=true&validateCertificate=false", "User1", "Password1");
   
                   //As of SAP HANA Client 2.6, connections on port 443 enable encryption by default
                   //validateCertificate should be set to false when connecting
                   //to an SAP HANA, express edition instance that uses a self-signed certificate.
   
                   //As of SAP HANA Client 2.7, it is possible to direct trace info to stdout or stderr
                   //"jdbc:sap://10.11.123.134:39015/?encrypt=true&validateCertificate=false&traceFile=stdout&traceOptions=CONNECTIONS", "User1", "Password1");
   
           }
           catch (SQLException e) {
               System.err.println("Connection Failed:");
               System.err.println(e);
               return;
           }
           if (connection != null) {
               try {
                   System.out.println("Connection to HANA successful!");
                   Statement stmt = connection.createStatement();
                   ResultSet resultSet = stmt.executeQuery("SELECT TITLE, FIRSTNAME, NAME from HOTEL.CUSTOMER;");
                   while (resultSet.next()) {
                       String title = resultSet.getString(1);
                       String firstName = resultSet.getString(2);
                       String lastName = resultSet.getString(3);
                       System.out.println(title + " " + firstName + " " + lastName);
                   }
               }
               catch (SQLException e) {
                   System.err.println("Query failed!");
               }
           }
       }
   }
   

3. Compile the .java file into a .class file using the following command:

   javac -cp C:\SAP\hdbclient\ngdbc.jar;. JavaQuery.java
   

   javac -cp ~/sap/hdbclient/ngdbc.jar:. JavaQuery.java
   

4. Run JavaQuery.class and indicate where the SAP HANA JDBC driver is located. Note that the host, port, UID and PWD will be retrieved from the hdbuserstore.

   java -classpath C:\SAP\hdbclient\ngdbc.jar;. JavaQuery
   

   java -classpath ~/sap/hdbclient/ngdbc.jar:. JavaQuery
   

   

See JDBC Connection Options in Java Code for additional details on the getConnection method of the DriverManager.

See Connect to SAP HANA Cloud via JDBC for additional details on the certificate used during the connection.