求助,tomcat起动时,联接SQLServer2000异常
2008-6-18 16:11:04 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
信息: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.5.0_06\bin;D:\lucky.li\Tomcat 5.5\bin
2008-6-18 16:11:04 org.apache.coyote.http11.Http11BaseProtocol init
信息: Initializing Coyote HTTP/1.1 on http-8080
2008-6-18 16:11:04 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 1016 ms
2008-6-18 16:11:04 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2008-6-18 16:11:04 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/5.5.26
2008-6-18 16:11:04 org.apache.catalina.core.StandardHost start
信息: XML validation disabled
2008-6-18 16:11:05 org.apache.catalina.loader.WebappClassLoader validateJarFile
信息: validateJarFile(D:\lucky.li\Tomcat 5.5\webapps\applatform\WEB-INF\lib\servlet-api.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
log4j:WARN No appenders could be found for logger (org.apache.commons.digester.Digester.sax).
log4j:WARN Please initialize the log4j system properly.
16:11:35,156 WARN org.hibernate.util.JDBCExceptionReporter:77 - SQL Error: 0, SQLState: null
16:11:35,156 ERROR org.hibernate.util.JDBCExceptionReporter:78 - An attempt by a client to checkout a Connection has timed out.
16:11:35,156 WARN org.hibernate.cfg.SettingsFactory:117 - Could not obtain connection metadata
java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:527)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:753)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:691)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1390)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1359)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:540)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:485)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:455)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:169)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:170)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:407)
[解决办法]
1.我觉得你可能是连接池配置有问题。
2.用完连接没有放回连接池。
3.升级相关spring和hibernate的jar包。
4.数据库或者网络有问题。
[解决办法]
连接池获取不到可用的连接。。。。
你连接池在哪里配的？
用完了以后有没有放回去？
仔细看下吧。。。也有可能忽然间网段了。。。连接出现问题。。。
[解决办法]
升级相关spring和hibernate的jar包
[解决办法]
配置的问题吧
jdbc的包导入了吗?
如果导入了工程里
最好也导入到tomcat里去
有时候tomcat也不稳定!
所以连接不上!
把jdbc的jar包导入到D:\Tomcat_5.0\common\lib(例如我的)下
[解决办法]
A ResourcePool could not acquire a resource from its primary factory or source.
连接池无法获得资源。估计连接池配置有问题吧
