Dear All

What are the advantages of Proxol Connection Pooling than c3p0 and DBCP Connection Pooling

-----

We recommand c3p0

Dear Emmanuel,

Thanks for your reply.

But I would like to know the reason why it is recomended?

-----------

Because I use the C3P0 DBCP but i dont know why ?

Please show us some demo to prove your point,thanks!

Search for the number of bugs and complaints on the forum, we don't have to "prove" anything here. Use C3P0.

Christian, I think Michael's question was fair - there are a lot of posts in the forum supporting Proxool, and having a reason to use C3P0 is better than just a recommendation.

Maybe you're just following Gavin's lead, but a lot of Hibernate Team's responses are terse (and a little indignant) as of late.

Scott

The only and best I can find is that I use it and it works fine for me. I haven't done an "official and complete" connection pools test, so choose the one you know best. That's all.
PS : Actually, most of the time I use the Weblogic connection pool...

Thanks man for answering for me.
I use it because it works (production speaking). I haven't time to check every single OS tools in the world, I pick one or two and learn them. BTW I'm not a connection pooling guru, so don't expect me to "prove" anything.

(unfortunatly) i've tried 4 pools:
1- first the dev pool --> it's written in the doc "not to use in production" so i took "one of the others"
2- then i randomly choose dbcp, very easy to configure but a user point me a white paper in which i found that dbcp was full of bugs
3- so i switch to proxool, AFAIK no bug except that it has problem when app server is shutting down and that it's not using the classpath to find configuration file --> this is UGLY
4- so the last was C3P0 and it is the best, no bug, easy to configure for dev and prod...

if one of the hibernate team member told me last year to use C3P0 without telling me why, i would have used it without asking more...:
- they know
- they advise
- if you want to know why, just use google...

That helps, thanks Anthony. I think that go4favi's use of the word "prove" may have been taken more seriously than it was intended. Sometimes "prove" means "support," as in "Please show us some demo to prove your point" = "Please show us some demo to support your point". It doesn't necessarily carry expectations with it - it may simply be a request for additional info to help build the case for co-workers, management, etc. Again, sincere thanks.

Scott

Anthony,

You r absolutely correct. Bcos I am working with these providers and exploring on this.

I am able to work with C3P0 with out any problems.

The DBCP is giving problem while validating the query.

The Proxool is giving problem while mapping the proxool.properties and proxool.xml. It was not able to map it. without this I was able to work with Proxool by directly specifying the properties in hibernate.properties.

This is problem with Proxool.

I hope this will add few points to Scott to clear his doubt.

----