I'm using Struts & Hibernate in my project. But the problem comes when I'm trying to deploy the project into our Server & access it by more than 100 people simultaneously. Its the case of failure of pooling.

After that I've tried to implement C3P0 connection Pooling. But the doubt is how can I implement C3P0 with Struts & Hibernate in my Web application.

When using simple DBCP Connection Pooling with StrutsDAO design pattern we need to initialize that in our custom ActionServlet class which extends ActionServlet of Struts.

In Hibernate I've clubbed the C3P0 codes into hibernateCfg.xml file. But how to initialize that ???? How can it handle the pooling ???

Any views, any suggestions are widely appreciable.... So members please help.....

Any one solve this......

Hibernate recognizes C3PO as connection pool by just checking the hibernate config for existence of C3PO properties. IIRC its c3p0.max_size, which triggers the activation.

So you don't have to initialize it in your source code. You just have to configure it + get the C3PO jar to the classpath.

But how can the Web application know that there is a connection pool attached to Hibernate !!!! How can it create the pool & how will we manage the pool ????


Anyone please reply.......