我用的是oracle11g数据库,ssh框架,c3p0来配置连接 错误如下:Managed Threads: 3
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@c22681 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@6e12d5 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@96613f (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@ca81dd
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@113daba
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@7d0bbd
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@18dcc86
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@6e84ad
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1c87a13
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@c6a26b
Pool thread stack traces:
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:562)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:562)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1026)
com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run----(ThreadPoolAsynchronousRunner.java:547)
----------------------------------------------------------------------------------------jdbc.properties配置如下 #jdbc.driverClassName=oracle.jdbc.OracleDriver
jdbc.url=jdbc:oracle:thin:portal20112/[email protected]:1521:orcl
jdbc.username=portal20112
jdbc.password=c0cd96fc4ce9f1972bd0e3cd9e6bd1fd7b5acfe515ed009ad90839acfbd73f34500eef5c463ea472
jdbc.driverClassName=oracle.jdbc.OracleDriver
#jdbc.url=jdbc:oracle:thin:portal20112/[email protected]:1521:mcitydb1
#jdbc.url=jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.199)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.251.147.114)(PORT = 1521))(FAILOVER=yes) (LOAD_BALANCE =off))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl))(FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC)(RETIRES = 10) (DELAY = 15)))
#jdbc.url=jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.250)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.251.147.114)(PORT = 1521))(FAILOVER=yes) (LOAD_BALANCE =off))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora490))(FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC)(RETIRES = 10) (DELAY = 15)))
#jdbc.username=eportal
#jdbc.password=eportal#jdbc.password=1e527c7638aa5e22c955cdee0a3d3776dec1f30fb46c9f332d8428f0491e928e3cb968634b590df3jdbc.autoCommit=true
jdbc.batch.size=10# Needed by Hibernate3 Maven Plugin defined in pom.xml
#hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
#hibernate.connection.username=newmms
#hibernate.connection.password=newmms
#hibernate.connection.url=jdbc:oracle:thin:newmms/[email protected]:1521:ora490
#hibernate.connection.driver_class=oracle.jdbc.OracleDriver
hibernate.dialect=org.hibernate.dialect.Oracle10gDialect--------------------------------------------------------------------------------bean配置: <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<property name="driverClass" value="${jdbc.driverClassName}" />
<property name="jdbcUrl" value="${jdbc.url}" />
<property name="user" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="acquireIncrement" value="5"></property>
<property name="initialPoolSize" value="5"></property>
<property name="maxPoolSize" value="20"></property>
<property name="maxIdleTime" value="300"></property>
</bean> 请高手抽点时间帮帮小弟解决这个问题
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@c22681 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@6e12d5 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@96613f (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@ca81dd
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@113daba
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@7d0bbd
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@18dcc86
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@6e84ad
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1c87a13
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@c6a26b
Pool thread stack traces:
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:562)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:562)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1026)
com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run----(ThreadPoolAsynchronousRunner.java:547)
----------------------------------------------------------------------------------------jdbc.properties配置如下 #jdbc.driverClassName=oracle.jdbc.OracleDriver
jdbc.url=jdbc:oracle:thin:portal20112/[email protected]:1521:orcl
jdbc.username=portal20112
jdbc.password=c0cd96fc4ce9f1972bd0e3cd9e6bd1fd7b5acfe515ed009ad90839acfbd73f34500eef5c463ea472
jdbc.driverClassName=oracle.jdbc.OracleDriver
#jdbc.url=jdbc:oracle:thin:portal20112/[email protected]:1521:mcitydb1
#jdbc.url=jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.199)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.251.147.114)(PORT = 1521))(FAILOVER=yes) (LOAD_BALANCE =off))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl))(FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC)(RETIRES = 10) (DELAY = 15)))
#jdbc.url=jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.250)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.251.147.114)(PORT = 1521))(FAILOVER=yes) (LOAD_BALANCE =off))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora490))(FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC)(RETIRES = 10) (DELAY = 15)))
#jdbc.username=eportal
#jdbc.password=eportal#jdbc.password=1e527c7638aa5e22c955cdee0a3d3776dec1f30fb46c9f332d8428f0491e928e3cb968634b590df3jdbc.autoCommit=true
jdbc.batch.size=10# Needed by Hibernate3 Maven Plugin defined in pom.xml
#hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
#hibernate.connection.username=newmms
#hibernate.connection.password=newmms
#hibernate.connection.url=jdbc:oracle:thin:newmms/[email protected]:1521:ora490
#hibernate.connection.driver_class=oracle.jdbc.OracleDriver
hibernate.dialect=org.hibernate.dialect.Oracle10gDialect--------------------------------------------------------------------------------bean配置: <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<property name="driverClass" value="${jdbc.driverClassName}" />
<property name="jdbcUrl" value="${jdbc.url}" />
<property name="user" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="acquireIncrement" value="5"></property>
<property name="initialPoolSize" value="5"></property>
<property name="maxPoolSize" value="20"></property>
<property name="maxIdleTime" value="300"></property>
</bean> 请高手抽点时间帮帮小弟解决这个问题
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货