Re: [Springframework-developer] re: OracleLobCreator

[<bro...@ya...>]

Thanx guys,

I have searched the entire weblogic directories and
the only "oracle" jar is the ojdbc14.jar, we were
using classes12.jar in the app, but i undeployed the
app, deleted all of our uploaded, generated files
replaced classes12.jar with ojdbc14.jar and redeployed
with the same failure of null ClassCastException.... 

I will try firstly using the
SimpleNativeJdbcExtractor, then play around with
changing pool connection drivers to see if i get that
going.

Will report back results

Thank-you all again for your help, i have at least now
a plan of action 

Regards
Bronwen



--- tho...@tr... wrote: > 
> It looks to me that the WebLogic connection wrapper
> works fine.  No need to
> extract the native Oracle driver.
> 
> My connection is
>
"weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_OracleConnection"
> 
> I remember hearing some Bea guys mentioning that
> they added LOB functionality to
> their wrapper.
> 
> I'm using WLS 8.1 SP2 that comes with the Oracle
> ojdbc14.jar (<Driver Version is
> 9.2.0.3.0>).
> 
> This code ran just fine using Spring 1.0.1 jar:
> 
> 	conn = ds.getConnection();
> 	lh = new OracleLobHandler();
> 	ps = conn.prepareStatement("select text from docs
> where doc_id = 1");
> 	rs = ps.executeQuery();
> 	if (rs.next()) {
> 		clobText = lh.getClobAsString(rs, 1);
> 	}
> 	System.out.println("***> READ TEXT <*** length is "
> +
> 		clobText.length());
> 
> 
> There must me something else going on.  I would make
> sure to check that the
> ojdbc14.jar that comes with WLS81 SP2 is the one
> that is on the classpath for
> the server.  Could it be something in the
> transaction management that
> interferes?
> 
> Thomas
> 
> 
> 
> Quoting "jürgen höller [werk3AT]"
> <jue...@we...>:
> 
> > OracleLobHandler needs to work on a native
> OracleConnection as it comes =
> > from the driver. The usual problem in that respect
> is not the driver but =
> > the connection pool: Every connection pool needs
> to wrap native =
> > connections with pooled connections that at least
> have different closing =
> > behavior.
> > =20
> > To address this, OracleLobHandler has the
> "nativeJdbcExtractor" =
> > property, taking an implementation of Spring's
> NativeJdbcExtractor =
> > interface. Spring includes out-of-the-box
> implementations for Commons =
> > DBCP, XAPool, and JBoss. I guess what you need to
> do is write such an =
> > extractor for Weblogic.
> > =20
> > What's odd about your exception is that
> OracleLobCreator does not =
> > complain that it doesn't receive an
> OracleConnection (there's an =
> > explicit check in there). It seems to get a
> wrapped connection that is =
> > still assignable to OracleConnection, although
> it's not the native =
> > OracleConnection from the driver...
> > =20
> > Maybe Weblogic uses some special way of pooling
> connections for the =
> > Oracle driver, using poolable OracleConnections?
> The =
> > getPhysicalConnection method will probably be in
> the OracleConnection =
> > class, not in the CLOB class. Try writing a
> NativeJdbcExtractor that =
> > unwraps an OracleConnection with that method.=20
> > =20
> > Juergen
> > =20
> >
> > ________________________________
> >
> > Von:
>
spr...@li...
> im Auftrag =
> > von Bronwen Cassidy
> > Gesendet: Mo 31.05.2004 04:27
> > An:
> spr...@li...
> > Betreff: RE: [Springframework-developer] re:
> OracleLobCreator
> >
> >
> >
> > Hi I have:
> >
> > Weblogic 8 service pack 2
> > ojdbc.jar (Oracle9i 9.2.0.1 JDBC Drivers)
> > Oracle9i
> > I have set up the connection pool using the
> jdbc:oracle:thin (oracle =
> > thin
> > drivers (not weblogic ones)=20
> >
> > Actually I managed to find some information (very
> little) one from a
> > hibernate mail, suggested using the
> getPhysicalConnection() instead of
> > createTemporary, but this method does not seem to
> available on the CLOB
> > class??
> >
> > -----Original Message-----
> > From:
>
spr...@li...
> >
>
[mailto:spr...@li...]
> On Behalf =
> > Of
> > Thomas Risberg
> > Sent: 31 May 2004 02:09
> > To:
> spr...@li...
> > Subject: Re: [Springframework-developer] re:
> OracleLobCreator
> >
> > Bronwen,
> >
> > In order to pinpoint the problem quicker - what
> version of WebLogic,
> > Oracle and JDBC drivers are you using?
> >
> > Thomas
> >
> > Bronwen Cassidy wrote:
> >
> > > Hi I have a CLOB column in oracle and in the
> test there are no
> > > problems, unfortunately deploying to weblogic I
> get the exception
> > > below. We are using classes12.jar whereas
> weblogic uses ojdbc14.jar, I
> > > firstly replaced weblogics jars and classpath
> settings to use the
> > > classes12.jar, but got the same error, so I
> pulled weblogic oracle jar
> > > into my test classpath to test if the problem
> was with the jars but
> > > the test worked fine ?? I am really stuck as to
> whom this should go to
> > > weblogic, oracle, or . I am hoping there is an
> expert there who can
> > > shed some light. Google did not have a single
> match for variations of
> > > the first 2 lines!!
> > >
> > > java.lang.ClassCastException
> > >
> > > at
> > >
> >
>
oracle.jdbc.driver.OracleConnection.unwrapCompletely(OracleConnection.jav=
> > a:5
> > 090)
> > >
> > > at
> > >
> >
>
oracle.jdbc.driver.OracleConnection.physicalConnectionWithin(OracleConnec=
> > tio
> > n.java:5141)
> > >
> > > at
> oracle.sql.CLOB.createTemporary(CLOB.java:1009)
> > >
> > > at
> oracle.sql.CLOB.createTemporary(CLOB.java:956)
> > >
> > > at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> > >
> > > at
> > >
> >
>
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java=
> > :39
> > )
> > >
> > > at
> > >
> >
>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
> 
=== message truncated === 


	
	
		
____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html