ERROR: HHH000388: Unsuccessful: alter table trabajador_capacitacion add constraint FK_d3fp2pnqnisbys48qky2q7xn5 foreign key (capacitacions_fInicio, capacitacions_acciones) references capacitacion
feb 07, 2020 1:59:14 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
ERROR: Violación de una restricción de Integridad Referencial: "FK_D3FP2PNQNISBYS48QKY2Q7XN5: PUBLIC.TRABAJADOR_CAPACITACION FOREIGN KEY(CAPACITACIONS_FINICIO, CAPACITACIONS_ACCIONES) REFERENCES PUBLIC.CAPACITACION(FINICIO, ACCIONES)"
Referential integrity constraint violation: "FK_D3FP2PNQNISBYS48QKY2Q7XN5: PUBLIC.TRABAJADOR_CAPACITACION FOREIGN KEY(CAPACITACIONS_FINICIO, CAPACITACIONS_ACCIONES) REFERENCES PUBLIC.CAPACITACION(FINICIO, ACCIONES)"; SQL statement:
alter table trabajador_capacitacion add constraint FK_d3fp2pnqnisbys48qky2q7xn5 foreign key (capacitacions_fInicio, capacitacions_acciones) references capacitacion [23506-189]
feb 07, 2020 1:59:14 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000232: Schema update complete
Hibernate: insert into trabajador (grupo_nombregrupo, nombre, id) values (?, ?, ?)
feb 07, 2020 1:59:14 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 23505, SQLState: 23505
feb 07, 2020 1:59:14 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: Violación de indice de Unicidad ó Clave primaria: "PRIMARY_KEY_1 ON PUBLIC.TRABAJADOR(ID) VALUES ('Magyana', 16)"
Unique index or primary key violation: "PRIMARY_KEY_1 ON PUBLIC.TRABAJADOR(ID) VALUES ('Magyana', 16)"; SQL statement:
insert into trabajador (grupo_nombregrupo, nombre, id) values (?, ?, ?) [23505-189]
feb 07, 2020 1:59:14 PM org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl release
INFO: HHH000010: On release of batch it still contained JDBC statements
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:129)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:190)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3587)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:103)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:453)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:345)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1218)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:421)
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:177)
at capacitacion.NewMain.main(NewMain.java:73)
Caused by: org.h2.jdbc.JdbcSQLException: Violación de indice de Unicidad ó Clave primaria: "PRIMARY_KEY_1 ON PUBLIC.TRABAJADOR(ID) VALUES ('Magyana', 16)"
Unique index or primary key violation: "PRIMARY_KEY_1 ON PUBLIC.TRABAJADOR(ID) VALUES ('Magyana', 16)"; SQL statement:
insert into trabajador (grupo_nombregrupo, nombre, id) values (?, ?, ?) [23505-189]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:102)
at org.h2.mvstore.db.MVSecondaryIndex.checkUnique(MVSecondaryIndex.java:231)
at org.h2.mvstore.db.MVSecondaryIndex.add(MVSecondaryIndex.java:190)
at org.h2.mvstore.db.MVTable.addRow(MVTable.java:704)
at org.h2.command.dml.Insert.insertRows(Insert.java:156)
at org.h2.command.dml.Insert.update(Insert.java:114)
at org.h2.command.CommandContainer.update(CommandContainer.java:78)
at org.h2.command.Command.executeUpdate(Command.java:253)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:157)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:143)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:187)
... 13 more
BUILD STOPPED (total time: 32 seconds)