Hibernate Community • View topic - prepared stmt caching using c3p0 Vs com.mysql.jdbc.Driver

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

prepared stmt caching using c3p0 Vs com.mysql.jdbc.Driver

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

fmarolia

Post subject: prepared stmt caching using c3p0 Vs com.mysql.jdbc.Driver

Posted: Thu Jul 03, 2008 6:10 am

Newbie

Joined: Thu Jul 03, 2008 2:38 am
Posts: 1

Hi

I basically want my db connections to cache prepared statements, and I am using mysql.

What is the difference in setting '

Code:

c3p0.max_statements

' in hibernate.cfg.xml vis-a-vis setting '

Code:

cachePrepStmts

' and '

Code:

prepStmtCacheSize

' as JDBC URL parameters.

Is there any obvious advantages to using either?
Or are they both required??

Thanks.
I didn't know where else to ask - but I believe it is important to understand this.

Thanks again.

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum