Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Fetch API cursor in Eclipselink lazy loading(Fetch API cursor in Eclipselink lazy loading)
Fetch API cursor in Eclipselink lazy loading [message #1739558] Tue, 02 August 2016 22:06 Go to next message
Tareq Zaman is currently offline Tareq ZamanFriend
Messages: 2
Registered: August 2016
Location: USA
Junior Member
Hi,

We use Eclipselink version 2.5.2.v20140319 to connect to SQL server 2008 from Weblogic 12C EJB container. We have connection pool set up in Weblogic server. Using Eclilpselink sessions.xml for connectivity setup. What we are seeing simple lazy loading SQL queries creating Fetch API cursor on the database side. These fetch API cursors taking huge memory. Does anybody know if lazy loading creates cursors by default or there is a way to turn it off?

I have been looking up on this thing, not able to get concrete evidence. Any pointers would be appreciated.

Thank you for reading this.
Re: Fetch API cursor in Eclipselink lazy loading [message #1739573 is a reply to message #1739558] Wed, 03 August 2016 05:49 Go to previous message
Ed Merks is currently offline Ed MerksFriend
Messages: 29040
Registered: July 2009
Senior Member
It's probably better to use the EclipseLink-specific forum:

https://www.eclipse.org/forums/index.php?t=thread&frm_id=111


On 03.08.2016 00:42, Tareq Zaman wrote:
> Hi,
>
> We use Eclipselink version 2.5.2.v20140319 to connect to SQL server
> 2008 from Weblogic 12C EJB container. We have connection pool set up
> in Weblogic server. Using Eclilpselink sessions.xml for connectivity
> setup. What we are seeing simple lazy loading SQL queries creating
> Fetch API cursor on the database side. These fetch API cursors taking
> huge memory. Does anybody know if lazy loading creates cursors by
> default or there is a way to turn it off?
>
> I have been looking up on this thing, not able to get concrete
> evidence. Any pointers would be appreciated.
>
> Thank you for reading this.
Previous Topic:[Moxy Jersey] NLP at org.eclipse.persistence.jaxb.rs.MOXyJsonProvider.writeTo(MOXyJsonProvider.java:
Next Topic:No [ManagedType] type... SpringData app trying to move from Hibernate
Goto Forum:
  


Current Time: Mon Dec 18 09:19:13 GMT 2017

Powered by FUDForum. Page generated in 0.01956 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software