[Hsqldb-developers] Unique constraint violation during update??

[Tobias B. <tob...@da...>]

hi,
i get an unique contraint violation error during an update of a row:

java.sql.SQLException: Unique constraint violation:  in statement
[update BUNDLE set BUNDLE_DATA =3D ? where NODE_ID =3D ?]
        at org.hsqldb.jdbc.Util.throwError(Util.java:56)
        at org.hsqldb.jdbc.jdbcPreparedStatement.execute

somehow during the update, the previous index entry is not properly
removed. the index is only on NODE_ID and not on BUNLDE_DATA.

create cached table BUNDLE (NODE_ID binary(16) not null, BUNDLE_DATA
varbinary not null)
create unique index BUNDLE_IDX on BUNDLE (NODE_ID)

have you already seen such behaviour?
regards, toby

--
-----------------------------------------< tob...@da... >---
Tobias Bocanegra, Day Management AG, Barfuesserplatz 6, CH - 4001 Basel
T +41 61 226 98 98, F +41 61 226 98 97
-----------------------------------------------< http://www.day.com >---