JDBC Drivers

The following topic lists drivers which are shipped with Redwood Platform, their basic database URL syntax, and driver name.

You must ensure the drivers are in the classpath and accessible to Redwood Server. If your driver is not on the classpath, upload the jar file containing your JDBC driver into a library and reference its name in the Connection >Library field for your database under Environment > Databases.

IBM DB2

jdbc:db2://<host>:<port>/<db>
com.ibm.db2.jcc.DB2Driver

Oracle Thin Client

jdbc:oracle:thin:@<host>:<port>:<SID>
oracle.jdbc.OracleDriver

PostgreSQL

jdbc:postgresql://localhost:5432/example
org.postgresql.Driver

Microsoft SQL Server

jdbc:sqlserver://<host>:<port>[[;DatabaseName=<db>] [<property>=<value>] ...]
com.microsoft.sqlserver.jdbc.SQLServerDriver

Note: MS SQL Server must be configured to listen on a static port (default 1433) and accept SQL Server authentication (also known as mixed mode or SQL Server and Windows authentication). The above syntax should cover most implementations; more information on Microsoft SQL Server JDBC connect strings can be found on MSDN. Note that integrated authentication will use the credentials of the owner of the central Redwood Server process and that the examples on MSDN ften illustrate integrated authentication. When Redwood Server is run on UNIX, integrated authentication will require additional configuration that is out of the scope of this document. Furthermore, kerberos authentication is also possible, however, kerberos authentication configuration is out of the scope of this document.

When you attempt to retrieve date-related data from an MS SQL Server database using the MS SQL Server JDBC driver in combination with a Java 11 JVM, the date will be off by two days. This is an issue in the MS SQL Server JDBC driver version 3 and you have the following options to work around this issue: Install the hotfix released by Microsoft or use the version 2 or 4 of the MS SQL Server JDBC driver. See the Microsoft JDBC team's blog.

SAP/Sybase Adaptive Server Enterprise, Sybase IQ, SQL Anywhere, and Replication Server

You will have to retrieve the driver from SAP and import it into a custom library.

jdbc:sybase:Tds:<host>:<port>/<db>
com.sybase.jdbc3.jdbc.SybDriver

SAP HANA

You will have to retrieve the driver from SAP and import it into a custom library. If you have maven, you can retrieve it from mvn ngdbc.

jdbc:sap://<host>:<port>[?<option1>=<value1>[&<option2>=<value2>]*]
com.sap.db.jdbc.Driver

Examples

The following examples illustrate how to use the above drivers in a JDBC Process Server named Example.JDBCProcessServer connecting to a non-BTP HANA database:

IBM DB2

Oracle

PostgreSQL

SQL Server

Note: MS SQL Server does not by default listen on TCP network ports, this has to be configured.

SAP/Sybase Adaptive Server Enterprise

SAP HANA

This example validates the certificate, this means the certificate must be in your Java trust store or in a X509_TrustedCertificate credential. Ensure your central server can access your SAP HANA database, you need to set the Allow only specific IP addresses and IP ranges to its IP address or an IP address range.

See Also

• Connecting to Remote Databases with JDBC
• JDBC Definition Type
• Creating JDBC Process Servers Using the Wizard
• Creating JDBC Process Servers
• JDBC Process Definition Wizard