Hello,

I'm using oracle 10g and in my cfg.xml file I haven't set any connection pooling properties.

when I look at the log I see:
INFO [org.hibernate.connection.DriverManagerConnectionProvider] Using Hibernate built-in connection pool (not for production use!)

Few questions:
1. I'm using oracle.jdbc.driver.OracleDriver, do I need to use a connection pooling strategy? Doesn't oracle already have a connection pooling strategy?
2. How can I turn off hibernate's pooling strategy?
3. what config should I use to enable oracle's connection pooling strategy?

Thanks in advance.

could someone please help me with this. I've googled for it, but haven't found anything.

Thanks in advance.

Create a datasource and configure it in the hibernate.cfg.xml

Alternatively you can also use this...





put it in your hibernate.cfg.xml and add the c3p0-0.9.0.jar to your lib. There are other such connection pools available as well.

Thanks for the response, I should have included my cfg in the first place...sorry, please check it out. I'm not defining any connection pool parameter...but hibernate log insists that it is using the default connection pool mechanism. How can I turn it off? How can I use oracles connection pool (if there is such a thing)?

Thanks again for your help!

<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:xe </property>
<property name="hibernate.connection.username">uid</property>
<property name="hibernate.connection.password">pswd</property>
<property name="hibernate.default_schema">schema</property>
<property name="current_session_context_class">thread</property>

</session-factory>
</hibernate-configuration>

you can use third party connection pooling such as DBCP or C3P0. If you don't use other connection pooling, you cann't disable the hibernate connection pooling