要先插入一条,然后再修改... String str="SELECT name FROM usertab WHERE id=1 FOR UPDATE"; ... executeQuery(sql.toString()); if (rs.next()) { CLOB c = (CLOB) rs.getClob(1); BufferedWriter out = new BufferedWriter(c.getCharacterOutputStream()); out.write("ffffffff 数据"); out.close(); } ...
...
executeQuery(sql.toString());
if (rs.next())
{
CLOB c = (CLOB) rs.getClob(1);
BufferedWriter out = new BufferedWriter(c.getCharacterOutputStream());
out.write("ffffffff 数据");
out.close();
}
...
2.第二次修改为,先清空name
1 先insert, 把对应的clob字段用 EMPTY_CLOB 初始化
2 然后打开事务
3 select clobField for update
4 其余的请参考楼上
5 提交事务