On 16 June 2017 at 01:23, Gerry Matte <[email protected]> wrote:
> Hibernate:
> /* insert ca.gerrymatte.finance.model.Tags
> */ insert
> into
> tags
> (created, createdBy, disabled, invisible, tagDescription,
> tagName, toBeDeleted, updated, updatedBy)
> values
> (?, ?, ?, ?, ?, ?, ?, ?, ?)
> 15-Jun-2017 14:47:37 WARN [o.h.e.jdbc.spi.SqlExceptionHelper] SQL Error:
> 23505, SQLState: 23505
> 15-Jun-2017 14:47:37 ERROR [o.h.e.jdbc.spi.SqlExceptionHelper] Unique
> index or primary key violation: "TAGNAMEKEY_INDEX_2 ON PUBLIC.TAGS(TAGNAME)
> VALUES ('Aimee-Van Fuel', 1)"; SQL statement:
> /* insert ca.gerrymatte.finance.model.Tags */ insert into tags (created,
> createdBy, disabled, invisible, tagDescription, tagName, toBeDeleted,
> updated, updatedBy) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-196]
> 15-Jun-2017 14:47:37 ERROR [c.g.f.utility.quicken.QIFLoader] Line:3JPA
> persistence exception creating Tag(JdbcSQLException: Unique index or
> primary key violation: "TAGNAMEKEY_INDEX_2 ON PUBLIC.TAGS(TAGNAME) VALUES
> ('Aimee-Van Fuel', 1)"; SQL statement:
> /* insert ca.gerrymatte.finance.model.Tags */ insert into tags (created,
> createdBy, disabled, invisible, tagDescription, tagName, toBeDeleted,
> updated, updatedBy) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-196])
>
>
This error has nothing to do with auto increment columns. you have a unique
index on tagname and you're inserting a duplicate value.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
