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
2014-10-06 07:04:25 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork
WARNING: THREAD_ID=101 | HOSTNAME=Mainframe | TENANT_ID=1 | The work [ExecuteConnectorOfProcess: processInstanceId = 6, connectorDefinitionName = H2 - localhost...] failed. The failure will be handled.
2014-10-06 07:04:25 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork
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:
SELECT * FROM TEST ORDER BY ID [42102-170]"
2014-10-06 07:04:25 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: username userID
2014-10-06 07:04:25 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: password ******
2014-10-06 07:04:25 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: script DROP TABLE IF EXISTS TEST;
2014-10-06 07:04:25 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: separator null
2014-10-06 07:04:25 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: driver org.h2.Driver
2014-10-06 07:04:25 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: url jdbc:h2:tcp://localhost:9091/MercuriyRising2.db;MVCC=TRUE;DB_CLOSE_ON_EXIT=TRUE;IGNORECASE=TRUE;
2014-10-06 07:04:25 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: outputType null
2014-10-06 07:04:28 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita].[jsp]
FINE: Disabling the response for futher output