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]

GitHub | grahamc | 3 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Is there Array Support

    Google Groups | 3 years ago | des.m...@gmail.com
    java.lang.AbstractMethodError: com.mchange.v2.c3p0.impl.NewProxyConnection.createArrayOf(Ljava/lang/String;[Ljava/lang/Object;)Ljava/sql/Array;
  2. 0

    does not work with Scala 2.12.0-M4

    GitHub | 1 year ago | xuwei-k
    java.lang.RuntimeException: error while reflecting on metadata for (Some(private scala.Option org.squeryl.test.schooldb2.Professor.bossId),Some(public scala.Option org.squeryl.test.schooldb2.Professor.bossId()),None,Set()) of class org.squeryl.test.schooldb2.Professor

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. H2 Database Engine
      MVSecondaryIndex.checkUnique
      1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)[com.h2database.h2-1.4.188.jar:1.4.188]
      2. org.h2.message.DbException.get(DbException.java:179)[com.h2database.h2-1.4.188.jar:1.4.188]
      3. org.h2.message.DbException.get(DbException.java:155)[com.h2database.h2-1.4.188.jar:1.4.188]
      4. org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:102)[com.h2database.h2-1.4.188.jar:1.4.188]
      5. org.h2.mvstore.db.MVSecondaryIndex.checkUnique(MVSecondaryIndex.java:231)[com.h2database.h2-1.4.188.jar:1.4.188]
      5 frames