-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: how to use sequence generator with no cache ?
PostPosted: Thu Nov 23, 2006 10:18 am 
Beginner
Beginner

Joined: Fri Oct 06, 2006 7:11 am
Posts: 32
Hi,

I'm using the <generator class="sequence"> attribute and it creates a sequence on my Oracle database.

The sequence is setup as having a cache of 20, which basically increments the sequence by 20+ the increment value. Is there a way I can set the sequence to have NOCACHE when it is created in Oracle or does hibernate not have any control over this ?

thanks
Paul


Top
 Profile  
 
 Post subject:
PostPosted: Thu Nov 23, 2006 8:30 pm 
Senior
Senior

Joined: Sat Nov 27, 2004 4:13 am
Posts: 137
mmm, well your post is interesting, because in our project the default value of sequence fetching is just one,... I believe you changed the default behavior with some settings

_________________
don't forget to credit!

Amir Pashazadeh
Payeshgaran MT
پايشگران مديريت طرح
http://www.payeshgaran.co
http://www.payeshgaran.org
http://www.payeshgaran.net


Top
 Profile  
 
 Post subject:
PostPosted: Fri Nov 24, 2006 6:25 am 
Beginner
Beginner

Joined: Fri Oct 06, 2006 7:11 am
Posts: 32
hi Pasha,

It seems that the cache level is set by the database. I had a chat with one of our DBA's about it and our database instances are setup to have the cache set to 20.

Are there any Hibernate Guru's out there that can tell me if we can set the CACHE level from our hbm.xml files ?

thanks


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

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

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.