Query the clob column of db2 in Java

Use the following code in java to query the clob column of db2 (conn. createStatement (ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet. CONCUR_READ_ONLY ))

Use the following code in java to query the clob column of db2 (conn. createStatement (ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet. CONCUR_READ_ONLY ))

Use the following code in java to query the clob column of db2

(Conn. createStatement (ResultSet. TYPE_SCROLL_INSENSITIVE, resultset.concur_read_only1_cmd.exe cuteQuery (SQL)
The following error is reported:

DB2 SQL error: SQLCODE:-270, SQLSTATE: 42997, SQLERRMC: 63

SQL statements directly run in db2 do not report errors.

In db2, The scrollable cursor is not used for direct execution. The solution is as follows:

Remove the parameters in createStatement and use the following code:

Createstatement(cmd.exe cuteQuery (SQL)

In this way, no error will be reported.