How to configure Proxool and Hibernate

perja · **Joined:** Tue Nov 18, 2003 11:56 am **Posts:** 16

I understand that there was a change in Hibernate 2.1.4 so that Proxool must be configured by itself (proxool properties in hibernate.properties or hibernate.cfg.xml is no longer supported).

But how do I setup the connection between hibernate.cfg.xml and proxool.properties? It would be great with a Wiki page on this...

Hibernate version: 2.1.6

Thanks
Per Thomas

bertrand · **Posted:** Tue Aug 10, 2004 6:41 am

As you mentionned, since Hibernate 2.1.4, the Proxool configuration has changed... It is now a bit less convenient to use and configure Proxool with Hibernate but still possible. We, at the proxool dev team are aware of this situation and are working hard to provide better integration with Hibernate.

In the meantime, here is how you can get it working:

- in the hibernate.properties:

Code:

# the pool alias used to identify the pool
# note: hibernate will prefix this alias with 'hibernate-' - so your actual pool name becomes 'hibernate-myalias'
#
hibernate.proxool.pool_alias myalias

# Only need one of the following:
#
# -if the pool is configured from outside of hibernate
#hibernate.proxool.existing_pool true

# - if hibernate must configure the pool from an XML configuration file
#hibernate.proxool.xml proxool.xml

# - if hibernate must configure the pool from a properties file
#hibernate.proxool.properties proxool.properties

The XML or properties file containing the proxool configuration can be specified using a standard URL. If an invalid url is used (say the protocol part is missing) then the file will be looked-up as a resource on the classpath. The later is probably the most convenient...

For more information about what should be in the proxool configuration, please refer to http://proxool.sourceforge.net/configure.html

Below is a minimal proxool.properties for an Oracle database:

Code:

# the pool alias (name comes from the hibernate.properties)
# (don't forget Hibernate adds the 'hibernate-' prefix to your pool alias)
#
jdbc-0.proxool.alias=hibernate-myname

jdbc-0.proxool.driver-class    oracle.jdbc.driver.OracleDriver
jdbc-0.proxool.driver-url      jdbc:oracle:thin:@<host>:1521:<sid>
jdbc-0.user                    <login>
jdbc-0.password                <password>

jdbc-0.proxool.house-keeping-sleep-time   30000
jdbc-0.proxool.house-keeping-test-sql     select 1 from dual
jdbc-0.proxool.test-before-use            true
jdbc-0.proxool.test-after-user            false

Hope this helps.
A wiki page on how to configure Proxool with Hibernate will be soon available ;)

perja · **Joined:** Tue Nov 18, 2003 11:56 am **Posts:** 16

Great, thanks!

--
Per Thomas

bertrand · **Posted:** Wed Aug 11, 2004 11:41 am

Hmm... not sure I was 100% correct - depending on the Hibernate/Proxool versions you may have to add or remove the 'hibernate-' prefix from your pool alias in the proxool.properties file.

Sorry for the mistake.

anthony · **Posted:** Wed Aug 11, 2004 1:34 pm

hi brenuart,
what's up?

there is a wiki here http://www.hibernate.org/214.html
can you had your info about proxool there? with proxool and c3p0, users will have all they need about connection pooling

christian · **Posted:** Tue Aug 17, 2004 5:54 am

Added this to the Wiki: http://www.hibernate.org/222.html

bertrand · **Posted:** Tue Aug 17, 2004 6:13 am

christian wrote:

Added this to the Wiki: http://www.hibernate.org/222.html

Thanks Christian - I will update and maintain this page once I have a bit more time (my second child is expected for the end of this month... am a bit in a hurry for the moment ;).

christian · **Posted:** Tue Aug 17, 2004 6:14 am

Congratulations :)

anthony · **Posted:** Tue Aug 17, 2004 6:15 am

Congratulation brenuart!

bertrand · **Posted:** Tue Aug 17, 2004 6:30 am

anthony wrote:

Congratulation brenuart!

Thanks...

BTW: my firstname is Bertrand - is it possible to change the way my name appears on the forum while keeping the same login ?

gavin · **Posted:** Tue Aug 17, 2004 6:57 am

congrats man

tom.litton · **Joined:** Mon Mar 06, 2006 3:17 pm **Posts:** 5

Has this configuration changed either with the release of hibernate 3.1 or the release of proxool 0.9? Is there anyway of configuring proxool using the hibernate properties?

I didn't see anything in the change log, but I'm hoping (perhaps foolishly) it was overlooked.

marw · **Posted:** Thu Jul 06, 2006 8:34 am

Quote:

Hmm... not sure I was 100% correct - depending on the Hibernate/Proxool versions you may have to add or remove the 'hibernate-' prefix from your pool alias in the proxool.properties file.

Sorry for the mistake.

At least, with Hibernate 3.1.3/Proxool 0.8.3, no 'hibernate-' prefix is required.

Here's my hibernate.cfg.xml:

Code:

    <!-- Use the proxool connection pool. -->
    <property name="proxool.pool_alias">hlss-trm</property>
    <property name="proxool.properties">proxool.properties</property>
...

and my proxool.properties:

Code:

jdbc-0.proxool.alias=hlss-trm
...