当前位置: 代码迷 >> DB2 >> db2数据库连接,该怎么处理
  详细解决方案

db2数据库连接,该怎么处理

热度:4123   发布时间:2013-02-26 00:00:00.0
db2数据库连接
请问大家
我用JDBC连接db2数据库,报下面的错误是什么原因啊
  com.ibm.db2.jcc.b.SqlException: DatabaseMetaData information is not known for server DB2/NTSQL09050 by this version of JDBC driver
at com.ibm.db2.jcc.b.s.supportsTransactions(s.java:4845)
at com.sunyard.sunflow.db.pool.DBPoolManager$_Connection.<init>(DBPoolManager.java:275)
at com.sunyard.sunflow.db.pool.DBPoolManager.getConnection(DBPoolManager.java:165)
at com.sunyard.sunflow.db.connection.PooledConnectionProvider.getConnection(PooledConnectionProvider.java:39)
at com.sunyard.sunflow.db.connection.DBConnection.init(DBConnection.java:149)
at com.sunyard.sunflow.db.connection.DBConnection.<init>(DBConnection.java:38)
at com.sunyard.sunflow.util.threadpool.ConnectionManager.createConnection(ConnectionManager.java:55)
at com.sunyard.bpo.push.DBUtil.createRemoteImageDBConnection(DBUtil.java:26)
at com.sunyard.bpo.push.DownloadDataFromRemoteDB.getImageCount(DownloadDataFromRemoteDB.java:257)
at com.sunyard.bpo.push.DownloadDataFromRemoteDB.download(DownloadDataFromRemoteDB.java:81)
at com.sunyard.bpo.push.DownloadDataFromRemoteDB.run(DownloadDataFromRemoteDB.java:60)
at java.lang.Thread.run(Unknown Source)
请高手指点一下,谢谢




------解决方案--------------------------------------------------------
驱动不匹配产生的错误
db2 9.0 的驱动jar包:db2java.zip db2jcc.jar db2jcc_license_cu.jar 可以从%db2_home%SQLLIB\java中获取




------解决方案--------------------------------------------------------
jdbc驱动的问题,你看下你的driver是不是com.ibm.db2.jcc.DB2Driver,然后看一下你的连接jar包是否正确了
------解决方案--------------------------------------------------------
确实是驱动的问题,驱动的版本不兼容
------解决方案--------------------------------------------------------
V9以上版本驱动都一样
------解决方案--------------------------------------------------------
探讨
我用的是db2数据库是9.5的,我是用数据池连接的
  相关解决方案