String to Clob in Java?

Question

I have a string in java, but the data type in the database is Clob. How to get Clob from String?

Answer 1

clob.setString(position, string) writes a String object to a Clob object .

Answer 2

new javax.sql.rowset.serial.SerialClob (source.toCharArray ())

Answer 3

To convert any string (small strings or large JSON converted to strings) to CLOB, we need to initialize the CLOB first:

CLOB clob = (CLOB) con.createClob();
clob.setString(position, "Any String Here");

Where conis the connection