JDBC driver preparation

Checklist for JDBC driver preparation

Before you configure a JDBC data source for your application database, the following JDBC driver file(s) must be copied to the PowerServer computer. Following is the checklist of the JDBC driver file(s) that should be copied to the directory.

Table 11. Checklist of JDBC driver files

Database

Driver Type

Driver Files

Availability of the Driver Files

SAP SQL Anywhere 8.0.2, 9.0, 10.0.1, 11.0, 12.0. 16.0, or 17.0

jConnect JDBC driver (Recommended)

jconn2.jar for jConnect 5.5, or jconn3.jar for jConnect 6

Available at %Sybase%\Shared\jConnect-5_5\classes or at %Sybase%\Shared\jConnect-6_0\classes.

Note: Install sql_asa.sql provided at %Sybase%\Shared\jConnect-5_5\sp for jConnect to function properly.

iAnywhere JDBC-ODBC driver

For PowerServer on Windows:

dbjodbc8.dll, dbjodbc9.dll, or dbjodbc10.dll

jodbc.jar

For PowerServer on Unix\Linux:

dbjodbc8.so

jodbc.jar

Available in SAP SQL Anywhere 8.0.2 Build 4361 or above. For earlier versions, you can obtain the files from http://www.sybase.com/downloads.

Note: dbjodbc8.dll or dbjodbc9.dll must be copied to %Sybase%\Shared\jdkversion\ire\bin\. jdkversion indicates which version of JDK is used, for example, jdk1.4.1_03.

Sun JDBC-ODBC driver

-

Bundled with the Java 2 SDK, Standard Edition, so there is no need to download it separately.

ASE 12.5.x or 15.x

jConnect JDBC driver

jconn2.jar for jConnect 5.5

jconn3.jar for jConnect 6.0

Note: ASE 15 supports jConnect 6.0 only.

Available at %Sybase%\Shared\jConnect-5_5\classes or at %Sybase%\Shared\jConnect-6_0\classes.

Note: Install sql_server12.5.sql for ASE 12.5 or sql_server15.0.sql for ASE 15 for jConnect to function properly.

SAP IQ 12.7.x or 15.x

jConnect JDBC driver

jconn2.jar for jConnect 5.5

jconn3.jar for jConnect 6.0

Available at %Sybase%\Shared\jConnect-5_5\classes or %Sybase%\Shared\jConnect-6_0\classes.

Sun JDBC-ODBC driver

-

Bundled with the Java 2 SDK, Standard Edition, so there is no need to download it separately.

SAP HANA 1.00.36

SAP In-Memory Database JDBC driver

Ngdbc.jar

Available at %SAP HANA%\hdbclient\ngdbc.jar.

Oracle 8i

Oracle JDBC driver

classes12.zip

Oracle8i 8.1.7.1 Patch

nls_charset12.zip

Available at the Oracle Web site (http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html).

Oracle 9i

Oracle JDBC driver

For use with JDK 1.3:

classes12.zip

nls_charset12.zip

For use with JDK 1.4:

Ojdbc14.jar

Available at the Oracle Web site (http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html).

Note: Classes12.zip and ojdbc14.jar cannot be placed in the same location and used at the same time.

Oracle 10g or 11g

Oracle JDBC driver

For use with JDK 1.4:

Ojdbc14.jar

For use with JDK 1.5:

Ojdbc15.jar

Available at the Oracle Web site (http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html).

Note: Ojdbc14.jar and ojdbc15.jar cannot be placed in the same location and used at the same time.

Microsoft SQL Server 2000

jTDS JDBC driver

(Recommended)

jtds-1.2.jar

Available at SourceForge Web site (http://sourceforge.net/projects/jtds/).

Note: You need to download the jtds-1.2-dist.zip file, which contains the jtds-1.2.jar file.

According to our tests, jTDS JDBC driver is better than Microsoft SQL Server JDBC driver in the way that it can prevent memory leak and boost performance.

Microsoft SQL Server JDBC driver

msbase.jar

mssqlserver.jar

msutil.jar

Available at the Microsoft Web site (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang​=en).

Note: The files have different versions. Make sure the file sizes are equal or close to the following.

msbase.jar: 281KB

mssqlserver.jar: 66KB

msutil.jar: 58KB

Microsoft SQL Server 2005

jTDS JDBC driver

(Recommended)

jtds-1.2.jar

Available at SourceForge Web site (http://sourceforge.net/projects/jtds/).

Note: You need to download the jtds-1.2-dist.zip file, which contains the jtds-1.2.jar file.

Microsoft SQL Server JDBC driver

sqljdbc.jar

Available at the Microsoft Web site (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang​=en).

Microsoft SQL Server 2008, 2012, 2014, 2016, or 2017

jTDS JDBC driver

(Recommended)

jtds-1.2.2.jar

Available at SourceForge Web site (http://sourceforge.net/projects/jtds/).

Microsoft JDBC driver 6.2 for SQL Server

mssql-jdbc-6.2.2.jre7.jar (requires JRE 7), or

mssql-jdbc-6.2.2.jre8.jar (requires JRE 8)

Available at the Microsoft Web site:Download Microsoft JDBC Driver for SQL Server.

IBM DB2 UDB 8.1, 8.2, 9.5 or 10.x

IBM JDBC driver

db2java.zip and/or db2jcc.jar

Available in the java or java12 folder of the DB2 Server installation directory.

The JDBC driver must be exactly the same version as DB2.

Informix 7.x, 8.x, 9.x, 10.x or 11.x

IBM Informix JDBC driver

ifxjdbc.jar and/or

ifxjdbcx.jar

Available at the IBM Web site (http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc).

MySQL 5.5.x

MySQL Connector/J

mysql-connector-java-5.1.19-bin.jar

Available at %MySQL%\MySQL Connector J\mysql-connector-java-5.x.jar

Or download from http://www.mysql.com/products/connector/.

Teradata 13.0

Teradata JDBC driver

terajdbc4.jar

tdgssconfig.jar

Available at the Teradata Web site (http://downloads.teradata.com/download/connectivity/jdbc-driver).

PostgreSQL 9.2

PostgreSQL JDBC driver

For use with JDK 1.7 or 1.8:

postgresql-9.3-1101.jdbc41.jar

For use with JDK 1.6:

postgresql-9.3-1101.jdbc4.jar

For use with JDK 1.4 or 1.5:

postgresql-9.3-1101.jdbc3.jar

Available at the PostgreSQL Web site (https://jdbc.postgresql.org/download.html).


Copying drivers to PowerServer

Copy the JDBC driver files to the proper directory in PowerServer. The directory varies with the type of application server that PowerServer is installed to, as shown in the table below.

Table 12. Copy drivers to PowerServer

Server Type

Directory for Storing JDBC Files

WebLogic

It can be any directory, but the directory path and name must be added in the ClassPath variable of the startWebLogic.cmd (Windows) or startWebLogic.sh (Unix\Linux) file.

If the directory is %WL_HOME%\server\lib folder (Windows) or $WL_HOME/server/lib (Unix\Linux), where %WL_HOME% is the installation folder of the WebLogic server (for example, C:\bea\weblogic81\), it is unnecessary to update the ClassPath variable.

WebSphere

For Windows: %WAS_HOME%\lib (%WAS_HOME% is the installation folder of the WebSphere server)

For Unix\Linux: $WAS_HOME/lib

JBoss

For Windows: %JBOSS_HOME%\server\instance\lib (%JBOSS_HOME% indicates the WildFly or JBoss EAP installation path)

For Unix\Linux: $JBOSS_HOME/server/instance/lib

JEUS

For Windows: %JEUS_HOME%\lib\datasource (%JEUS_HOME% indicates the JEUS installation path)

For Unix\Linux: $JEUS_HOME/lib/datasource


Important Note: Remember to restart PowerServer after copying files.