| Re: [eclipselink-users] Leaking Connections when using Scrollable Cursor |
Are you closing the ScrollableCursor? You need to close it. Rohit Banga-2 wrote: > > Hi All > > I am using a Scrollable Cursor to achieve pagination. On the same client > session, I execute multiple ReadAllQuery's in succession. The return > value is a scrollable cursor. I do not release the client session until > all the scrollable cursors are exhausted. > > After running the code again and again (going through the cycle of > acquiring a client session, getting mutliple scrollable cursors, reading > them all, releasing the client session) my code hangs. After retrying > the query several times it fails saying that no connection is available. > > I am using UCP. > > Is this the correct way to use Scrollable Cursor for paging? What could > be causing a leak in connections? > > -- > Thanks and Regards > Rohit Banga > Member Technical Staff > Oracle Server Technologies > > ----- http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland http://www.eclipse.org/eclipselink/ EclipseLink , http://www.oracle.com/technology/products/ias/toplink/ TopLink Wiki: http://wiki.eclipse.org/EclipseLink EclipseLink , http://wiki.oracle.com/page/TopLink TopLink Forums: http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink , http://www.nabble.com/EclipseLink-f26430.html EclipseLink Book: http://en.wikibooks.org/wiki/Java_Persistence Java Persistence Blog: http://java-persistence-performance.blogspot.com/ Java Persistence Performance -- View this message in context: http://old.nabble.com/Leaking-Connections-when-using-Scrollable-Cursor-tp32062612p32108073.html Sent from the EclipseLink - Users mailing list archive at Nabble.com.