The portability would be there in terms of data access. How to tell the
database to autoincrement when I create a table is probably always database
specific. Or not?
I'm not good at SQL. So how would your suggestion look in code? What would
the key generator bean look like? Off which table would it work?
Ralph
----- Original Message -----
From: Vinay Menon <[EMAIL PROTECTED]>
To: JBOSS <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 4:29 PM
Subject: Re: [JBoss-user] EJB question
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<br clear=all><hr>Get
your FREE download of MSN Explorer at <a
href="http://explorer.msn.com";>http://explorer.msn.com</a><br></p>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
