Tips on JDBC

JDBC Drivers by DBMS Product

The followings are starting pages for JDBC drivers for each DBMS product.

• Oracle Database : http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
• IBM DB2 : http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21363866
• Microsoft SQL Server : http://msdn.microsoft.com/en-us/sqlserver/aa937724

Connection Properties of JDBC Driver

Oracle Database

Available connection properties of Oracle database's JDBC driver is described in API documentation of JDBC driver.
In case of Oracle database 11g, you can found them in the following page.

• OracleDataSource.setConnectionProperties(java.util.Properties value)

IBM DB2

Available properties on JDBC driver for DB2 version 9.7 are described in the following page.

• Properties for the IBM Data Server Driver for JDBC and SQLJ

Microsoft SQL Server

• Setting the Connection Properties - SQL Server 2008 R2

MySQL

• Driver/Datasource Class Names, URL Syntax and Configuration Properties for Connector/J from MySQL 5.0 Reference

HyperSQL

• Connection properties from HyperSQL 2.2 User Guide

http://www.hsqldb.org/doc/2.0/guide/dbproperties-chapt.html#dpc_connection_props

Diagnosability in JDBC

Oracle Database

• http://www.comp.dit.ie/btierney/oracle11gdoc/java.111/b31224/diagnose.htm

Oracle JDBC Driver

Compatibility of JDBC Driver

• Which JDBC drivers support which versions of Oracle Database?
• Which JDBC drivers support which versions of Javasoft's JDK?