Re: Hibernate with Cocoon connection pool

[Upayavira <uv...@upaya.co.uk>]

I had a similar problem and sorted it by using C3P0. 

Put the following, or equivalent, into your properties file:

        <property name="c3p0.max_size">2</property>
        <property name="c3p0.min_size">10</property>
        <property name="c3p0.timeout">5000</property>
        <property name="c3p0.max_statements">100</property>
        <property name="c3p0.validate">false</property>

And c3p0 will be used instead.

Regards, Upayavira

On Thu, 02 Sep 2004 14:53:38 +0200, "Johannes Textor" <jc...@gmx.de>
said:
> Hi all,
> 
> I have a webapp which uses Hibernate for persistency. Hibernate connects
> to the database (MySQL) using its own connection pool (where the settings
> are specified in hibernate.properties)
> 
> I read that Hibernate's builtin connection pool is no good for 
> production use,
> and indeed I'm facing problems. When the app has not been accessed for
> some
> time, the first time it is accessed again it throws a "End Of File 
> exception".
> 
> Now the question is, can I somehow make Hibernate use Cocoon's builitin
> connection pool ? (I cannot use tomcat connection pooling as I cannot
> access
> the server config files). Has anybody done this and would be willing to 
> share
> some ideas or code ?
> 
> Regards,
> Johannes
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org