ssh 操作 oracle的clob

存clob时候的java代码
Session session = getHibernateTemplate().getSessionFactory()
.openSession();
Transaction tran = session.beginTransaction();
TmInfo tmInfo = new TmInfo();
tmInfo.setContent(Hibernate.createClob(" "));//这个一定要是空格
tmInfo.setSubject(administratorForm.getSubject());
tmInfo.setPblishTime(new Date());
session.save(tmInfo);
session.flush();
session.refresh(tmInfo, LockMode.UPGRADE);

// 从页面上拿数据到实体
tmInfo.setContentString(administratorForm.getContent());

SerializableClob sc = (SerializableClob) tmInfo.getContent();
Clob wrapclob = sc.getWrappedClob();
CLOB clob = (CLOB) wrapclob;

Writer out;
try {
Writer characterOutputStream = clob.getCharacterOutputStream();//强制转换，否则会报空指针
out = characterOutputStream;
out.write(tmInfo.getContentString());
out.close();
tran.commit();
session.close();
} catch (SQLException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
System.out.println(e.toString());
}

/***********************
************************
***********************/

取clob时候的java代码
/**********************/
Clob clob = tmInfo.getContent();// 取得Clob的值
if (clob != null) {
String clobString = "";
try {
clobString = clob.getSubString(1, (int) clob.length());// 将Clob类型的值转换成String类型的值
tmInfo.setContentString(clobString);// 通过setter方法,设置String值,然后就可以通过instance.getInfoContentToString()来取值了
} catch (SQLException e) {
e.printStackTrace();
}
}