本文介绍了通过JNDI Datasource配置hibernate连接数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
Hi all 我使用Hibernate + Struts2 + Tomcat6 + Mysql作为我的J2EE框架。我一直在使用hibernate的内置连接池机制，但事实证明，在8小时后mysql关闭它的连接的时候会出现问题。无论如何，我搜索了一下，发现我应该通过JNDI数据源获得我的连接，但我无法就此获得一个很好且完整的教程。我应该采取哪些措施来做到这一点？请给我足够的细节，我在这方面有点新鲜。 这里是我的hibernate.cfg.xml
<？xml version =1.0encoding =UTF- 8\" >？; <！DOCTYPE hibernate-configuration PUBLIC - // Hibernate / Hibernate Configuration DTD 3.0 // ENhibernate.sourceforge/hibernate-configuration-3.0.dtd\"> < hibernate-configuration> < session-factory> < property name =connection.driver_class> com.mysql.jdbc.Driver< / property> < property name =hibernate.connection.url> jdbc：mysql：// localhost / hposg？characterEncoding = UTF-8 < / property> < property name =connection.username> root< / property> < property name =connection.password>< / property> < property name =show_sql> true< / property> < property name =dialect> org.hibernate.dialect.MySQLDialect< / property> < property name =current_session_context_class>线程< / property> < property name =cache.provider_class> org.hibernate.cache.NoCacheProvider< / property> < property name =hbm2ddl.auto>更新< / property> < property name =hibernate.max_fetch_depth> 3< / property> < property name =hibernate.connection.provider_class> org.hibernate.connection.C3P0ConnectionProvider< / property> < property name =hibernate.c3p0.acquire_increment> 2< / property> < property name =hibernate.c3p0.idle_test_period> 300< / property> < property name =hibernate.c3p0.timeout> 1800< / property> < property name =hibernate.c3p0.max_size> 25< / property> < property name =hibernate.c3p0.min_size> 3< / property> < property name =hibernate.c3p0.max_statement> 0< / property> < property name =hibernate.c3p0.preferredTestQuery> select 1;< / property> < property name =hibernate.c3p0.testConnectionOnCheckout> true< / property> < property name =hibernate.c3p0.validate> true< / property> <！ - 映射文件 - > < mapping resource =com / hposg / hibernate / resources / Player.hbm.xml/> < mapping resource =com / hposg / hibernate / resources / Game.hbm.xml/> ... < / session-factory> < / hibernate-configuration>我也试过这个，但没有成功：创建一个context.xml在WebContent / META-INF中包含：
< Context path =docBase =../ RSGamesdebug = 0reloadable =true> < Resource name =jdbc / RSGamesauth =Containertype =javax.sql.DataSource username =root password = driverClassName =com.mysql.jdbc.Driver url =jdbc：mysql：// localhost：3306 / hposg？autoReconnect = true& amp; useUnicode = true& amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; =15 maxIdle =7 validationQuery =Select 1/> < / Context>将其放入web.xml中：
<资源引用> < description>连接池< / description> < res-ref-name> jdbc / RSGames< / res-ref-name> < res-type> javax.sql.Datasource< / res-type> < res-auth>容器< / res-auth> < / resource-ref>并修改这样的hibernate配置：
<？xml version =1.0encoding =UTF-8？> <！DOCTYPE hibernate-configuration PUBLIC - // Hibernate / Hibernate Configuration DTD 3.0 // ENhibernate.sourceforge/hibernate-configuration-3.0.dtd\"> < hibernate-configuration> < session-factory> ... < property name =connection.datasource> java：comp / env / jdbc / RSGames< / property> ... < / session-factory> < / hibernate-configuration>就像我之前提到的那样，它不会以这种方式连接到数据库。任何想法？
当我执行应用程序时，我得到这个异常：
2011年3月16日上午12点29分13秒com.mchange.v2.resourcepool.BasicResourcePool $ AcquireTask运行警告：com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1f18cbe - 收购尝试失败！清理未完成的采集。在尝试获取所需的新资源时，我们未能成功超过允许的最大收购尝试次数（30）。最后一次获取尝试异常： sun.jdbc.odbc.JdbcOdbcDriver.getProtocol（Unknown Source）处的在sun.jdbc.odbc.JdbcOdbcDriver.knownURL处的（未知源）java.lang.NullPointerException 在sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL（来源不明）在java.sql.DriverManager.getDriver（来源不明）在com.mchange.v2.c3p0.DriverManagerDataSource.driver （DriverManagerDataSource.java:224） at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection（DriverManagerDataSource.java:120） at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection（WrapperConnectionPoolDataSource.java ：143） at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection（WrapperConnectionPoolDataSource.java:132） at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool $ 1PooledConnectionResourcePoolManager.acquireResource（C3P0PooledConnectionPool.java ：137）在com.mchange.v2.resourcepool.BasicResourcePool.do在com.mchange.v2.resourcepool.BasicResourcePool.access获取（BasicResourcePool.java:1014） $ 800（BasicResourcePool.java:32）在com.mchange.v2.resourcepool.BasicResourcePool $ AcquireTask.run （BasicResourcePool.java:1810） at com.mchange.v2.async.ThreadPoolAsynchronousRunner $ PoolThread.run（ThreadPoolAsynchronousRunner.java:547）三月16，2011 12:29:13 AM com.mchange。 v2.resourcepool.BasicResourcePool $ AcquireTask运行警告：com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@14f1726 - 购置尝试失败!!!清理未完成的采集。在尝试获取所需的新资源时，我们未能成功超过允许的最大收购尝试次数（30）。最后一次获取尝试异常： sun.jdbc.odbc.JdbcOdbcDriver.getProtocol（Unknown Source）处的在sun.jdbc.odbc.JdbcOdbcDriver.knownURL处的（未知源）java.lang.NullPointerException at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL（Unknown Source） at java.sql.DriverManager.getDriver（Unknown Source） at com.mchange.v2.c3p0.DriverManagerDataSource.driver （DriverManagerDataSource.java:224） at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection（DriverManagerDataSource.java:120） at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection（WrapperConnectionPoolDataSource.java ：143） at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection（WrapperConnectionPoolDataSource.java:132） at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool $ 1PooledConnectionResourcePoolManager.acquireResource（C3P0PooledConnectionPool.java ：137）在com.mchange.v2.resourcepool.BasicResourcePool.do在com.mchange.v2.resourcepool.BasicResourcePool.access获取（BasicResourcePool.java:1014） $ 800（BasicResourcePool.java:32）在com.mchange.v2.resourcepool.BasicResourcePool $ AcquireTask.run （BasicResourcePool.java:1810） at com.mchange.v2.async.ThreadPoolAsynchronousRunner $ PoolThread.run（ThreadPoolAsynchronousRunner.java:547）三月16，2011 12:29:13 AM com.mchange。 v2.resourcepool.BasicResourcePool $ AcquireTask运行警告：com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@cad437 - 采集尝试失败!!!清理未完成的采集。在尝试获取所需的新资源时，我们未能成功超过允许的最大收购尝试次数（30）。最后一次获取尝试异常： sun.jdbc.odbc.JdbcOdbcDriver.getProtocol（Unknown Source）处的在sun.jdbc.odbc.JdbcOdbcDriver.knownURL处的（未知源）java.lang.NullPointerException at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL（Unknown Source） at java.sql.DriverManager.getDriver（Unknown Source） at com.mchange.v2.c3p0.DriverManagerDataSource.driver （DriverManagerDataSource.java:224） at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection（DriverManagerDataSource.java:120） at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection（WrapperConnectionPoolDataSource.java ：143） at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection（WrapperConnectionPoolDataSource.java:132） at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool $ 1PooledConnectionResourcePoolManager.acquireResource（C3P0PooledConnectionPool.java ：137）在com.mchange.v2.resourcepool.BasicResourcePool.do在com.mchange.v2.resourcepool.BasicResourcePool.access获取（BasicResourcePool.java:1014） $ 800（BasicResourcePool.java:32）在com.mchange.v2.resourcepool.BasicResourcePool $ AcquireTask.run （BasicResourcePool.java:1810） at com.mchange.v2.async.ThreadPoolAsynchronousRunner $ PoolThread.run（ThreadPoolAsynchronousRunner.java:547） 29994 [http-8081-3] WARN org.hibernate.cfg .SettingsFactory - 无法获取到查询元数据的连接 java.sql.SQLException：无法从底层数据库获取连接！ at com.mchange.v2.sql.SqlUtils.toSQLException（SqlUtils.java:106） at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection（C3P0PooledConnectionPool.java:529） at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection（AbstractPoolBackedDataSource.java:128） at org.hibernate.connection.C3P0ConnectionProvider.getConnection（C3P0ConnectionProvider.java:78） at org .hibernate.cfg.SettingsFactory.buildSettings（SettingsFactory.java:114）在org.hibernate.cfg.Configuration.buildSettingsInternal（Configuration.java:2163）在org.hibernate.cfg.Configuration.buildSettings （Configuration.java:2159）在org.hibernate.cfg.Configuration.buildSessionFactory（Configuration.java:1383）在com.hposg.hibernate.util.HibernateUtil.buildSessionFactory（HibernateUtil.java:12 ）在com.hposg.hibernate.util.HibernateUtil。< clinit>（HibernateUtil.java:7） at com.hposg.login.LoginFactory.doLogin （LoginFactory.java:25） at com.hposg.controller.struts.LoginAction.execute（LoginAction.java:59） at sun.reflect.NativeMethodAccessorImpl.invoke0（Native Method）在sun.reflect.NativeMethodAccessorImpl.invoke（来源不明）在sun.reflect.DelegatingMethodAccessorImpl.invoke（来源不明）在java.lang.reflect.Method.invoke（来源不明）在com.opensymphony.xwork2.DefaultActionInvocation.invokeAction（DefaultActionInvocation.java:441） at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly（DefaultActionInvocation.java:280） at com.opensymphony.xwork2.DefaultActionInvocation .invoke（DefaultActionInvocation.java:243） at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept（DefaultWorkflowInterceptor.java:165） at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept（MethodFilterInterceptor .java：87） at com.opensymphony.xwork2.DefaultActionInvocatio n.invoke（DefaultActionInvocation.java:237）处org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept（ValidationInterceptor.java:252）。 doIntercept（AnnotationValidationInterceptor.java:68） at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept（MethodFilterInterceptor.java:87） at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java： 237）在com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept（ConversionErrorInterceptor.java:122）在com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:237）在com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept（ParametersInterceptor.java:195）在com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept（MethodFilterInterceptor.java:87）在com.opensymphony .xwork2.De faultActionInvocation.invoke（DefaultActionInvocation.java:237） at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept（ParametersInterceptor.java:195） at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept（ MethodFilterInterceptor.java:87） at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:237） at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept（StaticParametersInterceptor.java:179）在com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:237） 在org.apache.struts2.interceptor.MultiselectInterceptor.intercept（MultiselectInterceptor.java:75）。在COM .opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:237）在org.apache.struts2.interceptor.CheckboxInterceptor.intercept（CheckboxInterceptor.java:94）在com.opensymphony.xwork2.DefaultActionInvocation .invoke（德发ultActionInvocation.java:237）美元，org.apache.struts2.interceptor.FileUploadInterceptor.intercept（FileUploadInterceptor.java:235 B $ B）在com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:237） at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept（ModelDrivenInterceptor.java:89） at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:237） at com .opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept（ScopedModelDrivenInterceptor.java:130） at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:237） at org.apache.struts2.interceptor .debugging.DebuggingInterceptor.intercept（DebuggingInterceptor.java:267） at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:237） at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept （ChainingInterceptor.java:12 6） at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:237） at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept（PrepareInterceptor.java:138）在com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept（MethodFilterInterceptor.java:87） at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:237） at com.opensymphony.xwork2 .interceptor.I18nInterceptor.intercept（I18nInterceptor.java:165） at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:237） at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept （ServletConfigInterceptor.java:164）在com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation.java:237） 在com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept（AliasInterceptor.java:179 ）在com.opensymphony.xwork2.DefaultActionInvoca tion.invoke（DefaultActionInvocation.java:237） at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept（ExceptionMappingInterceptor.java:176） at com.opensymphony.xwork2.DefaultActionInvocation.invoke（DefaultActionInvocation。 Java的：237），美元，org.apache.struts2.impl.StrutsActionProxy.execute（StrutsActionProxy.java:52 b $ b）在org.apache.struts2.dispatcher.Dispatcher.serviceAction（Dispatcher.java:488） at org.apache.struts2.dispatcher.FilterDispatcher.doFilter（FilterDispatcher.java:395） at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:235）在org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:206） at org.apache.catalina.core.StandardWrapperValve.invoke（StandardWrapperValve.java:233） at org.apache .catalina.core.StandardContextValve.invoke（StandardContextValve.java:191） at org.apache.catalina.core.StandardHostValv e.invoke（StandardHostValve.java:128）在org.apache.catalina.valves.ErrorReportValve.invoke（ErrorReportValve.java:102）在org.apache.catalina.core.StandardEngineValve.invoke（ StandardEngineValve.java:109） at org.apache.catalina.connector.CoyoteAdapter.service（CoyoteAdapter.java:286） at org.apache.coyote.http11.Http11Processor.process（Http11Processor.java： 845） at org.apache.coyote.http11.Http11Protocol $ Http11ConnectionHandler.process（Http11Protocol.java:583） at org.apache.tomcat.util.JIoEndpoint $ Worker.run（JIoEndpoint。 java：447）在java.lang.Thread.run（未知源）由com.mchange.v2.resourcepool.CannotAcquireResourceException引起：ResourcePool无法从其主工厂或源获取资源。在com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable（BasicResourcePool.java:1319） 在com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource（BasicResourcePool.java:557） at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource（BasicResourcePool.java:477） at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection（C3P0PooledConnectionPool.java:525） .. 。74 more解决方案
显然，你做得对。但是，这里列出了一些您需要的工作应用程序示例： $ b $ 1）META-INF中的context.xml文件，指定您的数据源：
<上下文> < Resource name =jdbc / DsWebAppDB auth =Container type =javax.sql.DataSource username =sa password = driverClassName =org.h2.Driver url =jdbc：h2：mem：target / test / db / h2 / hibernate maxActive = 8 maxIdle =4/> < / Context>2）web.xml告诉容器你正在使用这个资源：
< resource-env-ref> < resource-env-ref-name> jdbc / DsWebAppDB< / resource-env-ref-name> < resource-env-ref-type> javax.sql.DataSource< / resource-env-ref-type> < / resource-env-ref>3）使用数据源的Hibernate配置。在这种情况下，它是一个 persistence.xml ，但它在 hibernate.cfg.xml中是相似的
< persistence-unit name =dswebapp> < provider> org.hibernate.ejb.HibernatePersistence< / provider> <属性> < property name =hibernate.dialectvalue =org.hibernate.dialect.H2Dialect/> < property name =hibernate.connection.datasourcevalue =java：comp / env / jdbc / DsWebAppDB/> < / properties> < / persistence-unit>
Hi all I'm using Hibernate+Struts2+Tomcat6+Mysql as my J2EE framework. I've been using hibernate's built-in connection pooling mechanism but it turned out to be problematic where mysql closes it's connections after 8 hours. Anyway I googled around a little bit and found that I should get my connections through JNDI datasource but I couldn't reach a good and complete tutorial on this. What steps should I take to do so? please provide me enough of details, I'm kinda new on this. here is my hibernate.cfg.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "hibernate.sourceforge/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.url"> jdbc:mysql://localhost/hposg?characterEncoding=UTF-8 </property> <property name="connection.username">root</property> <property name="connection.password"></property> <property name="show_sql">true</property> <property name="dialect">org.hibernate.dialect.MySQLDialect</property> <property name="current_session_context_class">thread</property> <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property> <property name="hbm2ddl.auto">update</property> <property name="hibernate.max_fetch_depth">3</property> <property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property> <property name="hibernate.c3p0.acquire_increment">2</property> <property name="hibernate.c3p0.idle_test_period">300</property> <property name="hibernate.c3p0.timeout">1800</property> <property name="hibernate.c3p0.max_size">25</property> <property name="hibernate.c3p0.min_size" >3</property> <property name="hibernate.c3p0.max_statement">0</property> <property name="hibernate.c3p0.preferredTestQuery">select 1;</property> <property name="hibernate.c3p0.testConnectionOnCheckout">true</property> <property name="hibernate.c3p0.validate">true</property> <!-- Mapping files --> <mapping resource="com/hposg/hibernate/resources/Player.hbm.xml"/> <mapping resource="com/hposg/hibernate/resources/Game.hbm.xml"/> ... </session-factory> </hibernate-configuration>I also tried this but it didn't work out: Creating a context.xml in WebContent/META-INF containing:
<Context path="" docBase="../RSGames" debug="0" reloadable="true"> <Resource name="jdbc/RSGames" auth="Container" type="javax.sql.DataSource" username="root" password="" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/hposg?autoReconnect=true&useUnicode=true&characterEncoding=utf8" maxActive="15" maxIdle="7" validationQuery="Select 1" /> </Context>putting this in web.xml:
<resource-ref> <description>Connection Pool</description> <res-ref-name>jdbc/RSGames</res-ref-name> <res-type>javax.sql.Datasource</res-type> <res-auth>Container</res-auth> </resource-ref>and modifying hibernate config like this:
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "hibernate.sourceforge/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> ... <property name="connection.datasource">java:comp/env/jdbc/RSGames</property> ... </session-factory> </hibernate-configuration>as I mentioned before, it doesn't get connected to database this way. any ideas?
[EDIT] When I execute the app I get this exception:
Mar 16, 2011 12:29:13 AM com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run WARNING: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1f18cbe -- 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). Last acquisition attempt exception: java.lang.NullPointerException at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(Unknown Source) at java.sql.DriverManager.getDriver(Unknown Source) at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:224) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:120) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) Mar 16, 2011 12:29:13 AM com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run WARNING: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@14f1726 -- 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). Last acquisition attempt exception: java.lang.NullPointerException at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(Unknown Source) at java.sql.DriverManager.getDriver(Unknown Source) at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:224) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:120) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) Mar 16, 2011 12:29:13 AM com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run WARNING: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@cad437 -- 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). Last acquisition attempt exception: java.lang.NullPointerException at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(Unknown Source) at java.sql.DriverManager.getDriver(Unknown Source) at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:224) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:120) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) 29994 [http-8081-3] WARN org.hibernate.cfg.SettingsFactory - Could not obtain connection to query metadata java.sql.SQLException: Connections could not be acquired from the underlying database! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128) at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:78) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:114) at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2163) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1383) at com.hposg.hibernate.util.HibernateUtil.buildSessionFactory(HibernateUtil.java:12) at com.hposg.hibernate.util.HibernateUtil.<clinit>(HibernateUtil.java:7) at com.hposg.login.LoginFactory.doLogin(LoginFactory.java:25) at com.hposg.controller.struts.LoginAction.execute(LoginAction.java:59) 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 com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441) at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243) at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252) at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488) at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) 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.awaitAvailable(BasicResourcePool.java:1319) at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557) at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525) ... 74 more解决方案
Apparently, you did it right. But here is a list of things you'll need with examples from a working application:
1) A context.xml file in META-INF, specifying your data source:
<Context> <Resource name="jdbc/DsWebAppDB" auth="Container" type="javax.sql.DataSource" username="sa" password="" driverClassName="org.h2.Driver" url="jdbc:h2:mem:target/test/db/h2/hibernate" maxActive="8" maxIdle="4"/> </Context>2) web.xml which tells the container that you are using this resource:
<resource-env-ref> <resource-env-ref-name>jdbc/DsWebAppDB</resource-env-ref-name> <resource-env-ref-type>javax.sql.DataSource</resource-env-ref-type> </resource-env-ref>3) Hibernate configuration which consumes the data source. In this case, it's a persistence.xml, but it's similar in hibernate.cfg.xml
<persistence-unit name="dswebapp"> <provider>org.hibernate.ejb.HibernatePersistence</provider> <properties> <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect" /> <property name="hibernate.connection.datasource" value="java:comp/env/jdbc/DsWebAppDB"/> </properties> </persistence-unit>
更多推荐
通过JNDI Datasource配置hibernate连接数据库
发布评论