Connect Using the SAP HANA JDBC Driver

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

• Java JDK such as Java SE 11 (LTS)

• A SAP supported version of the OpenJDK

To verify that it 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 after replacing your_host and your_port to execute a simple query:

   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. 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.*;
   public class JavaQuery {
       public static void main(String[] argv) {
           Connection connection = null;
           try {  //encrypt and validateCertificate should be true for HANA Cloud connections
               connection = DriverManager.getConnection(  
                   //"jdbc:sap://10.11.123.134:39015/?encrypt=true&validateCertificate=false", "User1", "Password1");
                   //The below URL gets the host, port and credentials from the hdbuserstore.
                   "jdbc:sap://dummy_host:0/?KEY=USER1UserKey&encrypt=true&validateCertificate=false");  
           }
           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 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.