Java Hibernate / C3P0錯誤：“無法獲取連接元數(shù)據(jù)。客戶端嘗試檢出Connection的嘗試已超時?！?/h1>
瀏覽：265日期：2024-04-21 11:10:58
如何解決Java Hibernate / C3P0錯誤：“無法獲取連接元數(shù)據(jù)。客戶端嘗試檢出Connection的嘗試已超時?！?？如果您將C3P0的“ checkoutTimeout”屬性設置為非0的值，則可能是超時太快了（這是我的問題，解決方案：將其從500提高到2000毫秒）。
或者，有一種解決此警告的方法：
將hibernate.temp.use_jdbc_Metadata_defaults屬性設置為false。
在http://www.docjar.com/html/api/org/hibernate/cfg/SettingsFactory.java.html中可以找到此內容，但是如果不使用Hibernate提取JDBCMetadata默認值可能會產生副作用。
解決方法 我正在嘗試獲取一些傳遞并運行的代碼。它似乎使用了Hibernate框架。我已經(jīng)克服了調整配置時的大多數(shù)錯誤，但這使我陷入了困境。
它正在嘗試連接到兩個數(shù)據(jù)庫：gameapp和gamelog。兩者都存在。似乎有問題連接到gamelog，但沒有問題連接到gameapp（在init之后，它可以連接并加載其他數(shù)據(jù)庫就很好了）。在下面，我粘貼了錯誤和異常堆棧轉儲。
我想像一下配置中還有其他內容，所以我還包括了該數(shù)據(jù)庫的配置文件。我知道這很模糊，但是我希望一些專業(yè)人士可以看到我所缺少的愚蠢錯誤。
<?xml version='1.0' encoding='GBK'?><!DOCTYPE hibernate-configuration PUBLIC '-//Hibernate/Hibernate Configuration DTD 3.0//EN' 'http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd'><hibernate-configuration> <session-factory><property name='dialect'>org.hibernate.dialect.MySQLDialect</property><property name='connection.driver_class'>com.mysql.jdbc.Driver</property><property name='connection.url'>jdbc:mysql://127.0.0.1:3306/gamelog</property><property name='connection.username'>root</property><property name='connection.password'></property><property name='connection.useUnicode'>true</property> <property name='connection.characterEncoding'>UTF-8</property> <property name='hibernate.jdbc.batch_size'>100</property><property name='jdbc.fetch_size'>1</property><property name='hbm2ddl.auto'>none</property><!-- update --><property name='connection.useUnicode'>true</property><property name='show_sql'>true</property><!-- c3p0-configuration --><property name='hibernate.connection.provider_class'>org.hibernate.connection.C3P0ConnectionProvider</property> <property name='hibernate.c3p0.min_size'>5</property><property name='hibernate.c3p0.max_size'>10</property><property name='hibernate.c3p0.timeout'>30</property><property name='hibernate.c3p0.idle_test_period'>30</property><property name='hibernate.c3p0.max_statements'>0</property><property name='hibernate.c3p0.acquire_increment'>5</property> </session-factory></hibernate-configuration>
異常和堆棧跟蹤：
2010-04-30 17:50:00,411 WARN [org.hibernate.cfg.SettingsFactory] - Could not obtain connection metadatajava.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.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:35) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1933) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1216) at com.database.hibernate.util.HibernateFactory.<init>(Unknown Source) at com.database.hibernate.util.HibernateUtil.<clinit>(Unknown Source) at com.server.databaseop.goodOp.GoodOpImpl.initBreedGoods(Unknown Source) at com.server.databaseop.goodOp.GoodOpImpl.access$000(Unknown Source) at com.server.databaseop.goodOp.GoodOpImpl$1.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:165) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:267) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:636)Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@ca470 -- timeout at awaitAvailable() at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1317) 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) ... 18 more
標簽：
java
上一條：原因：java.lang.IllegalStateException：找到了模糊的映射。無法映射“ appController” Bean方法下一條：Powershell加載dll錯誤：Add-Type：無法加載文件或程序集“ WebDriver.dll”或其依賴項之一。不支持操作
相關文章：
1. javascript - sublime快鍵鍵問題2. javascript - immutable配合react提升性能？3. Apache 已經(jīng)把網(wǎng)站根目錄的改為allow from all了，但是服務器還是不能訪問？4. javascript - nodejs關于進程間發(fā)送句柄的一點疑問5. css - 寫頁面遇到個布局問題，求大佬們幫解答，在線等，急！~6. 實現(xiàn)bing搜索工具urlAPI提交7. javascript - 移動端上不能實現(xiàn)拖拽布局嗎？8. vue.js - Vue 如何像Angular.js watch 一樣監(jiān)聽數(shù)據(jù)變化9. 配置Apache時，添加對PHP的支持時語法錯誤10. phpstudy8.1支持win11系統(tǒng)嗎？
如果您將C3P0的“ checkoutTimeout”屬性設置為非0的值，則可能是超時太快了（這是我的問題，解決方案：將其從500提高到2000毫秒）。
或者，有一種解決此警告的方法：
將hibernate.temp.use_jdbc_Metadata_defaults屬性設置為false。
在http://www.docjar.com/html/api/org/hibernate/cfg/SettingsFactory.java.html中可以找到此內容，但是如果不使用Hibernate提取JDBCMetadata默認值可能會產生副作用。
解決方法我正在嘗試獲取一些傳遞并運行的代碼。它似乎使用了Hibernate框架。我已經(jīng)克服了調整配置時的大多數(shù)錯誤，但這使我陷入了困境。
它正在嘗試連接到兩個數(shù)據(jù)庫：gameapp和gamelog。兩者都存在。似乎有問題連接到gamelog，但沒有問題連接到gameapp（在init之后，它可以連接并加載其他數(shù)據(jù)庫就很好了）。在下面，我粘貼了錯誤和異常堆棧轉儲。
我想像一下配置中還有其他內容，所以我還包括了該數(shù)據(jù)庫的配置文件。我知道這很模糊，但是我希望一些專業(yè)人士可以看到我所缺少的愚蠢錯誤。
<?xml version='1.0' encoding='GBK'?><!DOCTYPE hibernate-configuration PUBLIC '-//Hibernate/Hibernate Configuration DTD 3.0//EN' 'http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd'><hibernate-configuration> <session-factory><property name='dialect'>org.hibernate.dialect.MySQLDialect</property><property name='connection.driver_class'>com.mysql.jdbc.Driver</property><property name='connection.url'>jdbc:mysql://127.0.0.1:3306/gamelog</property><property name='connection.username'>root</property><property name='connection.password'></property><property name='connection.useUnicode'>true</property> <property name='connection.characterEncoding'>UTF-8</property> <property name='hibernate.jdbc.batch_size'>100</property><property name='jdbc.fetch_size'>1</property><property name='hbm2ddl.auto'>none</property><!-- update --><property name='connection.useUnicode'>true</property><property name='show_sql'>true</property><!-- c3p0-configuration --><property name='hibernate.connection.provider_class'>org.hibernate.connection.C3P0ConnectionProvider</property> <property name='hibernate.c3p0.min_size'>5</property><property name='hibernate.c3p0.max_size'>10</property><property name='hibernate.c3p0.timeout'>30</property><property name='hibernate.c3p0.idle_test_period'>30</property><property name='hibernate.c3p0.max_statements'>0</property><property name='hibernate.c3p0.acquire_increment'>5</property> </session-factory></hibernate-configuration>
異常和堆棧跟蹤：
2010-04-30 17:50:00,411 WARN [org.hibernate.cfg.SettingsFactory] - Could not obtain connection metadatajava.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.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:35) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1933) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1216) at com.database.hibernate.util.HibernateFactory.<init>(Unknown Source) at com.database.hibernate.util.HibernateUtil.<clinit>(Unknown Source) at com.server.databaseop.goodOp.GoodOpImpl.initBreedGoods(Unknown Source) at com.server.databaseop.goodOp.GoodOpImpl.access$000(Unknown Source) at com.server.databaseop.goodOp.GoodOpImpl$1.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:165) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:267) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:636)Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@ca470 -- timeout at awaitAvailable() at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1317) 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) ... 18 more
網(wǎng)公網(wǎng)安備