jdbc - Oracle clob to String in JSP -

I am using JSP to reach OSCL 10G. One of the table also includes a field with the clob data type.

When it is received from the GetString API and is assigned to the string type, it returns an error (java.sql.SQLException: conversion failed for conversion)

I have found that this only happens if the statement is prepared with the parameter ResultSet.CONCUR_UPDATABLE (FORWARE NOT ONLY)

Is there any way, such as ResultSet ResultSet Need to use to play around.

Thank you.

You can convert it to a string in the query. For example: TO_CHAR (dbms_metadata.get_ddl ('TABLE', 'EMP', 'SCOTT')) Select the description:

  dual  

to fix this Works for me