IBM Support

Knowledge Collection : DB2 JDBC driver for version 9.7 APARs

Technote (troubleshooting)


Problem(Abstract)

Contains list of shipped APARs for the IBM® Data Server Driver for JDBC and SQLJ Version 9.7. APARs sorted by fix pack.

Resolving the problem

Tab navigation

After reviewing the JDBC APARs you may Verify the version of the JDBC driver you have, or Download the latest JDBC driver from Fix Central.

************************************************************
Product Name : IBM® Data Server Driver for JDBC and SQLJ Version 9.7
Updated : June 1, 2016
************************************************************

Select a Fix Pack: 11 10 9 8 7 6 5 4 3 2 1


DB2 JDBC Version 9.7 Fix Pack 11
APAR No. Abstract
IT13175 TO DOCUMENT ALL THE JCC APAR AND DEFECTS SHIPPED WITH DB2V97FP11 RELEASE
DB2 JDBC Version 9.7 Fix Pack 10
APAR No. Abstract
No changes to the JCC driver in this fix pack from V9.7 FP 9 to V9.7 FP 10
DB2 JDBC Version 9.7 Fix Pack 9
APAR No. Abstract
IC98417 Fixes in IBM Data Server Driver for JDBC and SQLJ shipped with DB2 v97 Fixpack 9
IC93280 ON UNIVERSAL JDBC DRIVER, THE SYSTEM DEFAULT SOCKET PARAMETERS ARE NOT SELECTED WHEN KEEPALIVETIMEOUT=0 IS SPECIFIED.
IC94954 WHEN USING XADATASOURCE WITH ENABLESYSPLEXWLB=TRUE, A GRADUAL AND PERMANENT GROWTH IN TRANSPORT OBJECTS MAY OCCUR
IC90686 ARRAYINDEXOUTOFBOUNDSEXCEPTION WHEN RUNNING AGAINST DB Z/OS WITH PUREQUERY IN STATIC EXECUTION MODE
IC91373 SYSPLEX: A -4228 ERROR IS RETURNED DURING THE XA LOCALTRANSACTION AFTER AUTO FAILOVER
IC91262 USING TYPE 2 JCC DRIVER, INTEGER DATATYPES GET INSERTED WITH INCORRECT VALUES
DB2 JDBC Version 9.7 Fix Pack 8
APAR No. Abstract
IC91374 SYSPLEX: XAER_NOTA IS REPORTED ON A XA ONE PHASE COMMIT AFTER FAILOVER
IC88582 -401 RECEIVED FROM DB2 SERVER WHILE UPDATING A SMALLINT COLUMN WITH SETBOOLEAN METHOD
IC91331 JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION RETURNED WHEN EXECUTING STORED PROCEDURE.
DB2 JDBC Version 9.7 Fix Pack 7
APAR No. Abstract
IC84379 JCC T4 INCORRECTLY RETRIEVES SOME JAPANESE MULTI-BYTE KANJI CHARACTORS FROM IBM-932 DATABASE.
IC85319 IN BATCH UPDATE, SETDBSTRINGASBYTES() FAILS WITH ERROR CODE -4476
IC86501 USER IS GETTING SQL181 ERROR, WHEN THEY ATTEMPT TO INSERT A TIME STAMP INTO A Z/OS DB2 10 NFM USING JCC 3.63.75, SQL181
IC85777 DB2CONNECT:THE RETRY LOGIC FOR TIMESTAMP TYPE IS NOT USING DESCRIBED INFO THUS CAUSING -352 SQL ERROR
DB2 JDBC Version 9.7 Fix Pack 6
APAR No. Abstract
IC78822 JDBC DRIVER GETS ARRAYINDEXOUTOFBOUNDSEXCEPTION FROM BASECALENDAR.GETCALENDARDATEFROMFIXEDDATE
IC79845 CLASSLOADER FOR DATA SERVER DRIVER FOR JDBC RETURNS NULL.
IC80506 DISCONNECTNONTRANSIENTEXCEPTION WHEN 9.7FP4 CLIENT WITH JCC DRIVER ACCESS TO 9.7FP4 OR HIGHER SERVER
IC80281 JCC DRIVER MAY UN-INTENTIONALLY ALLOCATE MORE CONNECTIONS
IC80398 INTERMITTENT -4210 ERRORS FOR TRANSPORT TIMEOUT WHEN MAXTRANSPORTS EXCEEDS MAX CONCURRENT APPLICATION CONNECTIONS.
IC81587 DATABASEMETADATA CALLS TO DB2 FOR Z/OS
IC80887 JCC DRIVER CONFLICTS WITH INFORMIX NATIVE DRIVER OVER THE INFORMIX-SQLI PROTOCOL
IC80974 CALLABLESTATEMENT GETOBJECT () CALL DOES NOT RETURN DATA TYPE BASED ON THE REGISTEROUTPARAMETER TYPE
IC81752 JCC Driver connection slow due to JDK getHostName() and getCanon icalHostName() when NOT registed the IP ADDRESS in a DNS.
IC81957 IF THE SERVER LUW(PURESCALE) JCC WILL TRY TO FIND BEST MEMBER BY MAKING SOCKET CONNECTION EVEN THOUGH IT MIGHT STILL AS UNUSABLE
IC82553 JCC MIGHT THROW -4471 WHEN CLOSING XA CONNECTION DUE TO INACCURATE STATE MAINTENANCE OF XA TRANSACTION.
IC82318 SQL EXECUTED BY JDBC DRIVER RESULTS IN DUMP FILES CREATED AND DB 2DIAG.LOG FILE SHOWING INVALID SQL STATEMENT LENGTH FOR SQL > 2M
IC82875 APPLICATION CRASH DUE TO JAVA ERROR 'IOEXCEPTION: TOO MANY OPEN FILES' IF ENABLESYSPLEXWLB=TRUE
DB2 JDBC Version 9.7 Fix Pack 5
APAR No. Abstract
IC74895 DB2 JCC DRIVER MIGHT THROW EXCEPTION "JAVA.IO.CHARCONVERSIONEXCEPTION".
IC76342 ARRAYINDEXOUTOFBOUNDSEXCEPTION ON STATEMENT.COMPLETEEXECUTECALL WHEN CALLING PL/SQL STORED PROCEDURE
IC77101 NULLPOINTEREXCEPTION IS THROWN BY JCC WHEN AN APPLICATION TRIES TO USE LOBS ON A TYPE 2 LUW XA CONNECTION.
IC77293 EXECUTEBATCH() FAILS AFTER A CLIENT REROUTE
IC77656 QUERY GENERATOR IS NOT CHECKING IF COLUMN NAME IS CASE SENSITIVE AND USING COLUMN NAME WITHOUT QUOTES RESULTING IN EXCEPTION
IC78331 SQL0751N WHEN A JCC APPLICATION CALLS A STORED PROCEDURE WITHIN AN XA TRANSACTION, 1- PHASE COMMIT USING TYPE 4 JCC DRIVER
IV08650 SQLJ finalizer early closes cause 'Object Closed' on ResultSets/Statements, hung DB2 routines, WAS IndexOutOfBounds
DB2 JDBC Version 9.7 Fix Pack 4
APAR No. Abstract
IC72962 JCC DRIVER MIGHT MAKE TWICE AS MANY CLIENT REROUTE CONNECTION ATTEMPTS AS ARE CONFIGURED BY MAXRETRIESFORCLIENTREROUTE
IC73028 AFTER TAKEOVER HADR, JAVA APPLICATION REPEATEDLY TRIES TO DO AUTOMATIC CLIENT REROUTE TO THE NEW HADR STANDBY SERVER.
IC73311 XARESOURCE.START FAILS WITH XAER_INVAL, ERRORCODE=-4228 IF SUPPORT FOR LOOSELY-ENABLED TRANSACTIONS ENABLED
IC74054 JCC DRIVER MEMORY LEAK ON GETNULLCONNECTION FUNCTION.
IC75226 -4470 WHEN ENABLECONNECTIONCONCENTRATOR IS SET TO TRUE AND A HELD CURSOR USED.
IC74917 IF ENABLESYSPLEXWLB OR ENABLECONNECTIONCONCERNTRATOR IS SET TO TRUE INFORMATION FROM SETCLIENTINFO MAY NOT BE PASSED TO Z/OS.
IC75549 JDBC DRIVER STUCK IN CLIENT REROUTE
IC73873 DB2 JAVA TABLE UDF WILL ALWAYS FAIL WITH SQLCODE=-4302 IN THE FOLLOWING RUN due to A LOCK WAIT TIMEOUT of a sql in the UDF
DB2 JDBC Version 9.7 Fix Pack 3
APAR No. Abstract
IC69090 JDBC/JCC DRIVER ACCEPTS JDBC:DEFAULT:CONNECTION WHEN RUNNING ON CLIENT SIDE.
IC69309 TYPE 4 JDBC APPLICATIONS CONNECTING TO A DB2 ON Z/OS SYSPLEX OR DB2 PURESCALE SERVER MIGHT HANG AFTER A NOROUTETOHOSTEXCEPTION
IC69344 JCC DRIVER HANGS IN INFINITE LOOP
IC69459 UNIVERSAL JDBC TYPE 4 APPLICATION RECEIVES ERROR. A DRDA DATA STREAM SYNTAX ERROR WAS DETECTED. REASON: 0X2. ERRORCODE=-4499
IC70014 CONNECTING TO A DATABASE BEING DONE CONCURRENTLY FROM SEVERAL THREADS MAY FAIL WITH JAVA.UTIL.CONCURRENTMODIFICATIONEXCEPTION
IC70619 EXECUTING AN SQLJ SINGLETON SELECT STATEMENT WITH THE "SELECT INTO" CONSTRUCT MAY LEAD TO ERROR -4470 (RESULT SET IS CLOSED)
JR36838 DB2 NUMERIC FIELDS ARE PADDED WITH ZEROS TO MEET REQUIRED PRECISION
DB2 JDBC Version 9.7 Fix Pack 2
APAR No. Abstract
IC63367 CALLING A Z/OS STORED PROCEDURE WITH NULL INPUT PARMS FROM A JAVA PROGRAM, JCC T2 OR T4, RESULTS IN ERRORCODE=-4463
IC64766 SQLCODE -805 OCCURS ON THE NEXT SQL FOLLOWING A RESET OF JDBC CONNECTION FOR AN APPLICATION RUNNING UNDER WAS
IZ64929 JCC DISCONNECTEXCEPTION ACTUAL CODE POINT, 47 DOES NOT MATCH EXPECTED CODE POINT, 9224 ON CALL TO DB2/Z STORED PROCEDURE
IC64727 IBM DATA SERVER DRIVER FOR JDBC 3 MAY NOT LOAD IN JRE 5.0+ WHEN USING SECURITY MANAGER.
IC64831 JCC THROWS SQLEXCEPTION WITH ERROR CODE -4476 WHEN PREPAREDSTATEMENT.EXECUTEQUERY() DOESN'T RETURN A RESULTSET.
IC65315 READING BLOB FROM ZOS FAILS WITH SQL30037N OCCURES WHEN SERVER WITH PROGRESSIVEREFERENCE IS ON
IC66011 CLASS.GETCLASSLOADER() MAY RETURN NULL IN SOME SITUATIONS
IC65689 COMMUNICATIONS ERROR MESSAGE '{1} IS NULL' FROM IBM DATA SERVER DRIVER FOR JDBC AND SQLJ, ON T4AGENT.SENDREQUEST()
IC63562 SETNULL(1, JAVA.SQL.TYPES.OTHER) THROWS: UNRECOGNIZED JDBC TYPE: 1111. ERRORCODE=-4228, SQLSTATE=NULL
IC66919 JCC APPLICATION RETURN -4499 "UNSUPPORTED DDM OBJECT CODE POINT: 0X220A" WHILE PROPERTY DEFERPREPARES = TRUE
IC67238 DB2 JCC TYPE4 DRIVER FORGETS THE CURRENTSCHEMA VALUE IF ROLLBACKIMMEDIATELY AFTER A NEW CONNECTION AND ENABLESYSPLEXWLB=TRUE
IC67964 METHOD GETUPDATECOUNT RETURNS -1 FOR BATCH UPDATES USING JCCIC64727
IC67629 JCC SQLJ BATCH INSERTS RETURNS ARRAYINDEXOUTOFBOUNDSEXCEPTION
IC67694 XAER_OUTSIDE, hang or connection leak in JDBC/JCC driver
IC68257 EXCEPTION IS THROWN WHEN USING GETCATALOGUEDATABASES() API DUE TO JCC DRIVER IN A MULTI-THREADED JAVA ENVIRONMENT
DB2 JDBC Version 9.7 Fix Pack 1
APAR No. Abstract
IC62193 DOCUMENTATION OF CHANGES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ VERSION 3.58.82/4.8.87 FOR DB2 LUW V9.7 FP1
IC62555 CLASSCASTEXCEPTION WHEN CALLING EXECUTEBATCH() IF A STATEMENT PARAMETER THAT GETS CAST TO DECIMAL WAS SET USING SETLONG()
LI74705 SQLCODE -805 RETURNED BY IBM DB2 DRIVER FOR JDBC AND SQLJ IF BOTH CURRENTPACKAGEPATH AND CURRENTFUNCTIONPATH SET
IZ40382 UNIVERSAL JDBC DRIVER FAILS TO RESOLVE INDOUBT TRANSACTIONS WHENMORE THAN ONE MEMBER OF A DB2/Z DATASHARING GROUP IS AVAILABLE
IZ46853 RESULT SET DOWNLOAD DIALOG APPEARS AND CURSOR FREEZES AFTERWARDSV.6.1
JR32368 SQLEXCEPTION WITH ERROR CODE -4499 USING THE JCC DRIVER WHEN CONNECTED TO A DATABASE WITH CCSID 1153
LI74394 THE UNIVERSAL JDBC DRIVER (JCC) DOES NOT RETURN METADATA WHEN RUNNING A JAVA ROUTINE WHICH RETURNS EMPTY RESULTSET
IZ50347 CONNECTION REQUEST MAY HANG IF AN APP SIMULTANEOUSLY OPENS CONNECTIONS USING DRIVERMANAGER AND DATASOURCE USING JCC DRIVER
PK87567 NEW RELEASE OF THE IBM DB2 DRIVER FOR JDBC AND SQLJ (RELEASE 3.57) PROVIDING VARIOUS ENHANCEHMENT AND SERVICE UPDATES.
IC61403 WITH DATA SHARING GROUP MEMBERS ON DIFFERENT ZOS LPARS, THE JCC PROPERTY CURRENTSCHEMA MIGHT NOT WORK, SO YOU GET ERROR SQL0204
IZ50393 DOCUMENTATION OF CHANGES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ VERSION 3.57.86/4.7.89 FOR DATA STUDIO 2.2
IC62202 NULLPOINTEREXCEPTION FROM JAVA.UTIL.LINKEDLIST$LISTITR.REMOVE
IC62134 Websphere App Server datasource connects first to DB2 LUW then DB2 on zSeries, zSeries connection will return -104 (SQL0104N)
IC62516 IMPLEMENT NEW FLOATINGPOINTSTRINGFORMAT PROPERTY
IC63562 SETNULL(1, JAVA.SQL.TYPES.OTHER) THROWS: UNRECOGNIZED JDBC TYPE:1111. ERRORCODE=-4228, SQLSTATE=NULL
IZ60647 GETJCCSPECIALREGISTERPROPERTIES() THROWS -4700 ERROR AGAINST DB2Z/OS DATABASES RUNNING IN COMPATIBILITY MODE
IC63367 CALLING A Z/OS STORED PROCEDURE WITH NULL INPUT PARMS FROM A JAVA PROGRAM, JCC T2 OR T4, RESULTS IN ERRORCODE=-4463

Related information

Download a DB2 Fix Pack

Product Alias/Synonym

DB2 JDBC Drvier

Document information

More support for: DB2 for Linux, UNIX and Windows
Programming Interface - JDBC

Software version: 9.7

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: Enterprise Server, Express, Personal, Workgroup Server

Reference #: 1415236

Modified date: 04 August 2011


Translate this page: