启动WAS LP服务器时发生错误ClassNotFoundException：com.ibm.db2.jcc.DB2Driver

问题描述：

当我尝试启动Web球体LP服务器（WP 7）时，在Eclipse控制台中出现错误。启动WAS LP服务器时发生错误ClassNotFoundException：com.ibm.db2.jcc.DB2Driver

[2017-10-06 12:04:46,952] [ERROR] com.ibatis.common.logging.jakarta.JakartaCommonsLoggingImpl.error [19] SimpleDataSource: Error while loading properties. Cause: java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver 
java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver 
    at java.lang.Class.forNameImpl(Native Method) 
    at java.lang.Class.forName(Class.java:278) 
    at com.ibatis.common.resources.Resources.classForName(Resources.java:267) 
    at com.ibatis.common.resources.Resources.instantiate(Resources.java:283) 
    at com.ibatis.common.jdbc.SimpleDataSource.initialize(SimpleDataSource.java:199) 
    at com.ibatis.common.jdbc.SimpleDataSource.<init>(SimpleDataSource.java:116) 
    at com.ibatis.sqlmap.engine.datasource.SimpleDataSourceFactory.initialize(SimpleDataSourceFactory.java:31) 
    at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$9.process(SqlMapConfigParser.java:220) 
    at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121) 
    at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:105) 
    at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102) 
    at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102) 
    at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72) 
    at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:51) 
    at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:46) 
    at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:63) 
    at com.pm.testdatamgt.persistence.util.SqlMapBuilder.build(SqlMapBuilder.java:67) 
    at com.pm.testdatamgt.persistence.util.SqlMapConfig.<clinit>(SqlMapConfig.java:71) 
    at com.pm.testdatamgt.persistence.util.SqlMapConfigFactory.getSqlMapInstance(SqlMapConfigFactory.java:37) 
    at com.pm.persistence.dao.impl.ReferenceCodeDaoImpl.getRefCatIdForSname(ReferenceCodeDaoImpl.java:95) 
    at com.pm..service.impl.ReferenceCodeServiceImpl.initAttributeNames(ReferenceCodeServiceImpl.java:99) 
    at com.pm.testdatamgt.startup.StartupServlet.loadVariables(StartupServlet.java:139) 
    at com.pm.testdatamgt.startup.StartupServlet.init(StartupServlet.java:125) 
    at javax.servlet.GenericServlet.init(GenericServlet.java:244) 
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:332) 
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.loadOnStartupCheck(ServletWrapper.java:1428) 
    at com.ibm.ws.webcontainer.webapp.WebApp.doLoadOnStartupActions(WebApp.java:1205) 
    at com.ibm.ws.webcontainer.webapp.WebApp.commonInitializationFinally(WebApp.java:1173) 
    at com.ibm.ws.webcontainer.webapp.WebApp.initialize(WebApp.java:1075) 
    at com.ibm.ws.webcontainer.webapp.WebApp.initialize(WebApp.java:6595) 
    at com.ibm.ws.webcontainer.osgi.DynamicVirtualHost.startWebApp(DynamicVirtualHost.java:468) 
    at com.ibm.ws.webcontainer.osgi.DynamicVirtualHost.startWebApplication(DynamicVirtualHost.java:463) 
    at com.ibm.ws.webcontainer.osgi.WebContainer.startWebApplication(WebContainer.java:1120) 
    at com.ibm.ws.webcontainer.osgi.WebContainer.access$000(WebContainer.java:104) 
    at com.ibm.ws.webcontainer.osgi.WebContainer$2.run(WebContainer.java:932) 
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:522) 
    at java.util.concurrent.FutureTask.run(FutureTask.java:277) 
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1153) 
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) 
    at java.lang.Thread.run(Thread.java:785)

我已经添加了所需的数据源在我的server.xml

**<library id="DB2JCCLib"> 
     <fileset dir="${server.config.dir}/resources/DB2" includes="db2jcc.jar, db2jcc_license_cisuz.jar, db2jcc_license_cu.jar"/> 
</library> 
dataSource id="db2" jndiName="jdbc/db2"> 
    <jdbcDriver libraryRef="DB2JCCLib"> 
    </jdbcDriver> 
    <properties.db2.jcc databaseName="DB2" serverName="tsoc.nnnn.com" portNumber="5002"/> 
</dataSource>**

DB2罐子是在给定的位置。我缺少的东西或任何指针如何调试？

感谢

您的server.xml看起来是正确的。你可以展示CNFE的完整堆栈跟踪吗？以及任何导致堆栈的应用程序的Java代码CNFE –

db2jcc * .jar文件是否确实存在于$ {server.config.dir}/resources/DB2目录中？ –

@AndyGuibert附加完整的错误跟踪 –

答

如果使用在服务器配置一个数据源，自由会尝试加载数据源的实现类，如

com.ibm.db2.jcc.DB2DataSource 
com.ibm.db2.jcc.DB2ConnectionPoolDataSource 
com.ibm.db2.jcc.DB2XADataSource

，而不是驱动程序类，显示的异常，

com.ibm.db2.jcc.DB2Driver

所以一个很好的猜测（缺少异常堆栈）是您的应用程序可能试图使用DriverManager.getConnection而不是使用co配置的数据源。如果您真的想这样做（您将失去应用服务器提供的许多功能，如全局事务登记和连接池），那么您需要使JDBC驱动程序库直接供您的应用程序使用。例如，

<application location=...> 
    <classloader commonLibraryRef="DB2JCCLib"/> 
</application>

谢谢。它解决了我的问题。 –

启动WAS LP服务器时发生错误ClassNotFoundException：com.ibm.db2.jcc.DB2Driver

相关推荐