JDBC driver preparation

Preparing PowerBuilder component support files (for EAServer only)

If Appeon Server is installed to EAServer, whichever database and JDBC driver you use for the deployed application, you must add the following PowerBuilder component support files to the %JAGUAR%\lib\ext directory in the Appeon Server computer. %JAGUAR% indicates the installation path of the EAServer that hosts Appeon Server:

Table 11. PowerBuilder component support files

PB Version

File Name

8

pbjdbc12.jar

9

pbjdbc1290.jar

10

pbjdbc12100.jar

10.5

pbjdbc12105.jar

11.1

pbjdbc12110.jar

11.5

pbjdbc12115.jar

12.0

pbjdbc12120.jar

12.5

pbjdbc12125.jar

12.6

pbjdbc12126.jar


Retrieve the file from the %Sybase%\Shared\PowerBuilder folder. Make sure the version of the file is the same as the version of PowerBuilder that Appeon supports.

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 Appeon Server computer. Following is the checklist of the JDBC driver file(s) that should be copied to the directory.

Table 12. Checklist of JDBC driver files

Database

Driver Type

Driver Files

Availability of the Driver Files

SAP ASA/SQL Anywhere 8.0.2, 9.0, 10.0.1, 11.0, or 12.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 Appeon Servers on Windows:

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

jodbc.jar

For Appeon Servers on Unix\Linux:

dbjodbc8.so

jodbc.jar

Available in SAP ASA 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, 2008 or 2012

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

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 Appeon Server

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

Note: Configuring JDBC driver files in NetWeaver Application Server is different from those listed. For details on deploying JDBC driver files in NetWeaver Application Server, refer to Setting up data source for NetWeaver.

Table 13. Copy drivers to Appeon Server

Server Type

Directory for Storing JDBC Files

EAServer

For Windows: %JAGUAR%\lib\ext directory

For Unix\Linux: $JAGUAR/lib/ext

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 Appeon Server after copying files.

If EAServer is running as service, you need to re-install EAServer service, or stop the EAServer service and start EAServer from the Windows start menu, otherwise, you will encounter the "Exception was:javax.management.MBeanException" error when creating the data source. For details, refer to the section called “Failed to create new data sources” in Appeon Troubleshooting Guide.