File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Using scroller having unexpected  exception" Watch "Using scroller having unexpected  exception" New topic

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:


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,
I agree. Here's the link:
subject: Using scroller having unexpected exception