Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: CLOB problem in JAVA

Re: CLOB problem in JAVA

From: <joeNOSPAM_at_BEA.com>
Date: 25 Jul 2005 15:47:53 -0700
Message-ID: <1122331673.873605.25650@g47g2000cwa.googlegroups.com>


Hi, yes. This is because Oracle did the amateurish thing of making a lot of it's nonstandard extensions to JDBC without making Interfaces for the extra calls, and also exposing methods with deceptive signatures. In this case the createTemporary() method *says* it takes a java.sql.Connection, which the WebSphere wrapper *is*, but the method *really* needs a direct naked oracle driver connection because somewhere deeper in the internals, it's casting the connection to a concrete oracle class to be able to call one of those nonstandard connection methods.

    Besides yelling at Oracle, your only real recourse is to stick to only standard JDBC calls, or use only direct Oracle connections for these calls, outside the scope, purview, and wrapping of WebSphere. WebSphere might have a call you could make in this context to get a handle to the underlying real oracle connection, in which cas you could pass that to the Clob call. I know BEA's WebLogic does...
Joe Weinstein at BEA Systems Received on Mon Jul 25 2005 - 17:47:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US