Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10GR2 vs. 10GR1 Java Open Cursor Differences

Re: 10GR2 vs. 10GR1 Java Open Cursor Differences

From: Frits Hoogland <frits.hoogland_at_gmail.com>
Date: Fri, 12 Jan 2007 14:23:00 +0100
Message-ID: <fbb8fbcd0701120523t1e8e986ey3a00d3dcf0a23db6@mail.gmail.com>


Could this have something to do with the 10gr2 open cursors bug

On 1/11/07, Borrill, Christopher <Chris.Borrill_at_hp.com > wrote:
>
> Could this have something to with statement caching? See:
>
> http://download-west.oracle.com/docs/cd/B19306_01/java.102/b14355/stmtca
> ch.htm#g1079466
>
> Statement caching can also be configure in the app server, here is the
> relavent doco for 10gAS:
> http://download-west.oracle.com/docs/cd/B14099_19/web.1012/b14012/datasr
> c.htm#sthref478
>
> Chris Borrill
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of MacGregor, Ian A.
> Sent: Thursday, 11 January 2007 12:14 p.m.
> To: oracle-l_at_freelists.org
> Subject: 10GR2 vs. 10GR1 Java Open Cursor Differences
>
> Since Moving to 10,2 some open cursor problems have surfaced. Here's an
> example of the code:
>
> // collect the ProcessInstances in this Stream's ParentStream
> that depe nd (status transition) on ProcessInstances within this Stream:
>
> stmt = connection.prepareStatement("select PI.ProcessInstance
> from Proc essInstance PI, Process P, ProcessStatusCondition PSC where
> PI.Stream = ? and PI .Process = P.Process and P.Process =
> PSC.DependentProcess and PSC.Process in (se lect Process from Process
> where Task = ?) and PI.IsLatest = 1");
>
> stmt.setInt(1, parentStream);
> stmt.setInt(2, task);
> rs = stmt.executeQuery();
> while (rs.next())
> processInstanceSet.add(new
> Integer(rs.getInt("PROCESSINSTANCE")));
> stmt.close();
>
>
> I'm not a Java person. I did noticeThe code has no rs.close()
> statement. The developer admits that he doesn't explicitly close the
> results set. The trouble is that he swears it all worked in 10GR1 and
> the users testing the system back him up.
>
> The code is indirectly recursive; A calls B which calls A and may nest
> several times.
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> ian_at_slac.stanford.edu
>
>
> I
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 12 2007 - 07:23:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US