By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,654 Members | 1,517 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,654 IT Pros & Developers. It's quick & easy.

c3p0 error - A checked-out resource is overdue. Why please tell me checking the code.

P: 3
I am trying to maintain an existing application and seeing some errors in the log file. Not sure what do these mean, Please suggest what could be causing this?

Expand|Select|Wrap|Line Numbers
  1. INFO - sun-appserver9.1||_ThreadID=20;_ThreadName=Timer-9;|
  2. INFO - Allocating session for, opening...
  3. INFO - Preparing Firefox profile...
  4. INFO BasicResourcePool :1392 A checked-out resource is overdue, and will be destroyed: com.mchange.v2.c3p0.impl.NewPooledConnection@1ee23c7
  5. |#]
  7. [#|2010-11-05T02:21:04.623-0700|INFO|sun-appserver9.1||_ThreadID=20;_ThreadName=Timer-9;|02:21:04,623 INFO BasicResourcePool :1395 Logging the stack trace by which the overdue resource was checked-out.
  8. java.lang.Exception: DEBUG ONLY: Overdue resource check-out stack trace.
  9. at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(
  10. at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(
  11. at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(
  12. at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(
  13. at org.hibernate.jdbc.ConnectionManager.openConnection(
  14. at org.hibernate.jdbc.ConnectionManager.getConnection(
  15. at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(
  16. at org.hibernate.loader.Loader.prepareQueryStatement(
  17. at org.hibernate.loader.Loader.doQuery(
  18. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(
  19. at org.hibernate.loader.Loader.doList(
  20. at org.hibernate.loader.Loader.listIgnoreQueryCache(
  21. at org.hibernate.loader.Loader.list(
  22. at org.hibernate.loader.hql.QueryLoader.list(
  23. at org.hibernate.hql.ast.QueryTranslatorImpl.list(
  24. at org.hibernate.engine.query.HQLQueryPlan.performList(
  25. at org.hibernate.impl.SessionImpl.list(
  26. at org.hibernate.impl.QueryImpl.list(
  27. at com.fromdev.alerts.AlertJob.execute(
  28. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  29. at sun.reflect.NativeMethodAccessorImpl.invoke(
  30. at sun.reflect.DelegatingMethodAccessorImpl.invoke(
  31. at java.lang.reflect.Method.invoke(
  32. at org.springframework.util.MethodInvoker.invoke(
  33. at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(
  34. at org.springframework.scheduling.quartz.QuartzJobBean.execute(
  35. at
  36. at org.quartz.simpl.SimpleThreadPool$
  37. |#]
please check it, if it is fixed.
Jul 22 '12 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.