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
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
I'll get this patch in later today.
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. Ad
sday, June 06, 2001 6:17 PM
Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
> I'll get this patch in later today.
>
> K.V. Vinay Menon wrote:
>
> > Hi Marc,
> >
> > When you were here in London we'd discussed adding functionality to
> >
Georg Rehfeld" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 2:57 PM
Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
> Hi Vinay,
>
> as far as I can remember from my Oracle times using the ROWID is
> only allowed inside transactions and
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/f
ED]]
Sent: Wednesday, June 06, 2001 10:49 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
Locks will be in place since the rowid stuff is applicable only for updates
and deletes. selects obviously cannot work with this! Also, to the best of
my knowledge Oracle row ids
gt; 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 t
Use "insert ... returning rowid into ?"
-Original Message-
From: David Jencks [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 12:02 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
Hi,
I may be wrong about oracle rowid changing on
Hi Vinay,
> Locks will be in place since the rowid stuff is applicable only for
updates
> and deletes. selects obviously cannot work with this! Also, to the best
of
> my knowledge Oracle row ids are fixed unless you move them to new db
i.e.
> export or stuff.
Lazyness is one sort of stupidness
t;
>
> -Original Message-
> From: David Jencks [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 06, 2001 12:02 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
>
>
> Hi,
>
> I may be wrong about oracle rowid changin
age-
From: danch (Dan Christopherson) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 12:59 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
Will the 'returning into ?' work in databases other than
oracle? If not, that would be a pro
Hi Dan, Jay, all,
> Will the 'returning into ?' work in databases other than
> oracle? If not, that would be a problem: until JAWS is chainsawed
> (refactored to separate SQL syntax from the Command hierarchy), it'll be
> difficult to manage DB specific stuff at that level. Vinay's original
lt;[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 6:18 PM
Subject: RE: [JBoss-dev] Fast Updates Based on Row ID
> This is oracle specific as far as I know (insert...returning...). The
> create problem needs to be addressed if one cannot retrieve the rowid, the
> logic needs to check
: [EMAIL PROTECTED]
> Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
>
>
> Well,
> We are an Oracle shop and woudl benefit [like loads of other Oracle
> users] from these changes. Remember they are there as an option. If you
> choose not to use them JAWS will wo
eturned as
null.
What do you think?
Vinay
- Original Message -
From: "danch (Dan Christopherson)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 5:58 PM
Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
> Will the 're
Sorry, I stand corrected the rowid will not be updated automatically.
- Original Message -
From: "K.V. Vinay Menon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 6:56 PM
Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
> O
Ok,
I've changed the JDBCCreateEntityCommand as
public JDBCCreateEntityCommand(JDBCCommandFactory factory)
{
super(factory, "Create");
beanExistsCommand = factory.createBeanExistsCommand();
// Insert SQL
String sql = "INSERT INTO " + jawsEntity.getTableName();
So do you build all your other applications to use rowid?
-Original Message-
From: K.V. Vinay Menon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 1:59 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
Well,
We are an Oracle shop and woudl
l work as usual.
>
> Vinay
> - Original Message -
> From: "Jay Walters" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, June 06, 2001 6:18 PM
> Subject: RE: [JBoss-dev] Fast Updates Based on Row ID
>
>
>
>>This is ora
screw ups don't happen.
Regards,
Vinay
- Original Message -
From: "Jay Walters" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 7:48 PM
Subject: RE: [JBoss-dev] Fast Updates Based on Row ID
> So do you build all your o
danch (Dan Christopherson)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 9:08 PM
Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
> Just for the record, I don't mind having Oracle specific optimizations
> in JAWS, it's just that the curre
it was when I was an
> Oracle consultant and
> advised people against doing it. Who knows.
>
> Cheers
>
> -Original Message-
> From: K.V. Vinay Menon [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 06, 2001 10:49 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-
Dear Vinay,
> No. Not really. Its is just that the new Oracle release clearly state
> advantages of using rowids for updates and it is very attractive to have
> that kind of a facility for updates and deletes on huge tables [we do have
> quite a few tables that are in excess of 5-6 million re
K.V. Vinay Menon wrote:
> Dan Ch,
> Well as you might have noticed the code will work as usual if the
> rowid-column field is not specified in jaws.xml. If it is specified, it will
> then be used instead of the primary key. I am not sure of how other
> databases work with rowids which is why
EMAIL PROTECTED]
Sent: 6/7/01 1:32 AM
Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
K.V. Vinay Menon wrote:
> Dan Ch,
> Well as you might have noticed the code will work as usual if the
> rowid-column field is not specified in jaws.xml. If it is specified,
it will
> then b
: Re: [JBoss-dev] Fast Updates Based on Row ID
> K.V. Vinay Menon wrote:
>
> > Dan Ch,
> > Well as you might have noticed the code will work as usual if the
> > rowid-column field is not specified in jaws.xml. If it is specified, it
will
> > then be used in
Hi,
At 15:46 6.6.2001 +0100, you wrote:
>Have not submitted the patch as yet. I'll check it in once people think
>its alright. Do you want me to send you complete source files for the
>changes?
I think unified diffs are the most convenient to use. If you're on W2k (I
seem to remember so)
Hi,
>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 ha
es?
Vinay
- Original Message -
From: "danch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 07, 2001 6:32 AM
Subject: Re: [JBoss-dev] Fast Updates Based on Row ID
> K.V. Vinay Menon wrote:
>
> > Dan Ch,
> > Well as you might have not
Dear Vinay,
> Have started looking at the code again,
> Do we want to specifically say 'oracle-tuned-updates'. What if
actually
> proves useful for some other database - can't we just call it just
> 'rowid-column' and use the presence or absence of the tag to use rowid
based
> updates?
What
I tried to send this out earlier today, but it never showed up (trouble
on my end)
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.
Georg Rehfeld wrote:
> Dear Vinay,
>
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 da
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 w
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
r
: "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 immediate
36 matches
Mail list logo