Hi,
I may be wrong about oracle rowid changing on row update, it's been a
couple of years. However interbase/firebird dbkey definitely does change
on update, and I think someone mentioned the sql server analogue does too.
In this situation, it seems to me that commit option A cannot be used,
since to get a valid rowid, you have to read the db within the same
transaction you are updating in.
Also, even in Oracle, how can this be used with a newly inserted bean?
create --inserts row in db
later in same transaction, change values on this bean, the generated save
has no rowid unless you fetched it in perhaps ejbpostcreate??? If you can
fix this one, perhaps it can also be used to fetch values supplied by
triggers on insert, such as sequence/generators used for abstract id.
Am I wrong here? Could you explain in detail how this will work?
Thanks
david jencks
On 2001.06.06 10:50:53 -0400 K.V. Vinay Menon wrote:
> The ROW ID bit does not touch ANY other portion in the JBoss source
> except
> for
>
> a) Generating SQLs
> b) Setting parameters.
>
> Options A,B and C should work as usual, correct me if I am wrong. As for
> option D, I am suprised that it has become part of our 'standard' commit
> options. I wrote some code and never had a chance to commit it and unless
> someone else has commited stuff for option D let me know and I'll have to
> commit the code!
>
> Vinay
> ----- Original Message -----
> From: "David Jencks" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, June 06, 2001 2:40 PM
> Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
>
>
> > Hi,
> >
> > This looks very interesting. I'm kind of too lazy to read your code to
> > find out the answer for myself...
> >
> > My impression is that Oracle ROWID and similar facilities such as
> > Interbase/firebird dbkey are stable only within a transaction, and in
> fact
> > expected to change with any update. Could you please explain how your
> new
> > feature guarantees updating the correct row with commit options A, B,
> C,
> > and D?
> >
> > Thanks
> > david jencks
> >
> >
> > On 2001.06.06 08:56:02 -0400 K.V. Vinay Menon wrote:
> > > Hi Marc,
> > > When you were here in London we'd discussed adding functionality
> to
> > > use things like ROWID for fast updates and deletes [as opposed to
> using
> > > primary keys]. I have been able to implement this by
> > >
> > > 1. Adding a field in jaws.xml called rowid-column name. This is ROWID
> for
> > > Oracle and can be something else for other databases. If you do not
> want
> > > to use this feature just don't specify the tag and it will use the
> > > default mechansm based on the primary key.
> > >
> > > <snip>
> >
> >
> > _______________________________________________
> > 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
