1 Reply Latest reply on Feb 1, 2016 6:04 AM by mariaprabudass

    Configuring C3P0 settings in JBoss AS

    mariaprabudass
    mariaprabudass Jan 29, 2016 8:09 AM

      Hello,

      I need to configure the below hibernate c3p0 configurations in jBoss. I get the datasource from standalone.xml configuration through the JNDI name, but the hibernate c3p0 configurations are not accepted in it. Could you please advise me how and where to configure that in jBoss. Is there any specific procedure for this?

      I am using "jboss-as-7.0.2.Final" version.

      Configuration:-

                  <property name="hibernate.c3p0.max_size" value="15"/>

                  <property name="hibernate.c3p0.min_size" value="3"/>

                  <property name="hibernate.c3p0.timeout" value="25200"/>

                  <property name="hibernate.c3p0.acquireRetryDelay" value="10000"/> <!-- In MilliSec -->

                  <property name="hibernate.c3p0.acquireRetryAttempts" value="5"/>

                  <property name="hibernate.c3p0.breakAfterAcquireFailure" value="false"/>           

                  <property name="hibernate.c3p0.acquire_increment" value="3"/>

                  <property name="hibernate.c3p0.idle_test_period" value="10"/> <!-- In Seconds -->

                  <property name="hibernate.c3p0.preferredTestQuery" value="select 1;"/>

       

      Thanks for looking into this.