• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

why use c3p0 ?

 
Ranch Hand
Posts: 1021
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I was told to use c3p0 to avoid certain connection error :



However, I do not know why it has to be used together with hibernate.

Hope someone can explain what is c3p0 is about cos googling it does not give me any useful infor.

Tks.
 
Saloon Keeper
Posts: 7582
176
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I don't know who gave you that advice, and why, so I can't speak to that.

The first thing I note is that -when searching for "hibernate sql dialect"- I find something mentioned called "org.hibernate.dialect.MySQLDialect". So the first approach might be to replace what you have with that, and see where that leads you.

As to C3PO, it's a database connection pool library like Apache DBCP and others. If what you're coding is a web app -and thus has multiple users- you will want to use such a pool. More info about it can be found at http://www.mchange.com/projects/c3p0/
 
But how did the elephant get like that? What did you do? I think all we can do now is read this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic