There is a solution here: /questions/56346146/preparedstatement-does-not-work-for-sybase-iq-in-java

Setting LITERAL_PARAMS to true to fix the issue. However performance is really poor.

This seems like a bug with the JDBC driver, is there a fix for this?

Here’s a sample code:

PreparedStatement ps = conn.PreparedStatement(“insert into TBL(A,B) values (?,?)”);

ps.setString(1, “aa”);
ps.setString(2, “bb”);
ps.addBatch();
ps.executeBatch();