oracle9i没用过,给你在8i里的用法参考.clob最多4G,不会字段长度不够
private final static String SAVE_DB =
"INSERT INTO news(newsID,content) VALUES(?,empty_clob())";
private final static String SAVE_DB2 =
"SELECT content FROM news WHERE newsID=? FOR UPDATE";
Connection con = DBConnection.getConnection();
con.setAutoCommit(false);PreparedStatement pstm = con.prepareStatement(SAVE_DB);
....
pstm.executeUpdate();PreparedStatement pstm2 = con.prepareStatement(SAVE_DB2, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
pstm2.setInt(1, newsID);
rs = pstm2.executeQuery();
oracle.sql.CLOB clobContent = null;
if (rs.next())
{
clobContent = (oracle.sql.CLOB)rs.getClob(1);
}
Writer wr = clobContent.getCharacterOutputStream();
wr.write(content);
wr.flush();
wr.close();
con.commit();
private final static String SAVE_DB =
"INSERT INTO news(newsID,content) VALUES(?,empty_clob())";
private final static String SAVE_DB2 =
"SELECT content FROM news WHERE newsID=? FOR UPDATE";
Connection con = DBConnection.getConnection();
con.setAutoCommit(false);PreparedStatement pstm = con.prepareStatement(SAVE_DB);
....
pstm.executeUpdate();PreparedStatement pstm2 = con.prepareStatement(SAVE_DB2, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
pstm2.setInt(1, newsID);
rs = pstm2.executeQuery();
oracle.sql.CLOB clobContent = null;
if (rs.next())
{
clobContent = (oracle.sql.CLOB)rs.getClob(1);
}
Writer wr = clobContent.getCharacterOutputStream();
wr.write(content);
wr.flush();
wr.close();
con.commit();
解决方案 »
- 奇怪的问题,JSP执行
- ext spring mvc 数据绑定问题咨询
- jsp怎么载入另一个网页?
- 帮忙解决下很急是SSH开发WEB的错误高手们帮我解决啊,我搞了半天检查不错拿里错了!
- 看看还有多少人在用jsp
- JSP 特殊符号
- 如何实现在jsp页面上置入日历表,而且在某年某月某日的那个方框里输入内容,比如通过这个来实现每天的日程安排
- 请教java连oracle数据库释放资源的问题
- 我有一个一字段是用来存新闻内容的,用varchar2不够用,我想用blob,可又不会!
- 请问怎么隐藏resin的目录列表?
- 包 javax.servlet.jsp.* 不在tomcat5.* 里??
- 100分请教,一个很实用的问题,快来接分。
只能用PreparedStatement处理clob吗?
Statement可不可以啊
The server encountered an internal error () that prevented it from fulfilling this request 这是什么错误
String 拼出来的sql语句>4k会出错的,插不进去,这样就只能insert <4k的。