[ table info ]
clob_test--------------------
c_index serial
c_content clob
----------------------------------
[ source ]
.중략
.
try { String sql = null; String content = "안녕하세요!!!"; sql = "insert into clob_test (c_content) values(?::html::clob)"; PreparedStatement pstmt = conn.prepareStatement(sql); Reader bais = new StringReader(content); pstmt.setCharacterStream(1,bais,content.length()); pstmt.close(); conn.close(); } catch(Exception e) { out.print(e); } .
.중략
[ error message ]
java.sql.SQLException: Type (html) not found.
이런식으로 나오는데... 해결방법을 아시는분 부탁드립니다.
|