Retrieving CLOB data using JSP

If one of the database fields is of CLOB datatype, and this field needs to be retrieved using JSP, then normal functions like getString(??) will not work. First, the length of the CLOB filed should be obtained and then getSubString() function is used to retrieve the CLOB data.

?

1 2 3

CLOB aclob = (CLOB)rset.getObject("column_name"); int clob_length = (int)aclob.length(); String data = aclob.getSubString(1, clob_length);