problem with command septator

Q&A
1

i have to query like below
pic

when i have one query and no command seprator it work
but even if i have one query and a coomand seprator the link on browser dont appear
like this : ![pic2][pic2]
why ?
[pic2]: http://www.xum.ir/images/2014/08/13/34.png

2

Hi,
I don’t know why, but when you have a ‘;’ at the end of the last query, Bonita’s connector consider that there is an empty query after the ‘;’
So, you need to have no separator at the and of the last query.

3

thank U yannicklombardi
but it doesnt solve

4

Did you have an error in the log ?

5

stadio log
!ENTRY org.bonitasoft.studio.engine 1 0 2014-08-13 12:54:27.811
!INFO Build complete for process Pool12 (1.0 ).
engine log
2014-08-13 13:17:06 org.bonitasoft.forms.server.accessor.widget.impl.EngineWidgetBuilderImpl
WARNING: Type java.util.Collection is not handled by the automatic form generation.
2014-08-13 13:17:06 org.bonitasoft.forms.server.accessor.widget.impl.EngineWidgetBuilderImpl
WARNING: Type java.util.Collection is not handled by the automatic form generation.
2014-08-13 13:17:06 org.bonitasoft.engine.api.impl.ProcessStarter
INFO: THREAD_ID=102 | HOSTNAME=someone | TENANT_ID=1 | The user has started the process instance <29> of process in version <1.0> and id <6286934770632339755>
2014-08-13 13:17:06 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: username root
2014-08-13 13:17:06 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: password ******
2014-08-13 13:17:06 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: script select * from doctor
2014-08-13 13:17:06 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: separator null
2014-08-13 13:17:06 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: driver com.mysql.jdbc.Driver
2014-08-13 13:17:06 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: url jdbc:mysql://localhost:3306/hospital
2014-08-13 13:17:06 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: outputType null
2014-08-13 13:17:09 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita].[jsp]
FINE: Disabling the response for futher output
2014-08-13 13:17:32 org.bonitasoft.engine.api.impl.transaction.process.DisableProcess
INFO: THREAD_ID=135 | HOSTNAME=someone | TENANT_ID=1 | The user has disabled process in version <1.0> with id <6286934770632339755>
2014-08-13 13:17:33 org.bonitasoft.engine.api.impl.ProcessManagementAPIImplDelegate
INFO: THREAD_ID=135 | HOSTNAME=someone | TENANT_ID=1 | The user has deleted process with id = <6286934770632339755>
2014-08-13 13:17:34 org.bonitasoft.engine.api.impl.ProcessAPIImpl
INFO: THREAD_ID=135 | HOSTNAME=someone | TENANT_ID=1 | The user has installed process in version <1.0> with id <4944704450669067262>
2014-08-13 13:17:34 org.bonitasoft.engine.api.impl.transaction.process.EnableProcess
INFO: THREAD_ID=135 | HOSTNAME=someone | TENANT_ID=1 | The user has enabled process in version <1.0> with id <4944704450669067262>
2014-08-13 13:17:36 org.bonitasoft.forms.server.accessor.widget.impl.EngineWidgetBuilderImpl
WARNING: Type java.util.Collection is not handled by the automatic form generation.
2014-08-13 13:17:36 org.bonitasoft.forms.server.accessor.widget.impl.EngineWidgetBuilderImpl
WARNING: Type java.util.Collection is not handled by the automatic form generation.
2014-08-13 13:17:36 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita].[jsp]
FINE: Disabling the response for futher output
2014-08-13 13:17:39 org.bonitasoft.forms.server.accessor.widget.impl.EngineWidgetBuilderImpl
WARNING: Type java.util.Collection is not handled by the automatic form generation.
2014-08-13 13:17:39 org.bonitasoft.forms.server.accessor.widget.impl.EngineWidgetBuilderImpl
WARNING: Type java.util.Collection is not handled by the automatic form generation.
2014-08-13 13:17:39 org.bonitasoft.engine.api.impl.ProcessStarter
INFO: THREAD_ID=136 | HOSTNAME=someone | TENANT_ID=1 | The user has started the process instance <30> of process in version <1.0> and id <4944704450669067262>
2014-08-13 13:17:39 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: username root
2014-08-13 13:17:39 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: password ******
2014-08-13 13:17:39 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: script select * from doctor
2014-08-13 13:17:39 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: separator ;
2014-08-13 13:17:39 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: driver com.mysql.jdbc.Driver
2014-08-13 13:17:39 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: url jdbc:mysql://localhost:3306/hospital
2014-08-13 13:17:39 org.bonitasoft.connectors.database.jdbc.JdbcConnector
INFO: outputType null
2014-08-13 13:17:39 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork
WARNING: THREAD_ID=152 | HOSTNAME=someone | TENANT_ID=1 | The work [ExecuteConnectorOfActivity: flowNodeInstanceId = 60, connectorDefinitionName = database con] failed. The failure will be handled.
2014-08-13 13:17:39 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork
WARNING: THREAD_ID=152 | HOSTNAME=someone | TENANT_ID=1 | org.bonitasoft.engine.core.connector.exception.SConnectorException : “PROCESS_DEFINITION_ID=4944704450669067262 | PROCESS_NAME=Pool12 | PROCESS_VERSION=1.0 | PROCESS_INSTANCE_ID=30 | ROOT_PROCESS_INSTANCE_ID=30 | FLOW_NODE_DEFINITION_ID=-5625497694464126149 | FLOW_NODE_INSTANCE_ID=60 | FLOW_NODE_NAME=Step1 | CONNECTOR_DEFINITION_IMPLEMENTATION_CLASS_NAME=database con | CONNECTOR_INSTANCE_ID=29 | 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: java.sql.BatchUpdateException: Can not issue SELECT via executeUpdate().”

6
java.sql.BatchUpdateException: Can not issue SELECT via executeUpdate()

This error happen because of the separator.
If you remove the separator, it will work.

I had the same error :
http://community.bonitasoft.com/answers/625-jdbc-mysql-connector-cannot-select#node-15375

7

U mean for each query even insert and update set seprated connectors
so what is the use of command seprator?

8

I think you need to seperate only Select queries.
I try to make multiple insert and update, and this works.
But when I try upate+select or insert+select, I have this error.

Also, if you have only one query, you don’t need a separator.