# Error when connector insert many values into SQLServer database

**URL:** https://community.ofelia.com/t/error-when-connector-insert-many-values-into-sqlserver-database/7502
**Category:** Q&A
**Created:** [23 June 2016 15:16 UTC](https://community.ofelia.com/t/error-when-connector-insert-many-values-into-sqlserver-database/7502 "2016-06-23T15:16:19Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Fabi13](https://avatars.discourse-cdn.com/v4/letter/f/e47c2d/32.png) [@Fabi13](https://community.ofelia.com/u/Fabi13)
#### Post date: [23 June 2016 15:16 UTC](https://community.ofelia.com/t/error-when-connector-insert-many-values-into-sqlserver-database/7502/1 "2016-06-23T15:16:19Z")

</div>

Hello!

I executed this SQL and the insert worked fine, but when I used in a bonita connector the following log error occured:

```
The work [ExecuteConnectorOfActivity: flowNodeInstanceId = 225,
connectorDefinitionName = [conector_insert] failed. The failure will be handled.
2016-06-23 11:59:51 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork 
org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: 
org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: 
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'INSERT INTO table (column_1, column_2) VALUES (30,1700), (80,1700)'."

```

I can’t find the failure in the insert, please can anyone help me?

Insert into a SQL Server 2012 table throw the bonita connector sqljdbc4.jar

Any help will be welcomed!

Thanks in advance!  
Fa

---

<div class="post-metadata">

### Author: ![Fabi13](https://avatars.discourse-cdn.com/v4/letter/f/e47c2d/32.png) [@Fabi13](https://community.ofelia.com/u/Fabi13)
#### Post date: [24 June 2016 10:46 UTC](https://community.ofelia.com/t/error-when-connector-insert-many-values-into-sqlserver-database/7502/2 "2016-06-24T10:46:31Z")

</div>

Hi Sean,

I solved the problem: in separated script tasks. Yes, many “inserts” in a connector works in bonita :o)

I created:

script\_one: string “INSERT” with "INSERT INTO table (column\_1, column\_2) VALUES "  
script\_two: string “VALUES” with the dynamic values to insert, in this case: “(80,1700), (90,1700), (70,1700)”  
script\_tree: string “QUERY” to join “INSERT” and “VALUES”: INSERT INTO table (column\_1, column\_2) VALUES (80,1700), (90,1700), (70,1700)  
script\_four: connector with the string “${QUERY}” in the batch field.

Thanks!  
Fa

---

<div class="post-metadata">

### Author: ![Sean\_McP](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/sean_mcp/32/932_2.png) [@Sean\_McP](https://community.ofelia.com/u/Sean_McP)
#### Post date: [24 June 2016 05:35 UTC](https://community.ofelia.com/t/error-when-connector-insert-many-values-into-sqlserver-database/7502/3 "2016-06-24T05:35:07Z")

</div>

Did you try running individual statements?

`
INSERT INTO table (column_1, column_2) VALUES (30,1700);
INSERT INTO table (column_1, column_2) VALUES (80,1700)
`

does that work?

---

<div class="post-metadata">

### Author: ![Fabi13](https://avatars.discourse-cdn.com/v4/letter/f/e47c2d/32.png) [@Fabi13](https://community.ofelia.com/u/Fabi13)
#### Post date: [24 June 2016 10:46 UTC](https://community.ofelia.com/t/error-when-connector-insert-many-values-into-sqlserver-database/7502/4 "2016-06-24T10:46:54Z")

</div>

.