I have an application that uses hibernate to get data from a MySQL database. I've enabled hibernate logging, and can see the query that is being generated. When I copy that query into the MySQL Query Browser and plug in the same values as are passed to my code, I get a bunch of records (867); when the code runs, however, it returns 0 records. The same code works with other data values. Any idea how to debug this?
Joined: May 06, 2009
Looks like the problem was that I wasn't querying with the data that the system was actually using because of a logic flaw. Glad I caught it now!