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?
posted 7 years ago
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!