Re: Performance issue with CustomTypeHandler

2005-10-19 Thread Mike Fagan
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

RE: Performance issue with CustomTypeHandler

2005-10-19 Thread Rao, Satish
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

Re: Performance issue with CustomTypeHandler

2005-10-19 Thread Mike Fagan
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

RE: Performance issue with CustomTypeHandler

2005-10-18 Thread Rao, Satish
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

Re: Performance issue with CustomTypeHandler

2005-10-18 Thread Mike Fagan
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

RE: Performance issue with CustomTypeHandler

2005-10-18 Thread Rao, Satish
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