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
