Il m'est impossible de mettre ma base à jour... J'obtiens ce message :
Code : Tout sélectionner
Echec de mise à jour
Impossible d'accéder au résultat de DELETE FROM "OpenConcerto"."Common"."SOCIETE_COMMON" WHERE "SOCIETE_COMMON"."ID" BETWEEN 43 AND 47
in jdbc:h2:file:/home/zarlabien/Doc/DBData/OpenConcerto
org.openconcerto.utils.ExceptionHandler: Echec de mise à jour
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:86)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:90)
at org.openconcerto.erp.config.InstallationPanel$1$1.run(InstallationPanel.java:281)
at java.lang.Thread.run(Thread.java:679)
Caused by: java.lang.IllegalStateException: Impossible d'accéder au résultat de DELETE FROM "OpenConcerto"."Common"."SOCIETE_COMMON" WHERE "SOCIETE_COMMON"."ID" BETWEEN 43 AND 47
in jdbc:h2:file:/home/zarlabien/Dropbox/DBData/OpenConcerto
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:492)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:407)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:387)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:316)
at org.openconcerto.erp.config.InstallationPanel.updateCommon(InstallationPanel.java:2065)
at org.openconcerto.erp.config.InstallationPanel.access$4(InstallationPanel.java:2059)
at org.openconcerto.erp.config.InstallationPanel$1$1.run(InstallationPanel.java:259)
... 1 more
Caused by: java.sql.SQLException: second exec failed: Referential integrity constraint violation: "EXERCICE_COMMON_ID_SOCIETE_COMMON_fkey: ""Common"".EXERCICE_COMMON FOREIGN KEY(ID_SOCIETE_COMMON) REFERENCES ""Common"".SOCIETE_COMMON(ID) (47)"; SQL statement:
DELETE FROM "OpenConcerto"."Common"."SOCIETE_COMMON" WHERE "SOCIETE_COMMON"."ID" BETWEEN 43 AND 47 [23503-168]
at org.openconcerto.sql.model.SQLDataSource.executeTwice(SQLDataSource.java:782)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:458)
... 7 more
Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "EXERCICE_COMMON_ID_SOCIETE_COMMON_fkey: ""Common"".EXERCICE_COMMON FOREIGN KEY(ID_SOCIETE_COMMON) REFERENCES ""Common"".SOCIETE_COMMON(ID) (47)"; SQL statement:
DELETE FROM "OpenConcerto"."Common"."SOCIETE_COMMON" WHERE "SOCIETE_COMMON"."ID" BETWEEN 43 AND 47 [23503-168]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:414)
at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:431)
at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:307)
at org.h2.table.Table.fireConstraints(Table.java:871)
at org.h2.table.Table.fireAfterRow(Table.java:888)
at org.h2.command.dml.Delete.update(Delete.java:99)
at org.h2.command.CommandContainer.update(CommandContainer.java:75)
at org.h2.command.Command.executeUpdate(Command.java:230)
at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:125)
at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:732)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:321)
at org.openconcerto.sql.model.SQLDataSource.execute(SQLDataSource.java:856)
at org.openconcerto.sql.model.SQLDataSource.executeOnce(SQLDataSource.java:792)
at org.openconcerto.sql.model.SQLDataSource.executeTwice(SQLDataSource.java:761)
... 8 more
(Je suis sous Linux Mint 13 / Java 7 / OC monoposte)