使用db2 runtime 8.1的客户端,然后在程序中使用JDBC的方式去连接数据库,程序发布在Tomcat5.5下,如果直接起动Tomcat,程序可以得到连接,但是在MyEclipse6.1中起动tomcat时,程序就得到不连接,报下以错误:
com.ibm.mm.beans.CMBConnectFailedException: DGL0394A: 错误::DriverManager.getConnection; No suitable driver (STATE) : ; [SERVER = ICMNLSDB, USERID = icmadmin, SQL RC = 0, SQL STATE = 08001]
那们大大可以给看一下,谢谢
com.ibm.mm.beans.CMBConnectFailedException: DGL0394A: 错误::DriverManager.getConnection; No suitable driver (STATE) : ; [SERVER = ICMNLSDB, USERID = icmadmin, SQL RC = 0, SQL STATE = 08001]
那们大大可以给看一下,谢谢
2)在myeclipse6.1连数据库是可以连上的,用的是DB2JAVA.ZIP的包,com.ibm.db2.jdbc.app.DB2Driver,是可以连上的,
3)驱动有加的
DGL0394A error in driver manager... get connection No suitable driver. SQLCODE=0 SQLSTATE=08001
Question
You get the no suitable driver message when you write a custom application on top of a WebSphere® Application Server to connect to DB2® Content Manager Version 8.
Answer
One of the reasons for getting this error message is that your environment is not set up properly. Check your LIBPATH variable within your application server. It needs to have the information that is contained in db2profile in order to be able to find the proper library files. After you have this set up, it will work. Because configuration problems such as this are not supported by IBM® Support, be sure that you read the Planning and Installing Your Content Management System. 这是在IBM官方网站找到得答案,应该不用翻译
看看这个~~