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
