Hey all,

we are seeing this error when trying to clear out our tables at the
end of a test run. Has anyone seen this before and have a fix for it?

We have tried re-ordering our deletions etc but we have had no luck.

We are using h2 version 1.0.78

    [junit] DELETE FROM PUBLIC.TEMP_TABLE_4_0 WHERE XXXID=? [42102-78]
    [junit] org.h2.jdbc.JdbcSQLException: Table TEMP_TABLE_4_0 not
found; SQL statement:
    [junit] DELETE FROM PUBLIC.TEMP_TABLE_4_0 WHERE XXXID=? [42102-78]
    [junit]     at org.h2.message.Message.getSQLException(Message.java:
103)
    [junit]     at org.h2.message.Message.getSQLException(Message.java:
114)
    [junit]     at org.h2.message.Message.getSQLException(Message.java:
77)
    [junit]     at org.h2.schema.Schema.getTableOrView(Schema.java:
348)
    [junit]     at org.h2.command.Parser.readTableOrView(Parser.java:
4127)
    [junit]     at org.h2.command.Parser.readTableOrView(Parser.java:
4121)
    [junit]     at
org.h2.command.Parser.readSimpleTableFilter(Parser.java:678)
    [junit]     at org.h2.command.Parser.parseDelete(Parser.java:696)
    [junit]     at org.h2.command.Parser.parsePrepared(Parser.java:
334)
    [junit]     at org.h2.command.Parser.parse(Parser.java:290)
    [junit]     at org.h2.command.Parser.parse(Parser.java:262)
    [junit]     at org.h2.command.Parser.prepare(Parser.java:204)
    [junit]     at org.h2.engine.Session.prepare(Session.java:270)
    [junit]     at org.h2.engine.Session.prepare(Session.java:257)
    [junit]     at
org.h2.constraint.ConstraintReferential.prepare(ConstraintReferential.java:
537)
    [junit]     at
org.h2.constraint.ConstraintReferential.getDelete(ConstraintReferential.java:
510)
    [junit]     at
org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:
430)
    [junit]     at
org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:
293)
    [junit]     at org.h2.table.Table.fireConstraints(Table.java:748)
    [junit]     at org.h2.table.Table.fireAfterRow(Table.java:763)
    [junit]     at org.h2.command.dml.Delete.update(Delete.java:75)
    [junit]     at
org.h2.command.CommandContainer.update(CommandContainer.java:69)
    [junit]     at org.h2.command.Command.executeUpdate(Command.java:
205)
    [junit]     at
org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:163)
    [junit]     at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:
264)
    [junit]     at
org.dbunit.database.statement.SimpleStatement.executeBatch(SimpleStatement.java

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to