This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes Using scroller having unexpected  exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Using scroller having unexpected  exception" Watch "Using scroller having unexpected  exception" New topic
Author

Using scroller having unexpected exception

ray frid
Ranch Hand

Joined: Dec 23, 2010
Posts: 79
Hi all,

I am using ScrollableResults within streaming mode

For some reason in the while loop I am having an exception:








I know I should have only one select while opening connection when using Scrolling.

But here is the thing: When I am using the scroller I see an additional select in the log files:



I tried again to get the same data without using scroller. then did iteration on all record and watched the log file. I coudlnt see additional selectes beside the big one:



The system.out from the second code (regularNamedQuery) were:

39/622
39/622
39/622
39/622

Maybe that will give a hint?

All my data entities in the @ManyToOne are Lazy fetched (@ManyToOne(fetch = FetchType.LAZY))

I also have oneToMany relations in my statement. Maybe that's causing the problem?

Thanks for your help,
ray.
 
GeeCON Prague 2014
 
subject: Using scroller having unexpected exception