Using Connection Pool in JPA
19,532
You can use the c3p0 connection pooling for hibernate. Check this url C3P0 configuration
Author by
Jasper
Areas of interest and skill: Java / J2EE / MongoDB / Big Data/ Hadoop / Machine Learning / Cloud / Amazon EC2
Updated on June 11, 2022Comments
-
Jasper almost 2 years
I hava a standalone JPA (Hibernate) - MySQL Application.
My persistence.xml looks like:
<persistence-unit name="JPAProj" transaction-type="RESOURCE_LOCAL"> <!-- Persistence provider --> <provider> org.hibernate.ejb.HibernatePersistence </provider> .... <properties> <property name='hibernate.show_sql' value='true'/> <property name='hibernate.format_sql' value='true'/> <property name='hibernate.dialect' value='org.hibernate.dialect.MySQL5InnoDBDialect'/> <property name='hibernate.hbm2ddl.auto' value='update'/> <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/> <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost/classicmodels"/> <property name="javax.persistence.jdbc.user" value="someuser"/> <property name="javax.persistence.jdbc.password" value=""/> </properties> </persistence-unit>
I want to use a Connection Pool (say Apache DBCP) in this application, what changes do i need to make to persistence.xml?
-
Jasper about 11 yearsConfiguring Apache DBCP Connection Pool here: mkyong.com/hibernate/…