In JDBC 4.0 if you need to insert a clob from a file

Reader reader = new FileReader(rootPath + File.separator + workflow.getDefinitionFilePath());
preparedStatement.setCharacterStream(4, reader);
1

[12:12]
The Oracle 11g driver (ojdbc6.jar) supports this

[12:12]
If you are not sure what version you have you can do: java -jar ojdbc6.jar.....
1

[12:12]
Oracle 11.2.0.3.0 JDBC 4.0 compiled with JDK6 on Fri_Nov_04_08:05:20_PDT_2011
#Default Connection Properties Resource
#Wed Jun 08 12:12:19 BST 2016 (edited)

10 new messages since 9:45 AM
Mark as read (esc)Mark as read