BadSqlGrammarException in TDM Portal or Enterprise Mode Publish

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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"); ];

OR

ERROR: Publish failed for job 35, Insert into TABLE failed: BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [INSERT INTO "SCHEMA"."TABLE" ("ID","AD","LANG","BIT","AMA","ELEC") VALUES (?,?,?,?,?,?)]; nested exception is com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=BTGXTDM;INSERT;SCHEMA.TABLE, DRIVER=4.21.29

Environment

Release: TDMTDD99000-4.4-Test Data Manager-for Test Data on Demand
Component:

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).