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
-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:
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:
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
?
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
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
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
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
]
-
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
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
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
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
12 matches
Mail list logo