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|javax.enterprise.system.stream.out|_ThreadID=20;_ThreadName=Timer-9;|
  2. INFO - Allocating session for http://www.fromdev.com, 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. |#]
  6.  
  7. [#|2010-11-05T02:21:04.623-0700|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_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(BasicResourcePool.java:506)
  10. at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
  11. at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
  12. at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82)
  13. at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
  14. at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
  15. at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
  16. at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
  17. at org.hibernate.loader.Loader.doQuery(Loader.java:801)
  18. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
  19. at org.hibernate.loader.Loader.doList(Loader.java:2533)
  20. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
  21. at org.hibernate.loader.Loader.list(Loader.java:2271)
  22. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
  23. at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
  24. at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
  25. at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
  26. at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
  27. at com.fromdev.alerts.AlertJob.execute(AlertJob.java:51)
  28. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  29. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  30. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  31. at java.lang.reflect.Method.invoke(Method.java:597)
  32. at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:276)
  33. at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:260)
  34. at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
  35. at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
  36. at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
  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.