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

    Configuring C3P0 settings in JBoss AS

    mariaprabudass Edwin Newbie

      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.