DB2 - Problembeschreibung
Problem IC69090 | Status: Geschlossen |
JDBC/JCC DRIVER ACCEPTS JDBC:DEFAULT:CONNECTION WHEN RUNNING ON CLIENT SIDE. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
A client using the JDBC/JCC driver will accept the JDBC URL jdbc:default:connection which eventually results in the exception below: com.ibm.db2.jcc.b.SqlException: [jcc][10389][12245][3.53.70] Failure in loading native library db2jcct2, java.lang.UnsatisfiedLinkError: db2jcct2 (Not found in java.library.path): ERRORCODE=-4472, SQLSTATE=null at com.ibm.db2.jcc.b.bd.a(bd.java:660) at com.ibm.db2.jcc.b.bd.a(bd.java:60) at com.ibm.db2.jcc.b.bd.a(bd.java:94) at com.ibm.db2.jcc.t2.a.a(a.java:37) at com.ibm.db2.jcc.t2.T2Configuration.<clinit>(T2Configuration.java :94) at java.lang.J9VMInternals.initializeImpl(Native Method) at java.lang.J9VMInternals.initialize(J9VMInternals.java:196) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:211) at java.sql.DriverManager.getConnection(DriverManager.java:572) at java.sql.DriverManager.getConnection(DriverManager.java:218) ... ... Normally jdbc:default:connection is used inside of a Java stored procedure/user defined function running on the server side. There are some environments where multiple JDBC drivers from different vendors are loaded into the same JVM. Some JDBC drivers will accept jdbc:default:connection while others do not. This fix ensures that the IBM JDBC/JCC driver does not try to load the db2jcct2 library when it receives the JDBC URL jdbc:default:connection which may mislead the user into thinking an error has occurred. | |
Problem-Zusammenfassung: | |
See ERROR DESCRIPTION. | |
Local-Fix: | |
Do not use the JDBC URL jdbc:default:connection when trying to establish a connection to the DB2 database from a client. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
At minimum the client side Java application should use the JDBC/JCC driver included with v9.7 FP3. | |
Workaround | |
See LOCAL FIX. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.06.2010 04.10.2010 04.10.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP3 | |
Problem behoben lt. FixList in der Version | |
9.7.0.3 | |
9.7.0.3 |