SQL Server - Autoincrement Primary Keys

2000-11-14 Thread Chris Miller
Hi all, This is possibly more of a generic EJB question, although maybe not since Orion has to implement the persistence... I was wondering if it is possible to use CMP beans against an existing SQL-Server database that has autoincrement primary keys. It's not possible to insert a value for the

Re: SQL Server - Autoincrement Primary Keys

2000-11-14 Thread Sven van 't Veer
Chris Miller wrote: Hi all, This is possibly more of a generic EJB question, although maybe not since Orion has to implement the persistence... I was wondering if it is possible to use CMP beans against an existing SQL-Server database that has autoincrement primary keys. It's not

Re: SQL Server - Autoincrement Primary Keys

2000-11-14 Thread TDSlusser
cc: Sent by: Subject: SQL Server - Autoincrement Primary Keys owner-orion-inte

Re: SQL Server - Autoincrement Primary Keys

2000-11-14 Thread Shayne Hughes
you call this finder which creates a new one and finds it. Shayne - Original Message - From: "Sven van 't Veer" [EMAIL PROTECTED] To: "Orion-Interest" [EMAIL PROTECTED] Sent: Tuesday, November 14, 2000 10:21 AM Subject: Re: SQL Server - Autoincrement Primar

RE: SQL Server - Autoincrement Primary Keys

2000-11-14 Thread Juan Lorandi (Chile)
- Autoincrement Primary Keys Hi all, This is possibly more of a generic EJB question, although maybe not since Orion has to implement the persistence... I was wondering if it is possible to use CMP beans against an existing SQL-Server database that has autoincrement primary keys. It's not possible

Re: SQL Server - Autoincrement Primary Keys

2000-11-14 Thread Sven van 't Veer
Shayne Hughes wrote: I'd be interested to hear what others think of this method of using MSSQL's autoincrement type as PK. I have tried this and it seems to work in simple tests. Yeah it's not portable and probably breaks several rules. For this table... CREATE TABLE [dbo].[Lab] (