How to use setClob() in PreparedStatement inJDBC

Question

Here are the info:

1. I have a String
2. I want to insert a record in a table with the String in a column whose datatype is CLOB.
3. I would like to use setClob() method of the preparedstatement.

So my question is how to create a Clob object from this String so that I can use setClob() method.

Thanks in advance, Naveen

Answer 1

If you want to write a String to CLOB column just use PreparedStatement.setString.

If you want to know how to create a CLOB from String this is it

    Clob clob = connection.createClob();
    clob.setString(1, str);