我用com.ibm.db2.jcc.DB2Driver连接,又出现以下错误:com.ibm.db2.jcc.c.SQLException: Required user property not set at com.ibm.db2.jcc.c.l.<init>(l.java:269) at com.ibm.db2.jcc.a.b.<init>(b.java:204) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:244) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:193) at com.royalstone.sql.DBConnectionManager$DBConnectionPool.addDBConnecti on(DBConnectionManager.java:218) at com.royalstone.sql.DBConnectionManager$DBConnectionPool.getDBConnecti on(DBConnectionManager.java:295) at com.royalstone.sql.DBConnectionManager.getConnection(DBConnectionMana ger.java:84) at com.royalstone.sql.ReqExecute.makeReqConnections(ReqExecute.java:33) at com.royalstone.transclient.ConnectionPoolHelper.initConnectionPool(Co nnectionPoolHelper.java:19) at com.royalstone.transclient.Run.init(Run.java:107) at com.royalstone.transclient.Run.main(Run.java:153) <2004-04-12 22:35:56> <3640> <生成连接池> 释放数据库连接失败.Errcode=0;Errmsg=缓 冲池为Null <2004-04-12 22:35:56> <3601> <初始化> 初始化连接池错误,请检查配置文件及数据库. [ SQLCode=-99999] [Required user property not set]
我有两个驱动,一个是db2java.zip(由DB2自身提供),另一个是db2jcc.jar. 用com.ibm.db2.jcc.DB2Driver连接成功,而用COM.ibm.db2.jdbc.app.DB2Driver连接时报 java.sql.SQLException: No suitable driver,DB2自身提供的应该是正确的驱动,不知道为什么会报这个错
检查一下你的"COM.ibm.db2.jdbc.app.DB2Driver"驱动程序是否可以访问,加入CLASSPATH中了么?
at com.ibm.db2.jcc.c.l.<init>(l.java:269)
at com.ibm.db2.jcc.a.b.<init>(b.java:204)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:244)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at com.royalstone.sql.DBConnectionManager$DBConnectionPool.addDBConnecti
on(DBConnectionManager.java:218)
at com.royalstone.sql.DBConnectionManager$DBConnectionPool.getDBConnecti
on(DBConnectionManager.java:295)
at com.royalstone.sql.DBConnectionManager.getConnection(DBConnectionMana
ger.java:84)
at com.royalstone.sql.ReqExecute.makeReqConnections(ReqExecute.java:33)
at com.royalstone.transclient.ConnectionPoolHelper.initConnectionPool(Co
nnectionPoolHelper.java:19)
at com.royalstone.transclient.Run.init(Run.java:107)
at com.royalstone.transclient.Run.main(Run.java:153)
<2004-04-12 22:35:56> <3640> <生成连接池> 释放数据库连接失败.Errcode=0;Errmsg=缓
冲池为Null
<2004-04-12 22:35:56> <3601> <初始化> 初始化连接池错误,请检查配置文件及数据库. [
SQLCode=-99999] [Required user property not set]
用com.ibm.db2.jcc.DB2Driver连接成功,而用COM.ibm.db2.jdbc.app.DB2Driver连接时报
java.sql.SQLException: No suitable driver,DB2自身提供的应该是正确的驱动,不知道为什么会报这个错
用com.ibm.db2.jcc.DB2Driver连接成功
-------------------------------那你就用这种成功的算了。DB2版本不同,它的连接字符串也有很多区别的
Class.forName("COM.ibm.db2.jdbc.net.DB2Driver"); 这种的也有,你要不去Google搜搜,多试试。