He means UPDATE WHERE, which we don't support. The better way it to use SELECT FOR UPDATE, which is supported.
If all you care about is a sequence generator, just use the one included with JBoss. The CMP example code that comes with the Quick Start Guide uses it. Alternatively, you can use the new autonumber code that Alex just added to cvs HEAD. -dain Jim Crossley wrote: > Thank you for all your replies, but I'm still a bit confused WRT something > Floyd Marinescu writes in his EJB Design Patterns book. In it, he describes > the concurrency issues involved in a primary key generation pattern that > involves the use of a Sequence CMP bean. > > I think he's saying that I can get away with a READ_COMMITTED isolation level > (Oracle's default, I believe) if the app server can provide "verified > updates". I'm not entirely sure what those are, but here's Floyd's > description: > > "Isolation of READ_COMMITTED with application server CMP verified updates. > In this case, the application server will compare the contents of the > Sequence entity bean to that in the database before transaction commit time. > If it is discovered that a previous transaction has already gotten the next > block, an exception will be thrown. This is an optimistic concurrencty check > implemented at the application server level, allowing you to use a > transaction isolation level of just READ_COMMITTED, since the application > server guarantees consistency." > > Does/can JBoss 3.0.x provide this guarantee? > > Jim ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
