BadSqlGrammarException in TDM Portal or Enterprise Mode Publish

Document ID : KB000095011
Last Modified Date : 08/05/2018
Show Technical Document Details
Issue:
Test Data Manager (TDM)  Portal or Datamaker Enterprise Mode Publish to DB2 data targets fail with an exception such as:
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar
[ INSERT INTO "SCHEMA"."TABLE" ("columnname","columname1") values ("value","1"); ];
Resolution:
TDM Portal requires the JDBC version 4 driver for DB2. Make sure that you have an appropriate version that supports your version/flavor of DB2.

Upgrade the driver to the latest 4.x version for you DB2 version. IBM provide the JDBC drivers here:
http://www-01.ibm.com/support/docview.wss?uid=swg21363866

If you are unsure which version of the driver you should be using for your DB2 version, please contact IBM accordingly noting that TDM requires a JDBC version 4 driver (db2jcc4.jar).