I am using spring with hibernate and hsqldb. I have code which creates a new user in the DB. There is a unique constraint on the username property, but when it is violated, hsqldb returns an error code of 0, which spring translates to a UncategorizedSQLException. This only happens when it is executed in a batch and when using hibernate, it seems that everything is always executed in a batch. This doesn't happen with MySql, it correctly throws DataIntegrityViolationException. Have others noticed this problem? Is this an hsqldb bug?
DataIntegrityViolationException w/ hsqldb+hibernate Page Title Module
Move Remove Collapse