CLOB problem in JAVA
From: Lig <lignite_at_iol.ie>
Date: 25 Jul 2005 13:50:26 -0700
Message-ID: <1122324626.524850.4210_at_o13g2000cwo.googlegroups.com>
Hi :
import javax.naming.Context;
import javax.naming.NamingException;
import oracle.jdbc.OracleConnection;
Date: 25 Jul 2005 13:50:26 -0700
Message-ID: <1122324626.524850.4210_at_o13g2000cwo.googlegroups.com>
Hi :
[Quoted] 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 - 22:50:26 CEST