Hey, im not sure whats going on here, but i hope you can help me find out.
I am executing a simple HQL, which looks like this:
Code:
10:22:20,843 DEBUG [QueryTranslatorImpl] parse() - HQL: from de.gameservice.library.Kontofuehrung u where u.users.username = :username and u.timestamp>=:start and u.timestamp<=:ende order by u.timestamp desc
The parameters are also set correctly:
Code:
10:22:20,843 DEBUG [QueryLoader] bindNamedParameters() Sat Jul 01 04:00:00 CEST 2006 -> start [2]
10:22:20,859 DEBUG [TimestampType] binding '2006-07-01 04:00:00' to parameter: 2
10:22:20,859 DEBUG [QueryLoader] bindNamedParameters() Tue Aug 01 03:59:59 CEST 2006 -> ende [3]
10:22:20,859 DEBUG [TimestampType] binding '2006-08-01 03:59:59' to parameter: 3
10:22:20,859 DEBUG [QueryLoader] bindNamedParameters() cagara -> username [1]
10:22:20,859 DEBUG [StringType] binding 'cagara' to parameter: 1
and last but not least, the SQL statement is also generated correctly. When executing the generated SQL statement in phpMyAdmin it correctly returns all 4 elements:
But Hibernate returns only 3 elements, only the ones from July, not the one from August. There is one element missing. WHY THE HECK???
Code:
10:22:20,859 DEBUG [Loader] done processing result set (3 rows)
10:22:20,859 DEBUG [AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
10:22:20,859 DEBUG [AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
10:22:20,859 DEBUG [AbstractBatcher] closing statement
Actually....why do i get only 3 elements returned. Is that probably a BUG in Hibernate? It must be because there is no other explanation for this misterious problem!
I hope you can help me....
Login
FAQ
Search
