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

Are you referencing Note:1020427.102? If not please post the Bug number. Oracle states it is not a bug, but an optimization. That's something which has been around for a long time certainly beofre 10gR2.

Testing has shown that closing the statement without explicitly closing the results set does not result in open cursor buildup. However when the entire application is run we still have the problem. Perhaps there are times when one has to close the results set that the test is missing.

Ian

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Frits Hoogland Sent: Friday, January 12, 2007 5:23 AM
To: Chris.Borrill_at_hp.com
Cc: oracle-l_at_freelists.org
Subject: Re: 10GR2 vs. 10GR1 Java Open Cursor Differences

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

On 1/11/07, Borrill, Christopher < Chris.Borrill_at_hp.com <mailto: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 <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 <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> 
	[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 <mailto: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 <mailto: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