I am working on a simple command line app demonstrating the use of Hibernate. I would like to use a 3rd part connection pool in my example, not the c3p0 or Proxool that are list in the documentation. I understand that if I ran in an App Server I could use that pool manager but for my purposes a stand alone is all I need for now.

Looking at the docs is seems that Hibernate only supports c3p0, Proxool or using an App Servers pool manager. Is this correct or is it possible to use any 3rd party pool manager?

Thanks,
Bruce

You can use connections from anywhere if you create a connection provider:
http://www.hibernate.org/hib_docs/v3/ap ... vider.html

You the specify the class name of your implementation in hibernate.connection.provider_class.

This is a very common extension point and should be quite easy to implement.

Cheers,

Chris

Thanks for the idea. I decided to create a jndi datasource and store it in a binding file. The pool manager I am using will work fine with this.

hi cbredesen,

can i use my own connection pooling class that i have created and is working fine with my jdbc based implementations? pl. provide a fragment so that newbie to hibernate like me can understand..


thanks

I would not recommend that anyone write his own connection pool. But if you are able to code that reliably, then certainly you can understand the lifecycle of a Connection and the ConnectionProvider interface will make sense to you.

http://www.hibernate.org/hib_docs/v3/ap ... vider.html

-Chris