Re: [Springframework-developer] OracleLobHandler on WebSphere 6.0

[Juergen H. <ju...@in...>]

Actually, I mixed up the class names in my original mail: WebSphere returns
an object of class "oracle.jdbc.driver.Connection" as underlying connection
there, not an "oracle.jdbc.Connection" as expected by our OracleLobHandler.

So our OracleLobHandler works on the new "oracle.jdbc.Connection" interface,
while WebSphere seems to return an "oracle.jdbc.driver.Connection" that's
not assignable to the "oracle.jdbc.Connection" interface.

This could indeed be a class loader issue: if the local
"oracle.jdbc.Connection" interface has been loaded by a different class
loader than the Connection handle returned by WebSphere...

In principle, we could also relax the Connection type check in
OracleLobHandler, as the Connection handle is just passed on via reflection
anyway. That check is really just there to be able to throw a nice
exception.

But even if we relaxed that check, I guess we'd still run into a class
loader issue: I'd expect the Oracle CLOB.createTemporary call to result in
an internal ClassCastException within the driver implementation in this
case...

Juergen
 

-----Original Message-----
From: spr...@li...
[mailto:spr...@li...] On Behalf Of
Thomas Risberg
Sent: Sunday, October 02, 2005 10:12 PM
To: spr...@li...
Subject: Re: [Springframework-developer] OracleLobHandler on WebSphere 6.0

I think the oracle.jdbc.driver.OracleConnection extends
oracle.jdbc.OracleConnection so they should both work.  The connection I get
back from 10g is oracle.jdbc.driver.T4CConnection and it is assignable as
well.  Could this be a class loader issue?

Thomas


On Oct 2, 2005, at 3:20 PM, Duncan Mills wrote:

> Juergen,
> There has been some refactoring in the Oracle JDBC drivers (as of the 
> 10g version) so the correct class is now oracle.jdbc.Connection. 
> oracle.jdbc.driver.Connection is deprecated but should still be 
> supported until version 11 of the database.
> I'm not sure if that's the cause of the problem here but it's probably 
> more than coincidental..
> Duncan
>
> Juergen Hoeller wrote:
>
>
>> We have a report about an issue with Spring's OracleLobHandler on 
>> WebSphere
>> 6.0:
>> http://opensource2.atlassian.com/projects/spring/browse/SPR-1317
>>
>> Our WebSphereNativeJdbcExtractor seems to work, actually. It's rather 
>> that WebSphere returns an object of class "oracle.jdbc.Connection" as 
>> underlying connection there, not an "oracle.jdbc.driver.Connection" - 
>> as expected by our OracleLobHandler, according to the Oracle 9i+ JDBC 
>> API.
>>
>> Could this be caused by a different Oracle driver that WebSphere 
>> uses, at least in that specific scenario? Maybe it uses an older 
>> Oracle driver that doesn't support the "oracle.jdbc.driver" package 
>> yet? Has anybody ever encountered this, no matter whether on 
>> WebSphere or not?
>>
>> It would be great if someone with access to a WebSphere 6.0 + Oracle 
>> installation could give this a try and see whether there's a way to 
>> solve the issue...
>>
>> Juergen
>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by:
>> Power Architecture Resource Center: Free content, downloads, 
>> discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl
>> _______________________________________________
>> Springframework-developer mailing list 
>> Spr...@li...
>> https://lists.sourceforge.net/lists/listinfo/springframework-
>> developer
>>
>>
>
> --
>
> Regards
>
> Duncan Mills
> Senior Principal Product Manager
> Oracle Application Development Tools
>
> Dun...@or...
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, 
> discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> Springframework-developer mailing list 
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Springframework-developer mailing list
Spr...@li...
https://lists.sourceforge.net/lists/listinfo/springframework-developer