[appfuse-user] test failed

[Ding, Qin]

Matt:

 

I am running appfuse 1.9.4 with JSF and DB2.  I found an article you
posted regarding appfuse with DB2 issue and how to fix them.  I came
cross the same error but not with the "testAddUserRole()".  It is the
"testUpdateUser()" method throwing the following error.

 

[junit] Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI
Driver][DB2/NT] SQL0803N  One or mor
e values in the INSERT statement, UPDATE statement, or foreign key
update caused by a DELETE stateme
nt are not valid because the primary key, unique constraint or unique
index identified by "1" constr
ains table "ADMIN.USER_ROLE" from having duplicate rows for those
columns.  SQLSTATE=23505

 

If I comment out the following line from "testUpdateUser()", the test
goes well. How can I fix this problem?  Thank you.

 

user.setId(null);

        endTransaction();

        try {

            dao.saveUser(user);

            //fail("saveUser didn't throw
DataIntegrityViolationException");

        } catch (DataIntegrityViolationException e) {

            assertNotNull(e);

            log.debug("expected exception: " + e.getMessage());

        }