CLOB problem in JAVA

From: Lig <lignite_at_iol.ie>
Date: 25 Jul 2005 13:50:26 -0700
Message-ID: <1122324626.524850.4210@o13g2000cwo.googlegroups.com>

Hi :

I am getting a casting exception (java.lang.ClassCastException: com.ibm.ws.rsadapter.jdbc.WSJdbcConnection) when invoking the CLOB.createTemporary metehod. Extract of relevant lines shown below: Any
ideas how I can resolve this?

Versions:

Oracle 9i
WebSphere Ver 5.1

Cheers
Lig

import java.io.Writer;
import java.sql.Clob;
import java.sql.Connection;
import java.sql.CallableStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Blob;
import javax.sql.DataSource;
import javax.naming.InitialContext;

import javax.naming.Context;
import javax.naming.NamingException;

import java.util.List;
import java.util.ArrayList;
import java.sql.Types;

import oracle.jdbc.OracleConnection;

import oracle.jdbc.driver.*;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import oracle.sql.CLOB;

.
.
.

Context jndiContext = new InitialContext(); DataSource ds = (DataSource)jndiContext.lookup("java:comp/env/" +s_dataSource);
Connection conn = ds.getConnection();
tempClob = CLOB.createTemporary(conn, true, CLOB.DURATION_SESSION );

Error Encountered: -

        java.lang.ClassCastException:
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection Received on Mon Jul 25 2005 - 15:50:26 CDT