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.
In Postgres we get the value for the PK from a sequence by doing the following.
create sequence manufacturers_sequence;
create table manufacturers(
manufacturer_id integer default nextval('manufacturers_sequence') primary key,
manufacturer_name varchar(100) not null);
Can you do something like that in Oracle when you create the table for the bean? Or are you letting JBoss create the table and it doesn't know how to put the 'default nextval...' snippet into the 'create table' command?
-M@
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/jboss-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
