Hibernate 3.1 and dbcp connection pool configuration?

juliocesargarcia · **Joined:** Sat Dec 31, 2005 6:21 pm **Posts:** 4

I am having problems with c3p0 and a solid database. The builtin pool works, but I wanted to try dbcp. However, I am not able to get it to work. It always defaults to the builtin connection pool. I am probably missing an abvious documentation bit, but I cannot find the information I am looking for. How do I configure dbcp and hibernate 3.1??

Hibernate version:
3.1
Config settings:

Code:

        <property name="hibernate.dbcp.initialSize">0</property>
        <property name="hibernate.dbcp.minIdle">0</property>
        <property name="hibernate.dbcp.maxIdle">2</property>
        <property name="hibernate.dbcp.maxActive">8</property>
        <property name="hibernate.dbcp.whenExhaustedAction">1</property>
        <property name="hibernate.dbcp.maxWait">-1</property>
        <property name="hibernate.dbcp.testOnBorrow">true</property>
        <property name="hibernate.dbcp.testOnReturn">false</property>
        <property name="hibernate.dbcp.validationQuery">SELECT 1+1</property>
        <property name="hibernate.dbcp.ps.maxActive">8</property>
        <property name="hibernate.dbcp.ps.maxIdle">2</property>
        <property name="hibernate.dbcp.ps.maxWait">300</property>
        <property name="hibernate.dbcp.ps.whenExhaustedAction">1</property>

Name and version of the database you are using:
Solid Embedded Engine 04.2

Debug level Hibernate log excerpt:
09:08:10,330 INFO Configuration:1022 - processing extends queue
09:08:10,330 INFO Configuration:1026 - processing collection mappings
09:08:10,330 INFO Configuration:1035 - processing association property references
09:08:10,346 INFO Configuration:1057 - processing foreign key constraints
09:08:10,408 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
09:08:10,408 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
09:08:10,408 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
[/code]

abg1979 · **Joined:** Fri Sep 09, 2005 11:35 am **Posts:** 101

i believe you will have to use a datasource for using dbcp.