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 = ? where NODE_ID = ?]
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
--
-----------------------------------------< [EMAIL PROTECTED] >---
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 >---
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642
_______________________________________________
hsqldb-developers mailing list
hsqldb-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
