-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Query.list() returns no results, but generated SQL does.
PostPosted: Tue Dec 12, 2006 5:21 pm 
Newbie

Joined: Fri Oct 14, 2005 4:42 pm
Posts: 15
I found the answer to my question (below). The problem was an un-committed manual update to the db. Hibernate default isolation level means that such data can't be queried. A simple commit fixed the problem.

"I have Query object generated from hql. I set some parameters, call the list method, and get an empty list. If I execute the generated SQL in sql*plus, I get 3 records. Why would this happen? There are no filters or sql restrictions in my mapping files, and I have other hql queries on the same objects that do return results."


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.