求助 连接池的问题

[ysm010613]

在tomcat运行时报错

2008-09-13 13:01:06,593 [Thread-1] [org.hibernate.connection.ConnectionProviderFactory] [INFO] - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
2008-09-13 13:01:06,671 [Thread-1] [com.mchange.v2.c3p0.PoolBackedDataSource] [INFO] - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource@1f98d58[ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, description -> null, driverClass -> org.gjt.mm.mysql.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1f98d58, idleConnectionTestPeriod -> 900, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/bbscs7?useUnicode=true&characterEncoding=UTF-8, loginTimeout -> 0, maxIdleTime -> 600, maxPoolSize -> 50, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 2, numHelperThreads -> 10, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ]
2008-09-13 13:01:35,937 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#9] [com.mchange.v2.resourcepool.BasicResourcePool] [WARN] - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@6279d -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30).
2008-09-13 13:01:36,031 [Thread-1] [org.hibernate.util.JDBCExceptionReporter] [WARN] - SQL Error: 0, SQLState: null
2008-09-13 13:01:36,031 [Thread-1] [org.hibernate.util.JDBCExceptionReporter] [ERROR] - Connections could not be acquired from the underlying database!
2008-09-13 13:01:36,031 [Thread-1] [org.hibernate.cfg.SettingsFactory] [WARN] - Could not obtain connection metadata
java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:236)
at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)
at com.mchange.v2.c3p0.ComboPooledDataSource.getConnection(ComboPooledDataSource.java:521)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:825)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:751)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1091)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:396)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:233)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:145)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:277)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:313)
at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:139)
at org.springframework.web.struts.ContextLoaderPlugIn.createWebApplicationContext(ContextLoaderPlugIn.java:354)
at org.springframework.web.struts.ContextLoaderPlugIn.initWebApplicationContext(ContextLoaderPlugIn.java:297)
at org.springframework.web.struts.ContextLoaderPlugIn.init(ContextLoaderPlugIn.java:226)
at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:839)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:332)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4058)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4364)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:924)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:887)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1147)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232)
... 47 more



一直找不的原因，大家帮忙看一下 配置文件在下面：

[ysm010613]

spring的配置：

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" dependency-check="none">
<property name="driverClass">
<value>${datasource.driverClassName}</value>
</property>
<property name="jdbcUrl">
<value>${datasource.url}</value>
</property>
<property name="user">
<value>${datasource.username}</value>
</property>
<property name="password">
<value>${datasource.password}</value>
</property>
<property name="acquireIncrement">
<value>${c3p0.acquireIncrement}</value>
</property>
<property name="initialPoolSize">
<value>${c3p0.initialPoolSize}</value>
</property>
<property name="minPoolSize">
<value>${c3p0.minPoolSize}</value>
</property>
<property name="maxPoolSize">
<value>${c3p0.maxPoolSize}</value>
</property>
<property name="maxIdleTime">
<value>${c3p0.maxIdleTime}</value>
</property>
<property name="idleConnectionTestPeriod">
<value>${c3p0.idleConnectionTestPeriod}</value>
</property>
<property name="maxStatements">
<value>${c3p0.maxStatements}</value>
</property>
<property name="numHelperThreads">
<value>${c3p0.numHelperThreads}</value>
</property>
</bean>

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref local="dataSource"/>
</property>
<property name="mappingResources">
<list>
<value>com/laoer/bbscs/bean/UserInfo.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserDetail.hbm.xml</value>
<value>com/laoer/bbscs/bean/Config.hbm.xml</value>
<value>com/laoer/bbscs/bean/Board.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardMaster.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardTag.hbm.xml</value>
<value>com/laoer/bbscs/bean/Permission.hbm.xml</value>
<value>com/laoer/bbscs/bean/Role.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserGroup.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserOnline.hbm.xml</value>
<value>com/laoer/bbscs/bean/LoginError.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardPermission.hbm.xml</value>
<value>com/laoer/bbscs/bean/Friend.hbm.xml</value>
<value>com/laoer/bbscs/bean/Note.hbm.xml</value>
<value>com/laoer/bbscs/bean/BookMark.hbm.xml</value>
<value>com/laoer/bbscs/bean/Forum.hbm.xml</value>
<value>com/laoer/bbscs/bean/ForumHistory.hbm.xml</value>
<value>com/laoer/bbscs/bean/Subscibe.hbm.xml</value>
<value>com/laoer/bbscs/bean/AgreeAgainst.hbm.xml</value>
<value>com/laoer/bbscs/bean/Vote.hbm.xml</value>
<value>com/laoer/bbscs/bean/VoteItem.hbm.xml</value>
<value>com/laoer/bbscs/bean/VoteUser.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardSave.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardAuthUser.hbm.xml</value>
<value>com/laoer/bbscs/bean/Elite.hbm.xml</value>
<value>com/laoer/bbscs/bean/Commend.hbm.xml</value>
<value>com/laoer/bbscs/bean/ChoiceCategory.hbm.xml</value>
<value>com/laoer/bbscs/bean/Choice.hbm.xml</value>
<value>com/laoer/bbscs/bean/SysNumStat.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserTop.hbm.xml</value>
<value>com/laoer/bbscs/bean/ForumBuy.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserLevel.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
<prop key="hibernate.jdbc.fetch_size">${hibernate.jdbc.fetch_size}</prop>
<prop key="hibernate.jdbc.batch_size">${hibernate.jdbc.batch_size}</prop>
<!--<prop key="hibernate.proxool.pool_alias">bbscs7db</prop>
<prop key="hibernate.proxool.xml">proxool.xml</prop>
-->
<prop key="hibernate.connection.release_mode">${hibernate.connection.release_mode}</prop>
</props>
</property>
</bean>
<bean id="myTransactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>
<bean id="ajaxMessagesXML" class="com.laoer.bbscs.comm.AjaxMessagesXML" singleton="false"/>
<bean id="eliteXML" class="com.laoer.bbscs.service.db2xml.EliteXML" singleton="false"/>
<bean id="boardCache" class="com.laoer.bbscs.service.imp.OsCacheImp">
<constructor-arg>
<value>${cache.config}</value>
</constructor-arg>
</bean>
<bean id="userPermissionCache" class="com.laoer.bbscs.service.imp.OsCacheImp">
<constructor-arg>
<value>${cacheup.config}</value>
</constructor-arg>
</bean>
<bean id="scriptForumCache" class="com.laoer.bbscs.service.imp.OsCacheImp">
<constructor-arg>
<value>${cachefl.config}</value>
</constructor-arg>
</bean>


hibernate的配置是：

datasource.driverClassName=org.gjt.mm.mysql.Driver
datasource.url=jdbc:mysql://localhost:3306/bbscs7?useUnicode=true&characterEncoding=UTF-8
datasource.username=root
datasource.password=010613

datasource.maxActive=10
datasource.maxIdle=2
datasource.maxWait=120000
datasource.whenExhaustedAction=1
datasource.validationQuery=select 1 from dual
datasource.testOnBorrow=true
datasource.testOnReturn=false

c3p0.acquireIncrement=3
c3p0.initialPoolSize=3
c3p0.idleConnectionTestPeriod=900
c3p0.minPoolSize=2
c3p0.maxPoolSize=50
c3p0.maxStatements=100
c3p0.numHelperThreads=10
c3p0.maxIdleTime=600

#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
#hibernate.dialect=org.hibernate.dialect.MySQLMyISAMDialect
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.jdbc.batch_size=25
hibernate.jdbc.fetch_size=50
hibernate.show_sql=false
hibernate.connection.release_mode=after_transaction

bbscs.isloadconfig=false
bbscs.safePath=C:/tmp/

cache.config=oscache.properties
cacheup.config=oscache_up.properties
cachefl.config=oscache_fl.properties

[ysm010613]

自己顶咯

[guoxyj]

貌似hibernate的jar文件加载出错了

[ysm010613]

老鸟来看看呀