Thanks a lot for the wealth of information. I had to take off for the
weekend but I also realized that there is a lot of relevant discussion on
this topic and I will spend the necessary time to come up with a reasonable
solution.
Thanks
Ralph
----- Original Message -----
From: Ralph Jensen <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 3:09 PM
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
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
