java.lang.RuntimeException
If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip
Check if you're not creating unused SQL entities, as it might cause this exception.
You have a different solution? A short tip here would help you and many other users who saw this issue last week.
- java.lang.RuntimeException: Exception while executing statement : Unique index or primary key violation: "CONSTRAINT_9D9B1_INDEX_F ON PUBLIC.ASSET_META(NAME) VALUES (CAST('SUFFIX' AS VARCHAR_IGNORECASE), 48)"; SQL statement: insert into asset_meta (name, priority, value_type, description, label) values (?,?,?,?,?) [23505-188] errorCode: 23505, sqlState: 23505 insert into asset_meta (name, priority, value_type, description, label) values (?,?,?,?,?) jdbcParams:[SUFFIX,-1,1,SUFFIX,Suffix] at org.squeryl.internals.DatabaseAdapter$class._exec(DatabaseAdapter.scala:297)[org.squeryl.squeryl_2.11-0.9.5-7.jar:0.9.5-7] at org.squeryl.internals.DatabaseAdapter$class.exec(DatabaseAdapter.scala:349)[org.squeryl.squeryl_2.11-0.9.5-7.jar:0.9.5-7] at org.squeryl.adapters.H2Adapter.exec(H2Adapter.scala:22)[org.squeryl.squeryl_2.11-0.9.5-7.jar:0.9.5-7] at org.squeryl.internals.DatabaseAdapter$class.executeUpdateForInsert(DatabaseAdapter.scala:383)[org.squeryl.squeryl_2.11-0.9.5-7.jar:0.9.5-7] at org.squeryl.adapters.H2Adapter.executeUpdateForInsert(H2Adapter.scala:22)[org.squeryl.squeryl_2.11-0.9.5-7.jar:0.9.5-7] Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "CONSTRAINT_9D9B1_INDEX_F ON PUBLIC.ASSET_META(NAME) VALUES (CAST('SUFFIX' AS VARCHAR_IGNORECASE), 48)"; SQL statement: insert into asset_meta (name, priority, value_type, description, label) values (?,?,?,?,?) [23505-188] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)[com.h2database.h2-1.4.188.jar:1.4.188] at org.h2.message.DbException.get(DbException.java:179)[com.h2database.h2-1.4.188.jar:1.4.188] at org.h2.message.DbException.get(DbException.java:155)[com.h2database.h2-1.4.188.jar:1.4.188] at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:102)[com.h2database.h2-1.4.188.jar:1.4.188] at org.h2.mvstore.db.MVSecondaryIndex.checkUnique(MVSecondaryIndex.java:231)[com.h2database.h2-1.4.188.jar:1.4.188]
