DB2 java.lang.NoClassDefFoundError:com/ibm/db2/jcc/SQLJContext

最新推荐文章于 2019-08-25 22:03:52 发布

weixin_34228662

最新推荐文章于 2019-08-25 22:03:52 发布

阅读量506

点赞数

文章标签： java 数据库

1、需要安装DB2的补丁包；

2、将db2下的3个驱动（最新的）拷贝到websphere下；

*********************************************************

ibm

*********************************************************

Technote (troubleshooting)

Problem(Abstract)

When configuring an IBM® WebSphere® Application Server datasource for DB2® database access using the db2jcc.jar driver (DB2 Universal Java Database Connectivity (JDBC) Driver Provider), an exception might occur when the application tries to access the database, even though "Test Connection" worked fine.

Symptom

When the application tries to access the database for the first time, an exception similar to this is logged in the server's Systemout.log:

[24.07.08 08:32:55:463 CEST] 00000110 SystemOut O -
reserveHostConnection(String, String) Unexpected Error:
java.lang.NoClassDefFoundError: com/ibm/db2/jcc/SQLJContext
at java.lang.ClassLoader.defineClass0(Native Method)

Cause

Check the version of the db2jcc.jar which is used by WebSphere. Some older DB2 drivers do not contain the SQLJContext.class at all.

Check the SystemOut.log for the JDBC driver version:

[25.08.08 09:52:25:506 CEST] 00000110 InternalGener I DSRA8206I: JDBC Driver Version: 1.3.70
JDBC Driver Version 1.3.70 is the one delivered with DB2 v8.1 Fixpack 3.

The minimum DB2 v8 prereq for WebSphere Application Server v6.0.2 (all modifications) is DB2 v8.1 FP6a, which implements JDBC Driver Version 2.2.49