Class Cast Exception using Oracle CLOB

[reesear]

I am having issues with retrieving a CLOB out of an Oracle database using the Oracle driver CLOB object. I have to use the Oracle CLOB object instead of java.sql.Clob because I want to create a Writer out of the clob. It gives me a ClassCastException when I am retrieving the CLOB out of the resultset. I have tried using a regular connection from the JBoss pool and I have used a JBoss WrappedConnection, but with no success. I have also tried using the JBoss WrappedStatement, but the same problem. I have included a sample code of what I am trying. By the way, I am using JBoss 4.0.2.

 Statement stmt = null;
 ResultSet rs = null;
Connection initConn = datasource.getConnection();
Connection conn = ((WrappedConnection)
 initConn).getUnderlyingConnection();

stmt = conn.createStatement();
sqlStr = "SELECT external_data "
 +"FROM external_data "
 +"WHERE external_data_id = "+extDataIdParam
 +" FOR UPDATE";

rs = stmt.executeQuery(sqlStr);

if (rs.next())
{
 oracle.sql.CLOB destClob = ((OracleResultSet)rs).getCLOB (1);
 writer = destClob.getCharacterOutputStream();
 ...
}

Any help is appreciated,
Rich

[reesear]

I found that my problem is actually when I am Casting the ResultSet to an OracleResultSet.

[reesear]

I am still unable to get this code to work. Now I am having problems with converting the connection returned by Jboss to an OracleConnection. HELP.

[haribabu_nunna]

Hai,
I am enclosing a piece of code, u can use it, whether it works for you......

oracle.sql.CLOB my_storyclob = null;
Writer storywriter;
my_storyclob = (CLOB)rs.getObject(3);
storywriter =((CLOB)my_storyclob).getCharacterOutputStream();
storywriter.write(story);
storywriter.flush();
storywriter.close();

Thanks & Regards,
Hari Babu Nunna

[reeser]

That didn't work either. I did get it working, but I had to use a java.sql.Clob instead of a Oracle CLOB.