RE: When using autonumber for the primarykey...

2001-02-05 Thread Michael S. Kelly
=============== -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Juan Lorandi (Chile) Sent: Tuesday, January 30, 2001 10:17 AM To: Orion-Interest Subject: RE: When using autonumber for the primarykey... but o

RE: When using autonumber for the primarykey...

2001-02-01 Thread Gerald Gutierrez
You can always just use direct JDBC calls, or database-specific auto incrementing fields or other sequence number constructs. At 06:01 PM 1/31/2001 +, you wrote: I'm using the counter.jar which is fine, but does it have any impact on performance ? Ok, the EJB spec doesn't support id

RE: When using autonumber for the primarykey...

2001-02-01 Thread Jeff Schnitzer
: Wednesday, January 31, 2001 10:01 AM To: Orion-Interest Subject: RE: When using autonumber for the primarykey... I'm using the counter.jar which is fine, but does it have any impact on performance ? Ok, the EJB spec doesn't support id fields, but surely now for every create() I'm actually doing twice

RE: When using autonumber for the primarykey...

2001-01-31 Thread Krista Richmond
- From: Krista Richmond [mailto:[EMAIL PROTECTED]] Sent: Martes, 30 de Enero de 2001 12:03 To: Orion-Interest Subject: RE: When using autonumber for the primarykey... If it's actually an autonumber field (at least with SQL Server), just insert the rest of the fields (not including the autonumbered

RE: When using autonumber for the primarykey...

2001-01-31 Thread Angus Mark
I'm using the counter.jar which is fine, but does it have any impact on performance ? Ok, the EJB spec doesn't support id fields, but surely now for every create() I'm actually doing twice the work - ie: creating and loading the counter entity bean and the entity bean using the counter? That

RE: When using autonumber for the primarykey...

2001-01-30 Thread Randahl Fink Isaksen
There is an article about this at http://www.orionsupport.com/articles/ejbuniquecounter.html R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of ystein Walle Sent: 30. januar 2001 11:37 To: Orion-Interest Subject: When using autonumber for the

RE: When using autonumber for the primarykey...

2001-01-30 Thread Krista Richmond
If it's actually an autonumber field (at least with SQL Server), just insert the rest of the fields (not including the autonumbered field), e.g. (presuming your table includes First_Name,Last_Name, and an autonumber...say, a Customer_ID field): "INSERT INTO tblMyData(First_Name,Last_Name)

RE: When using autonumber for the primarykey...

2001-01-30 Thread Luong, Tony S322
if you use HSQL , and define the column as incremental type ( I forgot the attribute type), then it is automatic -Original Message- From: ystein Walle [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 5:37 AM To: Orion-Interest Subject: When using autonumber for the