With JBoss 3.2 there is now a PkSQL entity-command that can be used to issue arbitrary SQL to obtain a new PK value. This could be used to obtain a value from the sequence.
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Eric Tim > Sent: Monday, March 17, 2003 9:39 PM > To: [EMAIL PROTECTED] > Subject: [JBoss-user] CMP - Primary Key Strategies? > > > I'm working on a CMP EntityBean with JBoss3 on > Oracle8. > > My primary key must be a unique number. Oracle has a > nice facility for handling sequences, which doesn't > seam possible with this senerio because i'd need to > write some jdbc code in the ejbCreate method to get > the nextval. > > I'm aware that there are several J2EE > patterns/blueprints to solve this...most have > not-so-clean side effects that i'd like to > avoid...such as extra tables..etc. > > Is there anything that i can do with JBoss to solve > this problem in a simple and clean manner? > > Someone told me that there is a cmp engine that i can > buy that plugs into jboss that makes this easy. Does > anyone know what product this is? Does anyone have > experience with it? > > thanks, > -et > > __________________________________________________ > Do you Yahoo!? > Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your > desktop! http://platinum.yahoo.com > > > ------------------------------------------------------- > This SF.net email is sponsored by:Crypto Challenge is now open! > Get cracking and register here for some mind boggling fun and > the chance of winning an Apple iPod: > http://ads.sourceforge.net/cgi-> bin/redirect.pl?thaw0031en > > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/j> boss-user > ------------------------------------------------------- This SF.net email is sponsored by:Crypto Challenge is now open! Get cracking and register here for some mind boggling fun and the chance of winning an Apple iPod: http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
