使用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);
	}
}

 

评论

1 楼 suns3739 2012-07-18  

解救了我   不错不错