IBM DB2 User Manual

The JDBC/SQLJ driver for z/OS support only non-scrollable and non-updatable
ResultSets.
Difference in URL syntax
The syntax of the url parameter in the DriverManager.getConnection method is
different for each driver. See the following topics for more information:
v ″Connect to a data source using the DriverManager interface with the IBM Data
Server Driver for JDBC and SQLJ″
Difference in error codes and SQLSTATEs returned for driver
errors
The IBM Data Server Driver for JDBC and SQLJ does not use existing SQLCODEs
or SQLSTATEs for internal errors, as the other drivers do. See ″Error codes issued
by the IBM Data Server Driver for JDBC and SQLJ″ and ″SQLSTATEs issued by the
IBM Data Server Driver for JDBC and SQLJ″.
The JDBC/SQLJ driver for z/OS returns SQLSTATE FFFFF when internal errors
occur.
Handling of null SQLSTATEs
By default, the IBM Data Server Driver for JDBC and SQLJ returns a null
SQLSTATE value when an SQLWarning or SQLException object contains a null
SQLSTATE value. The JDBC/SQLJ driver for z/OS returns SQLSTATE ″FFFFF″.To
override this incompatibility between the drivers, you can set the
db2.jcc.defaultSQLState configuration property for the IBM Data Server Driver for
JDBC and SQLJ. If you specify db2.jcc.defaultSQLState with no value, the IBM
Data Server Driver for JDBC and SQLJ returns ″FFFFF″ when the SQLWarning or
SQLException object has a null value for SQLSTATE.
Security mechanisms
The JDBC drivers have different security mechanisms.
For information on IBM Data Server Driver for JDBC and SQLJ security
mechanisms, see ″Security under the IBM Data Server Driver for JDBC and SQLJ″.
How connection properties are set
With IBM Data Server Driver for JDBC and SQLJ type 4 connectivity, you set
properties for a connection by setting the properties for the associated DataSource
or Connection object.
With IBM Data Server Driver for JDBC and SQLJ type 2 connectivity, you set
properties for a connection in one of these ways:
v You can set properties only for a connection by setting the properties for the
associated DataSource or Connection object.
v You can set driver-wide properties through an optional run-time properties file.
For the JDBC/SQLJ driver for z/OS, you set properties through the JDBC/SQLJ
run-time properties file.
Chapter 7. JDBC and SQLJ reference information 373

IBM DB2 Specifications

General

Developer	IBM
Initial Release	1983
License	Proprietary
Written in	C, C++
Category	Database Management System (RDBMS)
Operating System	Linux, Windows
Programming Languages	C, C++
Data Models	Relational
Editions	Community, Standard, Advanced
Key Features	high availability, scalability