I have a large application using Hibernate and one particular record throws the following MySQL error when hibernate tries to retrieve it:



I turned on SQL debugging and the SQL statement being run is over a thousand lines long and returns over 20,000 results. I assume that one of the results has an invalid character encoding (something besides Unicode or latin1). The trouble is that I don't know which record or even which table. The query joins over 20 different tables. In my production instance, I can readily reproduce this error by running a specific report on a specific product. If I run the same report on any other product, no error occurs, so I think that I can assume that there is bad data for this particular product. The trouble is that I don't have any idea about how to find the bad data.

Does anyone have any suggestions about how I could locate the source of the problem?

I actually fixed this problem on my own. Underneath the stack trace in small letters, there was the message "OutOfMemoryException." When I looked more closely, I had over 9,000 child objects for this product which caused hibernate to run out of memory. I have since resolved the issue.