# DB2 bulkInsertResource SqlSyntaxErrorException

**URL:** <https://forum.flowable.org/t/db2-bulkinsertresource-sqlsyntaxerrorexception/5344>\
**Category:** Flowable Engine\
**Created:** [January 30, 2020, 3:14pm UTC](https://forum.flowable.org/t/db2-bulkinsertresource-sqlsyntaxerrorexception/5344 "2020-01-30T15:14:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![fireplace009](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/fireplace009/32/1595_2.png) [@fireplace009](https://forum.flowable.org/u/fireplace009)\
**Post date:** [January 30, 2020, 3:14pm UTC](https://forum.flowable.org/t/db2-bulkinsertresource-sqlsyntaxerrorexception/5344/1 "2020-01-30T15:14:37Z")

</div>

When starting up my spring-boot containing a .bpmn20.xml and a .dmn file.  
flowable wants to insert data in the flowable tables using

**pseudo:**  
insert into TABLE columns (X,Y) values (1,2) **,** (3,4), …

Using DB2 database I get this error: (I guess DB2 z/OS does not support this type of bulk insert syntax)

Is there a config or something I can add to force it to do this differently?

org.apache.ibatis.exceptions.PersistenceException:

### Error updating database. Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: ILLEGAL SYMBOL “,”. SOME SYMBOLS THAT MIGHT BE LEGAL ARE: FOR NOT ATOMIC. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.22.29

### The error may exist in org/flowable/db/mapping/entity/Resource.xml

### The error may involve org.flowable.engine.impl.persistence.entity.ResourceEntityImpl.bulkInsertResource-Inline

### The error occurred while setting parameters

### SQL: INSERT INTO ACT\_GE\_BYTEARRAY(ID\_, REV\_, NAME\_, BYTES\_, DEPLOYMENT\_ID\_, GENERATED\_) VALUES (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?)

### Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: ILLEGAL SYMBOL “,”. SOME SYMBOLS THAT MIGHT BE LEGAL ARE: FOR NOT ATOMIC. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.22.29

---

<div class="post-metadata">

**Author:** ![dbmalkovsky](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/dbmalkovsky/32/31_2.png) [@dbmalkovsky](https://forum.flowable.org/u/dbmalkovsky)\
**Post date:** [January 30, 2020, 6:58pm UTC](https://forum.flowable.org/t/db2-bulkinsertresource-sqlsyntaxerrorexception/5344/2 "2020-01-30T18:58:51Z")

</div>

It appears that you are using DB2 on z/OS which per this [post](https://forum.flowable.org/t/db2-zos-database-support/1741/2) indicates it is not really supported as there is not an environment to test it in.

My memory tells me that DB2 is different on different operating systems with z/OS as the main outlier.

This [post](https://stackoverflow.com/questions/11743265/insert-multiple-rows-into-db2-database) indicates that the z/OS version doesn’t support the value-list format that Flowable uses for bulk inserts which is supported on Linux and Windows for example.

---

<div class="post-metadata">

**Author:** ![joram](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joram/32/26_2.png) [@joram](https://forum.flowable.org/u/joram)\
**Post date:** [February 4, 2020, 7:16pm UTC](https://forum.flowable.org/t/db2-bulkinsertresource-sqlsyntaxerrorexception/5344/3 "2020-02-04T19:16:47Z")

</div>

You can disable bulk insert by setting setBulkInsertEnabled(false) on your process engine config.