Why do you think the rowid won't be immediately available?
-----Original Message-----
From: K.V. Vinay Menon
To: [EMAIL PROTECTED]
Sent: 6/9/01 11:47 AM
Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
Georg, Dan
Alright. First of all do we really want to modify the insert sql to
return
the oracle rowid and hence end up putting oracle specific code. Believe
the
only issue we have is that given the fact that updates will be based on
the
row id and immediately after inserts the rowid would still be null we
might
end up with a few problems. Now, that is where I think we need to make
the
documentation work. If a person wishes to use rowid based updates etc
then
it must be clearly stated that the create method be defined in a
container
transaction that has value 'RequiresNew'. That way, the insert would be
committed immediately and even if the person did an update after the
insert
it would basically have the rowid value updated. I am just trying to
avoid
putting in code that is specific to any dbms - just require that a dbms
provide stable rowids. Do you see a problem with this?
My views. Your thoughts?
Vinay
----- Original Message -----
From: "Georg Rehfeld" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 09, 2001 5:40 AM
Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
> Hi Dan and Vinay,
>
> > The reason I was suggesting an oracle specific option name was
because I
> > really think that we need to use the Oracle specific syntax to
return
> > the rowid value on inserts.
>
> Oops, I forgot about that. But Vinay is right, a stable ROWID
> might be present in several other databases already or in future.
>
> The 'insert ... select into' syntax today seems to be Oracle 8
> specific (remember, Oracle 7 does not have it), but could make it
> into some standard? At least one and the other are not too closely
> related, this syntax especially can get back whatever you want
> from the just inserted row, not only the ROWID, but even some
> sequence value, some expression list to be more general.
>
> And other DB's having a stable ROWID ain't lost, as Vinay's code
> now falls back to the PK when a ROWID value isn't available.
>
> So I suggest 'stable-rowid-column' (including good docs) and
> a new tag 'insert-select-list' specifying a comma separated list
> of expressions to select from the inserted row and an appropriate
> number of placeholders for the result after a semicolon.
> (Or better, feel free to define the syntax, you got the idea).
>
> bye, my very best regards
> Georg
> ___ ___
> | + | |__ Georg Rehfeld Woltmanstr. 12 20097 Hamburg
> |_|_\ |___ [EMAIL PROTECTED] +49 (40) 23 53 27 10
>
>
>
> _______________________________________________
> Jboss-development mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-development
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
