Hibernate Version: 2.1.6.
Database: Sybase 11.9.2

Our application is using hibernate and has been working fine for a while. Only issue I have is not getting the databse error message in case of the update failure, I get the following message instead.

Caused by: org.springframework.orm.hibernate.HibernateSystemException: SQL insert, update or delete failed (row not found); nested exception is net.sf.hibernate.HibernateException: SQL insert, update or delete failed (row not found)

When I run the same update statement manually against the database I get the correct error. In this case "Scale error during implicit conversion of the numeric value"

I am pretty sure there is a way to get the actual database error. Can somebody please tell me what I need to do.

How about catching the exception and then doing something like this:-

Actually I do not see the database exception anywhere as we print the complete exception in our log including all the nested exceptions.