客户端连接失败

凌霄

我是使用db2jcc.jar作为数据库驱动的
我的应用程序在windows下，通过jdbc连接
我的db2安装在Linux下
我的db2服务端口60000
现在程序访问数据库报错如下：请问是啥原因
        java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool could not acquire a resource from its primary factory or source.
        com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:6
        com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:57)
        com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:213)
        com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:64)
        com.ncs.mif.common.dbconnection.ConnectionPool.getDbConnection(ConnectionPool.java:77)
        com.ncs.mif.controller.init.ProjectInitImpl.initialize(ProjectInitImpl.java:40)
        com.vitria.container.configuration.ProjectDescriptor.invokeInitMethod(ProjectDescriptor.java:1489)
        com.vitria.container.ProjectContext.startComponents(ProjectContext.java:621)
        com.vitria.container.Container.startComponents(Container.java:104)
        com.vitria.container.admin.ContainerAdminImpl.startProjectComponents(ContainerAdminImpl.java:172)
        com.vitria.bserv.IntegrationServerMain.startProjectComponents(IntegrationServerMain.java:351)
        sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        java.lang.reflect.Method.invoke(Method.java:324)
        com.vitria.roi.marshal.MethodMarshaller.doInvoke(MethodMarshaller.java:59)
        com.vitria.roi.marshal.OperationMarshaller.invoke(OperationMarshaller.java:62)
        com.vitria.roi.exchange.Objimpl._call(Objimpl.java:584)
        com.vitria.roi.marshal.OperationMarshaller.execute(OperationMarshaller.java:42)
        com.vitria.roi.exchange.Objimpl._dispatch(Objimpl.java:505)
        com.vitria.roi.exchange.IOPRequest.dispatch(IOPRequest.java:19
        com.vitria.roi.exchange.Dispatcher.execute(Dispatcher.java:15
        com.vitria.roi.exchange.Dispatcher.execute(Dispatcher.java:65)
        com.vitria.fc.thread.WorkerThread.executeThreadable(WorkerThread.java:11
        com.vitria.fc.thread.ThreadPoolImpl.workLoop(ThreadPoolImpl.java:700)
        com.vitria.fc.thread.WorkerThread.run(WorkerThread.java:8

xfxy

你就用了个db2jcc.jar？license没有放进去？
还有你把c3p0的配置或代码贴出来看看

itubie

驱动的问题
但是你是走的直接的jdbc还是中间件的还是client的

凌霄

#DB2
connection_url=jdbc:db2://192.168.5.8:60000/mif
db_username=mif
db_password=mif
db_drivername=com.ibm.db2.jcc.DB2Driver
db_jndi=

#c3p0 db connection pool config
c3p0.initialPoolSize=30
c3p0.acquireIncrement=5
c3p0.minPoolSize=30
c3p0.maxPoolSize=60

凌霄

我的db2jcc是从linux下的/home/db2inst1/sqllib/java下拷贝来的，
我曾经成功过一次，但后来把库删了以后重新建库后就不行了

大梦

db2jcc.jar
db2jcc_license_cu.jar
TYPE 4有这两个就够了!
要不你写简单的java代码测试一下看看!

凌霄

db2jcc_license_cu.jar
上哪可以找到

大梦

装db2的server或是客户端就有的!在安装目录的java目录下!
ftp://ftp.software.ibm.com/ps/pr ... r_for_jdbc_sqlj.zip