It is certainly inconsistent with a Connection pool, the philosophy of which is that Connections should be acquired from the pool when they are needed and returned to the pool [by calling close ] as soon as a unit of work is done. Right now, your singleton Connection will timeout, and there is nothing c3p0 can do about it. Connection pools manage and test Connections when they are checked into the pool. When they are checked out, the pool tries to stay out of the way and not interfere with the client.
It looks like it is not a java. Connection after all, because you have a static field called "em" in Connection. So it is hard to interpret what's going on. Broadly, you want a single c3p0 DataSource, and to acquire Connections as-needed and to close them as promptly as possible.
To prevent Connection timeouts like you are seeing, the best approach a Connection testing regime. The easiest approach would be to set Once you have that working, you can enhance the performance a bit by using testConnectionOnCheckin and idleConnectionTestPeriod or hibernate. It makes no sense to have your idleConnectionTestPeriod hibernate. Idle connections will never be tested; they'll expire before they get the chance.
Try connecting to Database using some other tool, MySQL Workbench or from console, at the time you get this exception. You should rater configure you a datasource. Otherwise there is much trouble with the interaction of spring an c3o0. Stack Overflow for Teams — Collaborate and share knowledge with a private group.
Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Hibernate, c3p0, and Mysql, spring Ask Question. Asked 8 years, 10 months ago.
In this article we provide you Hibernate 5. New features in Hibernate version 5. Download Hibernate 5. After downloading zip it and then include required jar files in your project. Here are the list of jar files included in Hibernate 5. Hibernate tutorials links: Check all the Hibernate 5 tutorials.
Check all the Hibernate Tutorials for beginners. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Visit chat. Linked 2. Related Hot Network Questions. Question feed.
0コメント