some problem with CLOB

[vitamines]

I have a oracle table with a CLOB field named NEWS_CONTETN, and I want put some news information which may be larger than 4k, I have searched for some example and take following steps:

1. insert an empty clob to the table
sql1="insert into TAB1(id,COL_CLOB) values(1,empty_clob())";

2. initialize a CLOB variable and select the clob field for update

sql2="select COL_CLOB from TAB1 where id=1 for update";
oracle.sql.CLOB clob=null;
if(rs.next()){
clob=(oracle.sql.CLOB)rs.getClob("COL_CLOB");
}


3. put the news information to the CLOB variable
===================
HERE IS MY PROBLEM
in step 3, i have tried 3 ways, but it didn't work :(
===================
(1) clob.putChars(1,newsStr.toString().toCharArray()); //newsStr is a string
(2) java.io.OutputStream out = clob.setAsciiStream(0);
(3) Writer outStream = clob.getCharacterOutputStream();

4. update the table
sql3="update TAB1 set COL_CLOB=? where id='1'";



---------------------------------
I can't use any method of oracle.sql.CLOB, and get an exception null
what should i do? pls anyone help me, thanks in advance!

[ee4456]

spring jdbc

[ee4456]

http://www.javaeye.com/topic/38573

[vitamines]

oracle.sql.CLOB clob = (oracle.sql.CLOB)rs.getClob("content");

我是只能进行到赋值的操作，之后对clob变量进行任何方法的调用都会抛出exception

[jinsu_st]

Where are you from? I can't follow you!