Oracle data size exceeds the maximum value of this type: 2736

I. Exceptions:

During database operations during development, the field encounters big data and the field is not BLOB. When the CLOB type is used, if the PreparedStatement method is used to setString, the following exception occurs: java. SQL. SQLException: The data size exceeds the maximum value of this type: 2736.

Ii. Cause Analysis:

Before the driver sends SQL statements to the database, PreparedStatement pre-processes the strings and replaces them with escape characters;

Iii. solution:

1. Use the setCharacterStream method:

Stmt. setCharacterStream (1, new InputStreamReader (String content, String content. length ());

2. Use the OCI driver to connect to the Oracle database.