H2 JDBC Connector caching invalid SQL

1
0
-1

Hi,

Bonita Studio 6.3.3

I have a one step process to drop a table in a H2 database, but it keeps failing due to a invalid SQL statement been cached somewhere...I'm using the Bonita Database Connector and the SQL is

DROP TABLE IF EXISTS TEST;

But my log says this...

Where is the SELECT * FROM TEST ORDER BY ID coming from? It is not in my connector which has been deleted and recreated...

Thanks and regards Seán

  1. 2014-10-06 07:04:25 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork
  2. WARNING: THREAD_ID=101 | HOSTNAME=Mainframe | TENANT_ID=1 | The work [ExecuteConnectorOfProcess: processInstanceId = 6, connectorDefinitionName = H2 - localhost...] failed. The failure will be handled.
  3. 2014-10-06 07:04:25 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork
  4. WARNING: THREAD_ID=101 | HOSTNAME=Mainframe | TENANT_ID=1 | org.bonitasoft.engine.core.connector.exception.SConnectorException : "PROCESS_DEFINITION_ID=6880597157049621281 | PROCESS_NAME=H2 Database | PROCESS_VERSION=1.0 | PROCESS_INSTANCE_ID=6 | ROOT_PROCESS_INSTANCE_ID=6 | CONNECTOR_DEFINITION_IMPLEMENTATION_CLASS_NAME=H2 - localhost... | CONNECTOR_ACTIVATION_EVENT=ON_ENTER | CONNECTOR_INSTANCE_ID=10 | org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: org.bonitasoft.engine.connector.ConnectorException: org.h2.jdbc.JdbcBatchUpdateException: Table "TEST" not found; SQL statement:
  5. SELECT * FROM TEST ORDER BY ID [42102-170]"
  6. 2014-10-06 07:04:25 org.bonitasoft.connectors.database.jdbc.JdbcConnector
  7. INFO: username userID
  8. 2014-10-06 07:04:25 org.bonitasoft.connectors.database.jdbc.JdbcConnector
  9. INFO: password ******
  10. 2014-10-06 07:04:25 org.bonitasoft.connectors.database.jdbc.JdbcConnector
  11. INFO: script DROP TABLE IF EXISTS TEST;
  12. 2014-10-06 07:04:25 org.bonitasoft.connectors.database.jdbc.JdbcConnector
  13. INFO: separator null
  14. 2014-10-06 07:04:25 org.bonitasoft.connectors.database.jdbc.JdbcConnector
  15. INFO: driver org.h2.Driver
  16. 2014-10-06 07:04:25 org.bonitasoft.connectors.database.jdbc.JdbcConnector
  17. INFO: url jdbc:h2:tcp://localhost:9091/MercuriyRising2.db;MVCC=TRUE;DB_CLOSE_ON_EXIT=TRUE;IGNORECASE=TRUE;
  18. 2014-10-06 07:04:25 org.bonitasoft.connectors.database.jdbc.JdbcConnector
  19. INFO: outputType null
  20. 2014-10-06 07:04:28 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita].[jsp]
  21. FINE: Disabling the response for futher output
No answers yet.
Notifications