Clob support
Posted: Fri Oct 12, 2012 1:22 am
Hi,
currently I experienced problem with reading of CLOB from database.
The only way to fix it was to add the following lines to ReturnXmlOrSqlData.getData
Is there any better way?
currently I experienced problem with reading of CLOB from database.
The only way to fix it was to add the following lines to ReturnXmlOrSqlData.getData
Code: Select all
case 2005:
try {
BufferedReader br = new BufferedReader(rs.getClob(i).getCharacterStream());
StringBuffer buffer = new StringBuffer();
String line;
while (null != (line = br.readLine())) {
buffer.append(line);
}
br.close();
rowData.add(columnLabel, buffer.toString());
} catch (IOException exc) {
throw new SQLException(exc.getMessage());
}
break;