Re: [JBoss-user] EJB question

[Vinay Menon]

Why don't you just use a primary key generator bean to encapsulate the key genaration? The ejbCreate can then work off that ejb and assign the primary key field to the primary key generated field? so your autoincrement essentially will not be on the same table as the ejb but a different one and the primary key generator will work off that table. [Also makes sure that you have complete protability in terms of the database server!]   Vinay ----- Original Message ----- From: Ralph Jensen Sent: Friday, May 04, 2001 8:52 AM To: [EMAIL PROTECTED] Subject: [JBoss-user] EJB question I asked this question elsewhere, but didn't get an answer. So: An entity bean's ejbCreate(...) method MUST return the primary key. That is not a problem, if I specify the primary key myself and pass it to the create(...) method. But I want to let the database assign the primary key by creating a table with an AUTOINCREMENT default for the primary key column, like in this example using Cloudscape (part of SUN's J2EE v1.3): create table myTable(    id INT DEFAULT AUTOINCREMENT CONSTRAINT pk_id PRIMARY KEY,    someString VARCHAR(6),    etc. ); Then I can use INSERT like this:    INSERT INTO mytable ( someString ) VALUES ( 'Hello' ); The database then assigns a unique value to the id column of that new record. If I do this in the ejbCreate(...) method of my bean my problem is: How do I know that value in order to return it? Is that possible? Thanks Ralph Jensen _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user Get your FREE download of MSN Explorer at http://explorer.msn.com