Re: [JBoss-user] Auto-incr (Revisited)

2001-07-13 Thread danch (Dan Christopherson)
L. Yeung wrote: > jboss-user: > > i have decided to create a table "Trans" with a pk > "transno" of type bigint without auto-increment > defined. next i created a table "counter" with one > field "cnt" which stores the last value of "transno" > of table "Trans". I have an autonumber entity bean

RE: [JBoss-user] Auto-incr

2001-07-13 Thread Saint-Martin Cecile
-Message d'origine- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]De la part de L. Yeung > Envoye : vendredi 13 juillet 2001 05:53 > A : [EMAIL PROTECTED] > Objet : [JBoss-user] Auto-incr > > > jboss-user: > > i have decided to create a table "Trans&qu

[JBoss-user] Auto-incr

2001-07-12 Thread L. Yeung
jboss-user: i have decided to create a table "Trans" with a pk "transno" of type bigint without auto-increment defined. next i created a table "counter" with one field "cnt" which stores the last value of "transno" of table "Trans". I have an autonumber entity bean (cmp) to map this bean to table

[JBoss-user] Auto-incr (Revisited)

2001-07-12 Thread L. Yeung
jboss-user: i have decided to create a table "Trans" with a pk "transno" of type bigint without auto-increment defined. next i created a table "counter" with one field "cnt" which stores the last value of "transno" of table "Trans". I have an autonumber entity bean (cmp) to map this bean to table

Re: [JBoss-user] Auto-Incr

2001-07-10 Thread Wei-ju Wu
? Wei-ju - Original Message - From: "danch (Dan Christopherson)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 09, 2001 8:37 PM Subject: Re: [JBoss-user] Auto-Incr > Wei-ju Wu wrote: > > > Could you please explain me the difference b

Re: [JBoss-user] Auto-Incr

2001-07-09 Thread danch (Dan Christopherson)
gt; -L. Yeung > > From: Chris Tragas <[EMAIL PROTECTED]> > To: "'[EMAIL PROTECTED]'" > <[EMAIL PROTECTED]> > Subject: RE: [JBoss-user] Auto-Incr > Date: Mon, 9 Jul 2001 17:05:53 +1000 > Reply-To: [EMAIL PROTECTED] > > the disa

Re: [JBoss-user] Auto-Incr

2001-07-09 Thread danch (Dan Christopherson)
Wei-ju Wu wrote: > Could you please explain me the difference between using an > AutoNumberBean and just doing a > > SELECT MAX() FROM please ? > With an auto-number bean you can define it to be in its own transaction ('RequiresNew') and force a high isolation level (or use 'select ... for

Re: RE: [JBoss-user] Auto-Incr

2001-07-09 Thread L. Yeung
haven't experienced working on oracle dbs. can you shed some light? -L. Yeung From: Chris Tragas <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Subject: RE: [JBoss-user] Auto-Incr Date: Mon, 9 Jul 2001 17:05:53 +1000 Reply-To: [E

RE: [JBoss-user] Auto-Incr

2001-07-08 Thread Chris Tragas
] - www.atomicmedia.com - > -Original Message- > From: Wei-ju Wu [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 09, 2001 4:51 PM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] Auto-Incr > > > Could you please explain me the dif

Re: [JBoss-user] Auto-Incr

2001-07-08 Thread Wei-ju Wu
using the index ? Or could there be conflicts with the CMP ? Wei-ju Wu - Original Message - From: "Devraj Mukherjee" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 09, 2001 8:34 AM Subject: Re: [JBoss-user] Auto-Incr > Hi, > > I solv

Re: [JBoss-user] Auto-Incr

2001-07-08 Thread Devraj Mukherjee
Hi, I solved this problem by creating the table with a normal integer as the primary key and then writing a AutoNumberBean. The AutoNumberBean is another CMP bean which just keeps track of an Integer per table. If you want I can send you the code for it as well. Devraj At 23:15 8/07/01 -0700

[JBoss-user] Auto-Incr

2001-07-08 Thread L. Yeung
i'm using mysql for my database and created an auto-incrementing pk on a table. i wrote an entity bean which creates a row having a pk value of 0 "zero". mysql maps the value of 0 "zero" to the last-pk-value + 1. however, when i retrieve my data through ejb, the pk still contains 0 "zero". im usin