Страница 1 из 1

Clob! Как с ним работать?

Добавлено: 27 сен 2004, 18:05
Radik
такой текст!
<%
Connection conn = null;
Statement stmt = null;
ResultSet rset = null;

CLOB clob = null;
byte[] data = new byte[2056];
// mdf_request R = new mdf_request(request);
// byte[] data = request.getParameter("static_tmp/hist.htm");
FileInputStream fi=new FileInputStream("http://ant2/static_tmp/hist.htm");
fi.read(data);

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn = DriverManager.getConnection("jdbc :o racle:thin:@xxx.xx.xx.xx:ЧЧЧЧ:ЧЧЧЧ", "xxxx", "xxxx");
conn.setAutoCommit(false);
stmt = conn.createStatement();
rset = stmt.executeQuery ( "select text from kgtu.site_static where string_id = 'hist' for update" ) ;
rset.next();
clob = (( OracleResultSet )rset).getCLOB(1);
java.io.OutputStream clobStream = clob.getBinaryOutputStream();
clobStream.write(data);
clobStream.close();
conn.commit();
%>
В чем проблемма!пишет что
500 Servlet Exception
/static.jsp:52: cannot resolve symbol
symbol : method getBinaryOutputStream ()
location: class oracle.sql.CLOB
java.io.OutputStream clobStream = clob.getBinaryOutputStream();
^
1 error


--------------------------------------------------------------------------------
Resin-3.0.7 (built Wed, 24 Mar 2004 04:28:45 PST)

Добавлено: 27 сен 2004, 18:56
Kolinus
Я бы сказал чт опросто нет такого метода, либо clob стоит в нуле