施用java插入oracle中数据类型为clob的字段

使用java插入oracle中数据类型为clob的字段

表结构：

SQL> desc liuxiaowen.hadoop_job_sql;Name      Type          Nullable Default Comments --------- ------------- -------- ------- -------- DATA_DESC VARCHAR2(20)  Y                         JOBID     VARCHAR2(100) Y                         SQL       CLOB          Y                         

?insert 代码：

?

public static void writeToRac (String jobId,StringBuffer sql) {PreparedStatement st = null;try{st=con.prepareStatement("insert into liuxiaowen.hadoop_job_sql(data_desc,jobid,sql) values(?,?,?)");st.setString(1,today);st.setString(2,jobId);st.setString(3,sql.toString());st.execute();st.close();}catch (SQLException e){e.printStackTrace();System.out.println("########### insert error! jobId:" + jobId + " \nsql: " + sql);}}