JDBC

Contents 1 JDBC database connection driver 1.1 MySQL JDBC Driver 1.2 JDBC for MS SQL-Server 1.3 JTOpen IBM Toolbox for i5 / AS400

JDBC database connection driver

General installation is to download the JDBC-Driver and put the jar-file to the ..tomcat\lib directory of your installation.

• Configuration is generally done in your .localtomcat.properties file.
  
• See also Obxxxsvr.properties for more infos about transaction save configuration and Fetch For Update usage.

Example:

jdbc-resourcename=jdbc/security
jdbc-jndi-ref=java:comp/env/
jdbc-driver=com.mysql.jdbc.Driver
jdbc-datasource=jdbc\:mysql\://localhost\:3306/FooDBName
jdbc-user=FooUser
jdbc-password=FooPWD
dbtype=mysql

MySQL JDBC Driver

Download the MySQL JDBC driver, unpack the zip and copy mysql-connector-java-5.x.y-bin.jar to your tomcat\lib dirextory.

http://www.mysql.com/products/connector

JDBC for MS SQL-Server

Copy the jtds-1.2.jar (JDBC-Driver JAR) or a later version to your tomcat/lib directory.

http://jtds.sourceforge.net/

JTOpen IBM Toolbox for i5 / AS400

The IBM Toolbox for Java / JTOpen is a library of Java classes supporting the client/server and internet programming models to a system running OS/400 or i5/OS.

Copy the JDBC-Driver to your tomcat/lib directory.

JTOpen IBM Toolbox: http://jt400.sourceforge.net/

IBM Toolbox for Java JDBC properties: http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=%2Frzahh%2Fjdbcproperties.htm

Example;

# Properties fuer JDBC Standard DataSource
jdbc-resourcename=AS400
jdbc-driver=com.ibm.as400.access.AS400JDBCDriver
jdbc-datasource=jdbc:as400://as400.domain.com;date format=iso;naming=system;true autocommit=true;transaction isolation=read  committed;libraries=,FooLib1,Lib2
jdbc-user=FooUser
jdbc-password=FooPWD
jdbc-validation=SELECT COUNT(*) FROM S2SOFTF