表结构:
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);
}
}