I have a sql statement,
"select * from ITEM_P2P3_QUERY where contains(description, ?) =0"
But I want to replace the ? as '"P*"'.
ect * from ITEM where contains(description, '"P*"') =0
So I can question it in DB2 successfully.
I used ps.setString(1, "P*"); and ps.setString(1, "'\"aa\"'"); to try it. But I got some exception on this.
So my question is how to use DB2 JDBC to convert it that it can be executed successfully.

Can you send us the stacktrace

Regards,
Adam AC

I just used the Java codes to connect DB2.

}else if(type == CMType.QUERY_QCRONLY) {
result.append(" AND (CONTAINS(A.DESCRIPTION,?) = 1 or CONTAINS(A.QCR_NUMBER,?) = 1) ");
}else if(type == CMType.QUERY_ACTIVITYONLY) {
result.append(" AND (CONTAINS(A.DESCRIPTION,?) = 1 or CONTAINS(A.ACTIVITY_NUMBER,?) = 1) ");
}else if(type == CMType.QUERY_REPORTONLY) {
result.append(" AND (CONTAINS(A.DESCRIPTION,?) = 1 or CONTAINS(A.NAME,?) = 1) ");

ps.setString(1, fullTextExpr);
It will throws some exceptions for setString() method.