Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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.
 
Don't get me started about those stupid light bulbs.
 
subject: Using scroller having unexpected exception
 
Similar Threads
get generated key
Hibernate session per database user
oracle stored procedure with clob return
Hibernate pagination performance problem
Can't use Optimistic Locking