Hi,
We are using Jboss version 4.0.4 in our project.We are deplyoing the hibernate as an MBean . I want to use the c3p0 connection pooling mechanism . I am unableto figure out to specify the paramateres related to C3P0 in the hibernate-service.xml file .

Please help me in getting the solution of the same

I am attaching the file for the reference

<server>
<mbean code="org.jboss.hibernate.jmx.Hibernate"
name="rtbd.hibernate:service=IdmHibernateService,name=IdmHibernateService">
<attribute name="DatasourceName">java:/securityserver</attribute>
<attribute name="Dialect">org.hibernate.dialect.OracleDialect</attribute>
<attribute name="SessionFactoryName">java:/hibernate/SessionFactory</attribute>
<attribute name="MaxFetchDepth">0</attribute>
<!-- <attribute name="hibernate.c3p0.acquire_increment">3</attribute>
<attribute name="hibernate.c3p0.min_size">50</attribute>
<attribute name="hibernate.c3p0.max_size">200</attribute>-->
<attribute name="CacheProviderClass">
org.hibernate.cache.NoCacheProvider
</attribute>
<depends>jboss.jca:service=DataSourceBinding,name=securityserver</depends>

</mbean>
</server>

Hello

I think I have to configure c3p0 in the jboss-service.xml too. Have you find the response to this ?

Thanks!