Hi

i have been getting weird result when i use criteria.uniqueResult()

when i test the DAO using junit, it works fine by only returning the unique result or NonUniqueResultException. however, when i try to call the same method from my ServiceManager it keeps giving me ConstraintViolationException. i can see that it actually did an "UPDATE" instead of "SELECT" from the SQL statement.

And i have another similar method, which is working fine too. the only difference is that the one that is giving me problem is search using unique key. anything wrong that i'm not aware of?


WARN [http-8080-Processor24] JDBCExceptionReporter.logExceptions(71) | SQL Error: -803, SQLState: 23505
ERROR [http-8080-Processor24] JDBCExceptionReporter.logExceptions(72) | [IBM][CLI Driver][DB2/NT] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "2" constrains table "ADMIN.USERS" from having duplicate rows for those columns. SQLSTATE=23505

ERROR [http-8080-Processor24] AbstractFlushingEventListener.performExecutions(277) | Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not update:

I think you have post your message in the wrong forum, but I have exactly the same error. Have you resolved the error ?
Thx for your help,