String strSQL = "select CLOBCOLUMN from TABLE where id=1"
Statement stmt = Cnx.createStatement();
rs = stmt.executeQuery(strSQL);
while(rs.next()){
Clob clob = rs.getClob(1);
if (clob != null) {
if ((int) clob.length() > 0) {
query = clob.getSubString(1, (int) clob.length());
}
}
}
System.out.println(query);
No hay comentarios:
Publicar un comentario