Insert CLOB using JDBC

[Liwuen Chew]

Hi everyone!
I have a question regarding inserting clobs in oracle. I have a table

table: field1 - string ; field2 - number; field 3 - clob.

And I want to insert the values like this:
"insert into table values('abc',123,<don't know what to do here> )".

I am using a JDBC connection. Already tried with prepareStatement and things like that, but I cannot make it to work. Can someone explain how to make this kind of insert from java?

Thank you!

[Liwuen Chew]

Hello everyone! I found the way.
You must use an OraclePreparedStatement . It must be something like this:

String sql = "insert into table values('abc',123,?)";
OraclePreparedStatement st = (OraclePreparedStatement) connection.prepareStatement(sql); //where connection is your connection with Oracle
st.setStringForClob(1, /*String variable which contains the CLOB string*/);
st.executeUpdate();

And that's it!. Hope this helps anyone with the same issue!

[Janeice DelVecchio]

Thanks for solving your own topic!

And a SPECIAL thanks for posting the answer here!!

[Farakh khan]

Liwuen Chew wrote:Hello everyone! I found the way.
You must use an OraclePreparedStatement . It must be something like this:

String sql = "insert into table values('abc',123,?)";
OraclePreparedStatement st = (OraclePreparedStatement) connection.prepareStatement(sql); //where connection is your connection with Oracle
st.setStringForClob(1, /*String variable which contains the CLOB string*/);
st.executeUpdate();

And that's it!. Hope this helps anyone with the same issue!

It gives me the following error:

C:\Program Files (x86)\Java\Tomcat\webapps\ROOT\WEB-INF\classes>javac -d . *.jav
a
CvDAO.java:202: error: cannot find symbol
                        OraclePreparedStatement st = (OraclePreparedStatement) c
nn.prepareStatement(sql);
                        ^
  symbol:   class OraclePreparedStatement
  location: class CvDAO
CvDAO.java:202: error: cannot find symbol
                        OraclePreparedStatement st = (OraclePreparedStatement) c
nn.prepareStatement(sql);
                                                      ^
  symbol:   class OraclePreparedStatement
  location: class CvDAO
Note: CvDAO.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
2 errors

[Farakh khan]

import oracle.jdbc.OraclePreparedStatement;