The rowid will not be immediately available in the postcreate method. have
not been able to simulate a condition where it will not be available when it
will not be available apart from that which is why I do not really want to
change insert statements etc.
Vinay
----- Original Message -----
From: "Jay Walters" <[EMAIL PROTECTED]>
To: "'K.V. Vinay Menon '" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, June 09, 2001 5:16 PM
Subject: RE: [JBoss-dev] Fast Updates Based on Row ID
> 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
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
