File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Strange Hibernate exception with CGLIB

 
Andy Hahn
Ranch Hand
Posts: 225
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
We are suddenly receiving the following exception in our production app when executing a named query which simply loads a collection of Org objects:


We have the vrsnNbr column defined as not null in the database.

Here is the mapping file:


After googling for many hours I cannot seem to make sense of this exception. Any ideas would be welcomed!

Thanks-
 
Andy Hahn
Ranch Hand
Posts: 225
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I found out the cause to this issue. It is not the same issue most people are experiencing, according to google. Maybe it will help somebody.

Our named query was returning NULL for a not-null column in a result set. We had to look at the sql hibernate was generating to determine this.

When we ran the sql manually in Sql Developer and sure enough we saw the NULL. This is an Oracle bug and our DBAs have opened a trouble ticket with Oracle.

Thanks-
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic