DB2 Version 9.7 for Linux, UNIX, and Windows

JDBC and SQLJ reference information

The IBM® implementations of JDBC and SQLJ provide a number of application programming interfaces, properties, and commands for developing JDBC and SQLJ applications.

Data types that map to database data types in Java applications
To write efficient JDBC and SQLJ programs, you need to use the best mappings between Java data types and table column data types.
Properties for the IBM Data Server Driver for JDBC and SQLJ
IBM Data Server Driver for JDBC and SQLJ properties define how the connection to a particular data source should be made. Most properties can be set for a DataSource object or for a Connection object.
IBM Data Server Driver for JDBC and SQLJ configuration properties
The IBM Data Server Driver for JDBC and SQLJ configuration properties have driver-wide scope.
Driver support for JDBC APIs
The JDBC drivers that are supported by DB2 and IBM Informix database systems have different levels of support for JDBC methods.
IBM Data Server Driver for JDBC and SQLJ support for SQL escape syntax
The IBM Data Server Driver for JDBC and SQLJ supports SQL escape syntax, as described in the JDBC 1.0 specification.
SQLJ statement reference information
SQLJ statements are used for transaction control and SQL statement execution.
Interfaces and classes in the sqlj.runtime package
The sqlj.runtime package defines the run-time classes and interfaces that are used directly or indirectly by the SQLJ programmer.
IBM Data Server Driver for JDBC and SQLJ extensions to JDBC
The IBM Data Server Driver for JDBC and SQLJ provides a set of extensions to the support that is provided by the JDBC specification.
JDBC differences between the current IBM Data Server Driver for JDBC and SQLJ and earlier DB2 JDBC drivers
Before you can upgrade your JDBC applications from older drivers to the IBM Data Server Driver for JDBC and SQLJ, you need to understand the differences between those drivers.
JDBC differences between versions of the IBM Data Server Driver for JDBC and SQLJ
Before you can upgrade your JDBC applications from older to newer versions of the IBM Data Server Driver for JDBC and SQLJ, you need to understand the differences between those drivers.
Examples of ResultSetMetaData.getColumnName and ResultSetMetaData.getColumnLabel values
For the IBM Data Server Driver for JDBC and SQLJ version 4.0 and later, the default behavior of ResultSetMetaData.getColumnName and ResultSetMetaData.getColumnLabel differs from the default behavior for earlier JDBC drivers. You can use the useJDBC4ColumnNameAndLabelSemantics property to change this behavior.
SQLJ differences between the IBM Data Server Driver for JDBC and SQLJ and other DB2 JDBC drivers
The IBM Data Server Driver for JDBC and SQLJ differs in a number of ways from older JDBC drivers. When you move to the IBM Data Server Driver for JDBC and SQLJ, you need to modify your SQLJ programs to account for those differences.
SDK for Java differences that affect the IBM Data Server Driver for JDBC and SQLJ
Differences in the behavior among versions of the SDK for Java can cause variations in the results that you receive when you run programs under the IBM Data Server Driver for JDBC and SQLJ.
Error codes issued by the IBM Data Server Driver for JDBC and SQLJ
Warning codes in the ranges +4200 to +4299, and +4450 to +4499, and error codes in the ranges -4200 to -4299, and -4450 to -4499 are reserved for the IBM Data Server Driver for JDBC and SQLJ.
SQLSTATEs issued by the IBM Data Server Driver for JDBC and SQLJ
SQLSTATEs in the range 46600 to 466ZZ are reserved for the IBM Data Server Driver for JDBC and SQLJ.
How to find IBM Data Server Driver for JDBC and SQLJ version and environment information
To determine the version of the IBM Data Server Driver for JDBC and SQLJ, as well as information about the environment in which the driver is running, run the DB2Jcc utility on the command line.
Commands for SQLJ program preparation
To prepare SQLJ programs for execution, you use commands to translate SQLJ source code into Java source code, compile the Java source code, create and customize SQLJ serialized profiles, and bind DB2 packages.

Parent topic: Java application development for IBM data servers