PowerServer Configuration Guide for J2EE
What is PowerServer data source?

SAP SQL Anywhere 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:

dbjodbc16.dll or dbjodbc17.dll

jodbc4.jar

For PowerServer on Unix/Linux:

dbjodbc16.so or dbjodbc17.so

jodbc4.jar

Available in the SAP SQL Anywhere installation path.

Note: dbjodbc16.dll or dbjodbc17.dll must be copied to %Sybase%\Shared\jdkversion\ire\bin\. jdkversion indicates which version of JDK is used, for example, jdk1.6.0_24.

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.

Oracle 11g

Oracle JDBC driver

For use with JDK 6, 7, or 8:

Ojdbc6.jar

For use with JDK 8:

Ojdbc8.jar

Available at the Oracle Web site (https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html).

Oracle 12c/18c

For use with JDK 8:

Ojdbc8.jar

Oracle 19c

For use with JDK 8:

Ojdbc8.jar

For use with JDK 10:

Ojdbc10.jar

Microsoft JDBC driver for SQL Server

mssql-jdbc-7.4.1.0.jre8.jar (requires JRE 8), mssql-jdbc-7.4.1.0.jre11.jar (requires JRE 11), or mssql-jdbc-7.4.1.0.jre12.jar (requires JRE 12)

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 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 or 5.6.x

MySQL Connector/J

For MySQL 5.5.x and 5.6.x: mysql-connector-java-5.1.19-bin.jar

Available at %MySQL%\MySQL Connector J\

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

PostgreSQL 9.2 or 12.x

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).

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