nesday, October 19, 2005 11:49 AM
To: user-java@ibatis.apache.org
Subject: Re: Performance issue with CustomTypeHandler
Rao, Satish wrote:
Hi
Mike,
Thanks
for the prompt response.
If
we run the PL/SQL via SQL Plus, we don't exper
Title: Message
Hi
Mike
We are
using Oracle 9i and I am using ojdbc14.jar. But my classpath also has
classes12.jar. I removed classes12.jar, but that did not make any
difference.
What
Oracle version and driver are you using?
Also I
am using "oracle.jdbc.OracleDriver" as my driver classn
k it is
looping thru thousands of records again?
Thanks,
Satish
-Original Message-
From: Mike Fagan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 18, 2005 4:40 PM
To: user-java@ibatis.apache.org
Subject: Re: Performance issue with CustomTypeHand
Title: Message
Hi
Mike,
Thanks for the
prompt response.
If we run the PL/SQL
via SQL Plus, we don't experience the same delay (there are about a million
records in the database)
As far as the
database is concerned, we don't have much insight into the
configuration. Can you please provi
Satish,
I am also using oracle ref cursors and do not see the delay you are
experiencing.
Has something possibly changed in your database and the delay you see
is really in the pl/sql?
Regards,
Mike Fagan
Rao, Satish wrote:
Message
Is anyone facing a similar issue. Please sugges
Title: Message
Is
anyone facing a similar issue. Please suggest.
-Original Message-From: Rao, Satish
Sent: Tuesday, October 18, 2005 1:44 PMTo:
user-java@ibatis.apache.orgSubject: Performance issue with
CustomTypeHandler
I am using ORACLECURSOR in my sqlmap and using th