Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of sgfan@gmx.net designates
 213.165.64.20 as permitted sender)
Message-ID: <44702B16.2050705@gmx.net>
Date: Sun, 21 May 2006 10:55:50 +0200
From: Wizard of OS <sgfan@gmx.net>
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
To: Apache Torque Users List <torque-user@db.apache.org>
Subject: Re: Torque/Oracle 10 Incrementation problem
References: <445F65A1.1090407@gmx.net>
 <20060521005231.F19847@minotaur.apache.org>
In-Reply-To: <20060521005231.F19847@minotaur.apache.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Thomas Fischer wrote:
> Hi,
>
> I'm not sure whether this is possible with the current implementation 
> of the Id generation, which uses two steps. In the first step,  Torque 
> gets the id out of the id table (id method idbroker) or sequence (id 
> method native) and in the second step, the insert is done. The only 
> possibility I'd see is to use a rollback to restore the state of the 
> database before the error. I guess this is not possible ussing the id 
> broker, for as far as I know, it uses a separate db connection and 
> thus runs in another transaction as the insert. I'm not so sure about 
> sequences, but as you said it would jump ids,it seems that sequences 
> live outside transactiond and thus never get restored to their 
> previous value if a rollback is issued.
>
> I'm afraid I do not know an easy way to achieve what you want.
>
>     Thomas
>
Hi Thomas,

first of all, please do *not* send HTML encoded mail to mailinglists nor 
to others at all, they are a plague.

I already realized what you have described.
I made direct SQL commit and oracle incremented the sequence anyway.
A transaction w/ rollback didn't work also. I think that the sequence 
concept in Oracle is diffent to regular autoincrement.

thx

anyway

PS: idbroker fails too

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org