Skip to main content


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: 33140
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.


Ed Merks
Professional Support: https://www.macromodeling.com/
Previous Topic:How to completely ignore annotations for entity mapped with xml?
Next Topic:Copying Tenant Data
Goto Forum:
  


Current Time: Wed Apr 24 20:52:29 GMT 2024

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

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

Back to the top