# problem with command septator
**URL:** https://community.ofelia.com/t/problem-with-command-septator/4982
**Category:** Q&A
**Created:** [13 August 2014 07:52 UTC](https://community.ofelia.com/t/problem-with-command-septator/4982 "2014-08-13T07:52:05Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@morixxy](https://community.ofelia.com/u/morixxy)
#### Post date: [13 August 2014 07:52 UTC](https://community.ofelia.com/t/problem-with-command-septator/4982/1 "2014-08-13T07:52:05Z")
i have to query like below
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](http://www.xum.ir/images/2014/08/13/34.png)
---
### Author:  [@yannick.lombardi](https://community.ofelia.com/u/yannick.lombardi)
#### Post date: [13 August 2014 07:59 UTC](https://community.ofelia.com/t/problem-with-command-septator/4982/2 "2014-08-13T07:59:08Z")
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.
---
### Author:  [@morixxy](https://community.ofelia.com/u/morixxy)
#### Post date: [13 August 2014 08:27 UTC](https://community.ofelia.com/t/problem-with-command-septator/4982/3 "2014-08-13T08:27:27Z")
thank U yannicklombardi
but it doesnt solve
---
### Author:  [@yannick.lombardi](https://community.ofelia.com/u/yannick.lombardi)
#### Post date: [13 August 2014 08:29 UTC](https://community.ofelia.com/t/problem-with-command-septator/4982/4 "2014-08-13T08:29:31Z")
Did you have an error in the log ?
---
### Author:  [@morixxy](https://community.ofelia.com/u/morixxy)
#### Post date: [13 August 2014 08:51 UTC](https://community.ofelia.com/t/problem-with-command-septator/4982/5 "2014-08-13T08:51:47Z")
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().”
---
### Author:  [@yannick.lombardi](https://community.ofelia.com/u/yannick.lombardi)
#### Post date: [13 August 2014 08:55 UTC](https://community.ofelia.com/t/problem-with-command-septator/4982/6 "2014-08-13T08:55:56Z")
`
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.ofelia.com/answers/625-jdbc-mysql-connector-cannot-select#node-15375](http://community.ofelia.com/answers/625-jdbc-mysql-connector-cannot-select#node-15375)
---
### Author:  [@morixxy](https://community.ofelia.com/u/morixxy)
#### Post date: [13 August 2014 09:13 UTC](https://community.ofelia.com/t/problem-with-command-septator/4982/7 "2014-08-13T09:13:12Z")
U mean for each query even insert and update set seprated connectors
so what is the use of command seprator?
---
### Author:  [@yannick.lombardi](https://community.ofelia.com/u/yannick.lombardi)
#### Post date: [13 August 2014 09:34 UTC](https://community.ofelia.com/t/problem-with-command-septator/4982/8 "2014-08-13T09:34:02Z")
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.