Skip to main content

When I am using jdbc producer to insert data into Sybase ASE its throwing me an error : JDBC_17 -failed to lookup primary keys for table ‘xxxxxx’ : SQLState: ZZZZZ Error code:2762 Message: The ‘CREATE TABLE’ command is not allowed within a multi-statement transaction in the ‘tempdb’ database. SQLState: 42000 Error code:208 Message:#keys not found.’

 

Please have a look and advice.

@Ansul141185 , just checking, on the JDBC Producer destination, have you ticket the box “Use Multi-Row Operation” on the JDBC tab?
If so, what happens if you switch that off?

Reply


Terms & Conditions