RE: [JBoss-user] MS SQL JBOSS QUESTION - help needed

2001-07-17 Thread Maraya Michael
Sent: Tuesday, July 17, 2001 1:17 PM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] MS SQL JBOSS QUESTION - help needed > > Hi, > how is the return value of select @@IDENTITY if another insert is issued > before you select @@Identity?? > BeanA inserts > Be

Re: [JBoss-user] MS SQL JBOSS QUESTION - help needed

2001-07-17 Thread Burkhard Vogel
- Original Message - From: "Maraya Michael" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 17, 2001 6:50 PM Subject: RE: [JBoss-user] MS SQL JBOSS QUESTION - help needed > > I have ejbCreate() call the create() function in my Data Access

RE: [JBoss-user] MS SQL JBOSS QUESTION - help needed

2001-07-17 Thread Maraya Michael
w new SQLException("Could not retrieve @@IDENTITY " + "property:\n" + sql); } return retval; } --- Michael R. Maraya > ---------- > From: Burkhard Vogel[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL P

Re: [JBoss-user] MS SQL JBOSS QUESTION - help needed

2001-07-17 Thread Burkhard Vogel
Hi, ejbCreate should return the PK, how do you do it with an identity column? Burkhard - Original Message - From: "Maraya Michael" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 17, 2001 5:15 PM Subject: RE: [JBoss-user] MS SQL JBOSS QUESTION - help

RE: [JBoss-user] MS SQL JBOSS QUESTION - help needed

2001-07-17 Thread Micheal J
Of Maraya > Michael > Sent: 17 July 2001 16:16 > To: '[EMAIL PROTECTED]' > Subject: RE: [JBoss-user] MS SQL JBOSS QUESTION - help needed > > > > Don't use identity for entity beans, even bean-managed persistence > ones? Why not?

RE: [JBoss-user] MS SQL JBOSS QUESTION - help needed

2001-07-17 Thread Maraya Michael
2001 4:54 AM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] MS SQL JBOSS QUESTION - help needed > > Hi, > to be more precise DON'T USE IDENTITY FOR ENTITIY BEANS, simply don't, > stop > trying. What you can do (and you are encouraged to do) is use a dummy >

Re: [JBoss-user] MS SQL JBOSS QUESTION - help needed

2001-07-17 Thread Burkhard Vogel
uot;requiresnew") and return the value found as new primarykey. Read the autoinc thread in the archive! Burkhard - Original Message - From: "Maraya Michael" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 7:49 PM Subject: RE: [JBoss-user] M

RE: [JBoss-user] MS SQL JBOSS QUESTION - help needed

2001-07-16 Thread Maraya Michael
I believe CMPs generate their own primary keys and include them in the INSERT statements that are generated. If you want to keep your IDENTITY column, you will have to defer creation of the primary key to the database as IDENTITY column values cannot be specified unless IDENTITY INSERT i