Troubleshooting
Problem
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
- V10.5 JDBC
- V10.1 JDBC
- V9.7 JDBC - selected tab,
- V9.5 JDBC
- V9.1 JDBC
************************************************************
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
|
APAR No. | Abstract |
IT13175 | TO DOCUMENT ALL THE JCC APAR AND DEFECTS SHIPPED WITH DB2V97FP11 RELEASE |
APAR No. | Abstract |
No changes to the JCC driver in this fix pack from V9.7 FP 9 to V9.7 FP 10 |
|
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 |
|
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Programming Interface - JDBC","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7","Edition":"Enterprise Server;Express;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Product Synonym
DB2 JDBC Drvier
Was this topic helpful?
Document Information
Modified date:
23 June 2018
UID
swg21415236