From 5d164d369476a03bde1a6b9927b4a49942e37ef6 Mon Sep 17 00:00:00 2001 From: rsanchez <rsanchez@curisit.net> Date: Wed, 01 Oct 2014 08:36:58 +0000 Subject: [PATCH] #2021 config - Added C3P0 as DB Connection pool --- securis/src/main/resources/META-INF/persistence.xml | 20 ++++++++++++++++---- 1 files changed, 16 insertions(+), 4 deletions(-) diff --git a/securis/src/main/resources/META-INF/persistence.xml b/securis/src/main/resources/META-INF/persistence.xml index 0404023..2dedfc9 100644 --- a/securis/src/main/resources/META-INF/persistence.xml +++ b/securis/src/main/resources/META-INF/persistence.xml @@ -5,17 +5,29 @@ <persistence-unit name="localdb" transaction-type="RESOURCE_LOCAL"> <description>SeCuris LocalDB</description> <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider> - + <!-- <jta-data-source>java:/DefaultDS</jta-data-source> --> + <!-- <class>net.curisit.securis.db.UserSettingsUnits</class> --> - <properties> <property name="javax.persistence.jdbc.driver" value="org.h2.Driver" /> - <property name="javax.persistence.jdbc.url" - value="jdbc:h2:/tmp/.CurisIntegrity/db/curissecuris" /> + <property name="javax.persistence.jdbc.url" value="jdbc:h2:/tmp/.CurisIntegrity/db/curissecuris" /> <property name="javax.persistence.jdbc.user" value="curis" /> <property name="javax.persistence.jdbc.password" value="53curi5" /> <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect" /> + + <property name="connection.provider_class" value="org.hibernate.connection.C3P0ConnectionProvider" /> + <property name="hibernate.c3p0.acquire_increment" value="1" /> + <property name="hibernate.c3p0.idle_test_period" value="60" /> + <property name="hibernate.c3p0.min_size" value="1" /> + <property name="hibernate.c3p0.max_size" value="10" /> + <property name="hibernate.c3p0.max_statements" value="50" /> + <property name="hibernate.c3p0.timeout" value="0" /> + <property name="hibernate.c3p0.acquireRetryAttempts" value="1" /> + <property name="hibernate.c3p0.acquireRetryDelay" value="250" /> + + <property name="hibernate.show_sql" value="false" /> </properties> + </persistence-unit> </persistence> -- Gitblit v1.3.2