In a recent regression suite run I saw 11 instances of this error (in
client suite part of the test). Running the test standalone, it
worked. The missing table is detected in the setUp method, the table
is created in the decorateSQL method given to the
CleanDatabaseTestSetup constructor. Any ideas hwo this could happen?

Dag

There were 11 errors:
1) 
testImportTableExportTable(org.apache.derbyTesting.functionTests.tests.tools.ImportExportLobTest)java.sql.SQLSyntaxErrorException:
 Table/View 'BOOKS_IMP' does not exist.
        at 
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:84)
        at 
org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:358)
        at 
org.apache.derby.client.am.Statement.executeUpdate(Statement.java:509)
        at 
org.apache.derbyTesting.functionTests.tests.tools.ImportExportLobTest.setUp(ImportExportLobTest.java:114)
        at 
org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:109)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
        at junit.extensions.TestSetup.run(TestSetup.java:25)
        at 
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
        at junit.extensions.TestSetup.run(TestSetup.java:25)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
        at junit.extensions.TestSetup.run(TestSetup.java:25)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
        at junit.extensions.TestSetup.run(TestSetup.java:25)
        at 
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
Caused by: org.apache.derby.client.am.SqlException: Table/View 'BOOKS_IMP' does 
not exist.
        at 
org.apache.derby.client.am.Statement.completeSqlca(Statement.java:1833)
        at 
org.apache.derby.client.am.Statement.completeExecuteImmediate(Statement.java:1421)
        at 
org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(NetStatementReply.java:208)
        at 
org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(NetStatementReply.java:59)
        at 
org.apache.derby.client.net.StatementReply.readExecuteImmediate(StatementReply.java:45)
        at 
org.apache.derby.client.net.NetStatement.readExecuteImmediate_(NetStatement.java:128)
        at 
org.apache.derby.client.am.Statement.readExecuteImmediate(Statement.java:1417)
        at org.apache.derby.client.am.Statement.flowExecute(Statement.java:2120)
        at 
org.apache.derby.client.am.Statement.executeUpdateX(Statement.java:514)
        at 
org.apache.derby.client.am.Statement.executeUpdate(Statement.java:500)
        ... 38 more

Reply via email to