Powered by Zoomin Software. For more details please contactZoomin

DataDirect JDBC ReadMe

SAP HANA JDBC 6.0.0

  • Last Updated: May 8, 2026
  • 6 minute read
    • OpenAccess SDK
    • Documentation

     README 
     Progress(R) DataDirect(R) 
     Progress(R) DataDirect(R) for JDBC(TM) for SAP HANA(R) Driver 
     Release 6.0.0 
     February 2026
     
*********************************************************************** 
Copyright (C) 2026 Progress Software Corporation and/or its 
subsidiaries or affiliates. All Rights Reserved.

*********************************************************************** 


CONTENTS 

Post-GA Product Announcements
Requirements 
Installation Directory 
Data Source and Platform Support
Changes Since 6.0.0 GA
Release 6.0.0 Features 
Notes, Known Problems, and Restrictions 
Documentation 
Installed Files


     Post-GA Product Announcements
The readme files will no longer be updated with product announcements and new 
features after the General Availability (GA) of the product. For the latest 
updates and enhancements, please refer to the release notes 
(https://www.progress.com/datadirect-connectors/whats-new).


     Requirements 

* A supported Java Virtual Machine (JVM) must be defined on your system path.

* The installer program requires a JVM that is Java SE 11 or higher, including
  Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.
  
* The driver requires a JVM that is Java SE 8 or higher, including Oracle JDK,
  OpenJDK, and IBM SDK (Java) distributions.



     Installation Directory 

The default installation directory for the driver is: 

* Windows: 
  C:\Program Files\Progress\DataDirect\JDBC 

* UNIX/Linux: 
  /opt/Progress/DataDirect/JDBC 
  Note: For UNIX/Linux, if you do not have access to "/opt", your user's home 
  directory will take the place of this directory. 


    Data Source and Platform Support

For the latest data source and platform support information, refer to the 
Product Compatibility Guide: 
https://docs.progress.com/bundle/datadirect-product-compatibility/resource/
datadirect-product-compatibility.pdf


    Changes Since 6.0.0 GA

Enhancements
------------
* The driver has been enhanced to comply with FIPS standards for data
  encryption. As part of this enhancement, the driver was tested with
  FIPS 140-3 enabled using a Red Hat OpenJDK 21 on a Red Hat Universal Base
  Image 9 instance.


Changed Behavior
----------------
* The installer program now requires you to install a JRE that is Java SE 11 or
  higher before running the installer. In earlier versions, the JRE used by the
  installer program was included in the product. However, to avoid potential
  security vulnerabilities, the installer program no longer includes a JRE.
  Instead, the installer program uses the JRE in your environment to allow for
  the most secure version of a JRE to be used.
 
  Note: This change does not affect the JVM requirements for the driver. For the latest 
  driver requirements, refer to the Product Compatibility Guide:
  https://docs.progress.com/bundle/datadirect-product-compatibility/resource/
  datadirect-product-compatibility.pdf



     Release 6.0.0 Features 

The Progress DataDirect for JDBC for SAP HANA driver supports SQL read-write 
access for JDBC applications to the SAP HANA database. The driver provides 
access to data in SAP HANA that can be pulled into a data visualization tool to 
get important insights into engineering operations. This functionality allows 
seamless integration with third-party software and provides comprehensive 
SQL support and JDBC standard connectivity to BI (Business Intelligence) 
and ETL (Extract,Transform, Load) tools. 

* Supports SQL read-write access to SAP HANA. 

* Supports all JDBC Core functions. 

* Supports the core SQL-92 grammar.

* Supports SAP HANA data types. 

* Supports user ID and password authentication method with 
  SCRAM-SHA-256 mechanism. 

* Supports TLS/SSL data encryption. 

* Supports proxy connections with a proxy server.

* Supports the handling of large result sets with paging and the FetchSize 
  connection property. 
  
* Supports returning parameter metadata for stored procedure arguments.  

* Supports catalog API calls.

* Supports prepared statements and parameterized queries.

* Supports manual transactions for commit and rollback operations.

* Includes Interactive SQL. It is a command-line interface
  that supports connecting your driver to a data source, executing SQL 
  statements, and retrieving results in a terminal. This tool provides a 
  method to quickly test your drivers in an environment that does not support
  GUIs.


     Notes, Known Problems, and Restrictions 
    
The following are notes, known problems, and restrictions with release 6.0.0 
of the driver. 

Isolation level support
-----------------------
The driver supports only the READ_COMMITTED isolation level.  

Data type support 
------------------
The driver does not support the ST_Geometry and ST_Point data types.

LOB data type support
---------------------
The driver does not support write operations for LOB data types. 

Parameter metadata 
------------------
The parameter metadata (JDBC type, precision, and scale) is different from 
the result set metadata for some data types due to server limitations.

Executing DataDirect Shell Script
---------------------------------
For Linux users: If you receive an error message when executing any
DataDirect for JDBC shell script, make sure that the file has EXECUTE
permission. To do this, use the chmod command. For example, to grant EXECUTE
permission to the testforjdbc.sh file, change to the directory containing
testforjdbc.sh and enter: chmod +x testforjdbc.sh

JDBC Methods 
--------------
The following notes on JDBC methods apply generally to Progress DataDirect 
for JDBC drivers. Additional information on driver support for the JDBC API 
can be found in the "JDBC Support" section of the product user's guide. 

* The DataDirect for JDBC drivers allow PreparedStatement.setXXX methods and 
  ResultSet.getXXX methods on Blob/Clob data types, in addition to the 
  functionality described in the JDBC specification. The supported conversions 
  typically are the same as those for LONGVARBINARY/LONGVARCHAR, except where 
  limited by database support. 

* The DataDirect for JDBC drivers support retrieval of output parameters from 
  a stored procedure before all result sets and/or update counts have been 
  completely processed. When CallableStatement.getXXX is called, result sets 
  and update counts that have not yet been processed by the application are 
  discarded to make the output parameter data available. Warnings are 
  generated when results are discarded. 

* The preferred method for executing a stored procedure that generates result 
  sets and update counts is using CallableStatement.execute(). If multiple 
  results are generated using executeUpdate, the first update count is 
  returned. Any result sets prior to the first update count are discarded. If 
  multiple results are generated using executeQuery, the first result set is 
  returned. Any update counts prior to the first result set are discarded. 
  Warnings are generated when result sets or update counts are discarded. 

* The ResultSet methods getTimestamp(), getDate(), and getTime() return 
  references to mutable objects. If the object reference returned from any of 
  these methods is modified, re-fetching the column using the same method 
  returns the modified value. The value is only modified in memory; the 
  database value is not modified. 


     Documentation 

PROGRESS DATADIRECT FOR JDBC FOR SAP HANA DRIVER DOCUMENTATION SET 
-------------------------------------------------------------------
The driver documentation set is available from the Progress Information Hub: 

https://docs.progress.com/category/datadirect-sap-hana  


     Installed Files 

When you extract the contents of the installation download package to your 
installer directory, you will notice the following files that are required to 
install the driver: 

* Windows:
   - PROGRESS_DATADIRECT_JDBC_INSTALL.exe
   - DriverModules
     - PROGRESS_DATADIRECT_JDBC_SAPHANA_6.0.0_INSTALL.iam.zip
     - PROGRESS_DATADIRECT_JDBC_COMMON_6.0.0_INSTALL.iam.zip

* Non-Windows:
   - PROGRESS_DATADIRECT_JDBC_INSTALL.jar
   - DriverModules
     - PROGRESS_DATADIRECT_JDBC_SAPHANA_6.0.0_INSTALL.iam.zip
     - PROGRESS_DATADIRECT_JDBC_COMMON_6.0.0_INSTALL.iam.zip 

When you install the driver, the installer creates the following directories 
and files in the product installation directory in the default installation 
directory or in an installation directory you specify, represented by 
INSTALL_DIR. 


INSTALL_DIR/: 
-------------
LicenseTool.jar            Product license file manager

ddprocinfo.exe             Windows executable to start the Processor 
                           Information
                           Utility

ddprocinfo                 UNIX/Linux script to start the Processor Information
                           Utility

fixes.txt                  Information on resolved issues for Progress
                           DataDirect for JDBC drivers

                           
INSTALL_DIR/Examples/Bulk/:
----------------------------
Load From File/bulkLoadFileDemo.java
                           Java source example for bulk loading from a CSV file

Load From File/load.txt    Sample data for the example

Streaming/bulkLoadStreamingDemo.java
                           Java source example for bulk loading from a result
                           set

Threaded Streaming/bulkLoadThreadedStreamingDemo.java
                           Java source example for multi-threaded bulk loading
                           from a result set

Threaded Streaming/README.txt
                           Instructions on how to use the thread.properties 
                           file

Threaded Streaming/thread.properties
                           Properties file for the example


INSTALL_DIR/Examples/JNDI/: 
----------------------------
JNDI_FILESYSTEM_Example.java
                           Example Java(TM) source file

JNDI_LDAP_Example.java     Example Java source file


INSTALL_DIR/help/:
------------------
*.html                     HTML redirects to driver help systems


INSTALL_DIR/install/: 
----------------------
.psc_dd_inst_reg.xml       Support file for the installation logs

logs/*.*                   Log file generated upon installation


INSTALL_DIR/jdbcisql/:
-----------------------
jdbcisql.bat               Batch file to start JDBC iSQL 

jdbcisql.jar               Java program to start JDBC iSQL 

jdbcisql.sh                Shell script to start JDBC iSQL 


INSTALL_DIR/lib/: 
------------------
JDBCDriverLogin.conf       Kerberos configuration file used to specify the JAAS
                           login module


INSTALL_DIR/lib/60/:
--------------------
saphana.jar                SAP HANA Driver and DataSource classes


INSTALL_DIR/NOTICES/: 
---------------------- 
JDBC for SAP HANA v6.0 notices.txt 
                           Third party agreement information
                           

INSTALL_DIR/pool manager/: 
---------------------------
pool.jar                   All DataDirect Connection Pool Manager classes 


INSTALL_DIR/READMES/: 
----------------------
JDBC for SAP HANA v6.0 readme.txt 
                           This file 

                           
INSTALL_DIR/testforjdbc/:
--------------------------
Config.txt                 Configuration file for DataDirect Test

ddlogging.properties       Logging properties file

testforjdbc.bat            Batch file to start DataDirect Test

testforjdbc.sh             Shell script to start DataDirect Test

lib/testforjdbc.jar        DataDirect Test classes                      


INSTALL_DIR/tools/Tableau: 
--------------------------
DataDirect SAP HANA.tdc     Third party application file


INSTALL_DIR/uninstall/: 
------------------------
.com.zerog.registry.xml    Support file for the uninstaller

.psc_dd_uninst_reg.xml     Support file for the uninstaller

InstallScript.iap_xml      Support file for the uninstaller

installvariables.properties
                           Support file for the Windows uninstaller

Uninstall_JDBC.exe         Windows uninstaller

Uninstall_JDBC.lax         Support file for the Windows uninstaller

uninstaller.jar            Java uninstaller

saphana/*.*                Support files for the uninstaller

resource/*.*               Resource files for the Windows uninstaller


February 2026
================
End of README

TitleResults for “How to create a CRG?”Also Available inAlert