如何使用 JDBC 更新 Oracle Clob
正常方式如下:
pStmt = conn.prepareStatement("SELECT DETAILS FROM PROGRAM_HISTORY WHERE id = 12");
rset = pStmt.executeQuery();
Clob detailsClob= rset.getClob(1);
Writer writer = adapter.getCharacterOutputStream(detailsClob);
writer.write("add more details");
pStmt = conn.prepareStatement("UPDATE PROGRAM_HISTORY SET DETAILS = ? WHERE ID = 12");
pStmt.setClob(1, detailsClob);
pStmt.execute();
这有点复杂，我不需要先阅读然后更新它的任何方式.就像更新 varchar 一样.
This is a little bit complicated, is any way that I don't need read first then update it. just like update varchar.
推荐答案
不知道你为什么称之为正常"方式，但以下对我有用.
Not sure why you call that the "normal" way, but the following works for me.
在更新之前不需要对数据进行任何检索.
It doesn't require any retrieval of the data before updating it.
String value = "So long and thanks for all the fish";
StringReader reader = new StringReader(value);
pStmt = conn.prepareStatement("UPDATE PROGRAM_HISTORY SET DETAILS = ? WHERE ID = 12");
pStmt.setCharacterStream(1, reader, value.length());
pStmt.executeUpdate();
相关文章