java - need elaborate info on IBM DB2 error tokens while getting DataAccessException via hibernate -
i using ibm db2 , hibernate in java application. whwnever end dataaccessexception in application getting stacktrace follows
dataaccessexception: {}com.ibm.websphere.ce.cm.duplicatekeyexception: [jcc][50053][12311][3.65.102] t2zos exception: [jcc][t2zos]t2zospreparedstatement.readexecuteinternal:nativeexecute:9943: db2 engine sql error, sqlcode = -803, sqlstate = 23505, error tokens = ix6040uc;000001136e errorcode=-803, sqlstate=23505 @ sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method) @ sun.reflect.nativeconstructoraccessorimpl.newinstance(nativeconstructoraccessorimpl.java:80) @ sun.reflect.delegatingconstructoraccessorimpl.newinstance(delegatingconstructoraccessorimpl.java:57) @ java.lang.reflect.constructor.newinstance(constructor.java:540)
i able make sense out of items in stacktrace 000001136e in error tokens.what signify?
the manual contains explanation sqlcode -803:
an inserted or updated value invalid because index in index space indexspace-name constrains columns of table no 2 rows can contain duplicate values in columns. rid of existing row x record-id
the tokens see in error message map variables in error explanation: "ix6040uc" index space name, while "000001136e" hexadecimal representation of rid (record id) of existing record has value trying insert or update.
i don't have system test with, try query fetch existing record:
select * yourtable rid(yourtable) = 70510
70510 decimal representation of hexadecimal rid 0x1136e.
Comments
Post a Comment