Oracle-specific data types vs Connection pool

From: Gianni S. (gsalvagno_at_libero.it)
Date: 10/18/03


Date: 18 Oct 2003 09:17:31 -0700

Hi,
using Oracle-specific data types such as
ArrayDescriptor and create it by a connection to an Oracle database
from a
WebSphere datasource throw a ClassCastException. There is no problem
using these Oracle-specific data types when the connection is obtained
via the DriverManager. This is a bug.

Anyone has a work-around or did Oracle fix the bug ?

I think these works:
 1. DriverManager.getConnection() : but I need a coonection from a
pool.
 2. ((com.ibm.ejs.cm.proxy.OracleConnectionProxy)conn).getPhysicalConnection():
but this is not a ibm supported solution and I see a strange behaviour
using it.
 

Thank you.