Win a copy of 97 Things Every Java Programmer Should Know this week in the Java in General forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

How many statements can be cached by hibernate?..

 
Ranch Hand
Posts: 494
Eclipse IDE Postgres Database Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi friends...

i have any question about cached statements in Hibernate...
i have configured hibernate with the properties like the following code :
(which use c3p0 Pooling provider..)


in that properties i set the property "hibernate.c3p0.max_statements" =200..
AFAIK its mean i can save cache 200 statements (PreparedStatements) with hibernate...

How many statements can be cached by hibernate?..

Thanks in advance..
 
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't think its possible to say what's the maximum number that can be set for this property. I've just seen sample definitions with 100/200 statements set as the max size.
 
Leonardo Carreira
Ranch Hand
Posts: 494
Eclipse IDE Postgres Database Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yeah.. Thanks Mudit for your reply..

I really doubt about that property..
in fact the application will have much queries..
is it possible to set that property example i will set it to 2000 statements?..

iam using mysql v5 as my DDMS..
as I know DBMS will cached the queries often accessed..

if we use Hibernate.. Does MySQL will cached it also?..
Thank's
 
Oh the stink of it! Smell my tiny ad!
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic