Production of DBRMs during SQLJ program preparation
The SQLJ program preparation process for the IBM Data Server Driver for JDBC
and SQLJ does not produce DBRMs. Therefore, with the IBM Data Server Driver
for JDBC and SQLJ, you can produce DB2 packages only by using the IBM Data
Server Driver for JDBC and SQLJ utilities.
Difference in connection techniques
The connection techniques that are available, and the driver names and URLs that
are used for those connection techniques, vary from driver to driver. See ″Connect
to a data source using SQLJ″ for more information.
Support for scrollable and updatable iterators
SQLJ with the IBM Data Server Driver for JDBC and SQLJ supports scrollable and
updatable iterators.
The JDBC/SQLJ driver for z/OS support only non-scrollable and non-updatable
iterators.
Dynamic execution of SQL statements under WebSphere
Application Server
For WebSphere Application Server for z/OS Version 5.0.2 and above, if you
customize your SQLJ program, SQL statements are executed statically.
Related tasks
Chapter 9, “Migrating from the JDBC/SQLJ Driver for OS/390 and z/OS to the
IBM Data Server Driver for JDBC and SQLJ,” on page 439
Error codes issued by the IBM Data Server Driver for JDBC and SQLJ
Error codes in the ranges +4200 to +4299, +4450 to +4499, -4200 to -4299, and -4450
to -4499 are reserved for the IBM Data Server Driver for JDBC and SQLJ.
When you call the SQLException.getMessage method after a IBM Data Server
Driver for JDBC and SQLJ error occurs, a string is returned that includes:
v Whether the connection is a type 2 or type 4 connection
v Diagnostic information for IBM Software Support
v The level of the driver
v An explanatory message
v The error code
v The SQLSTATE
For example:
[jcc][t4][20128][12071][3.50.54] Invalid queryBlockSize specified: 1,048,576,012.
Using default query block size of 32,767. ERRORCODE=0, SQLSTATE=
Currently, the IBM Data Server Driver for JDBC and SQLJ issues the following
error codes:
382 Application Programming Guide and Reference for Java
™
To Next Page
Loading...
Need help?
General