Menu
▾
▴
Re: [Springframework-developer] re: OracleLobCreator
|
From: <bro...@ya...> - 2004-05-31 19:45:38
|
Thank-you Jurgen This was the approach i had come to conclude as the only difference between passing test case and failing deployed app is the connection pool handled by weblogic , ahh well another trip into the unknown, the best part of being a developer ;-) regards Bronwen --- jürgen_höller_[werk3AT] <jue...@we...> wrote: > 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. > > 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. > > 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... > > 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. > > Juergen > > > ________________________________ > > 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) > > 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.java:5 > 090) > > > > at > > > oracle.jdbc.driver.OracleConnection.physicalConnectionWithin(OracleConnectio > 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(DelegatingMethodAccessorImpl > .java:25) > > > > at > java.lang.reflect.Method.invoke(Method.java:324) > > > > at > > > org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.prepa > reLob(OracleLobHandler.java:375) > > > > at > > > org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.creat > eLob(OracleLobHandler.java:327) > > > > at > > > org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.setCl > obAsString(OracleLobHandler.java:255) > > > > thank-you for any help > > > > Bronwen > > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: Oracle 10g > Get certified on the hottest thing ever to hit the > market... Oracle 10g. > Take an Oracle 10g class now, and we'll give you the > exam FREE. > http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click > _______________________________________________ > Springframework-developer mailing list > Spr...@li... > https://lists.sourceforge.net/lists/listinfo/springframework-developer > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: Oracle 10g > Get certified on the hottest thing ever to hit the > market... Oracle 10g. > Take an Oracle 10g class now, and we'll give you the > exam FREE. > http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click > _______________________________________________ > Springframework-developer mailing list > Spr...@li... > https://lists.sourceforge.net/lists/listinfo/springframework-developer > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: Oracle 10g > Get certified on the hottest thing ever to hit the > market... Oracle 10g. > Take an Oracle 10g class now, and we'll give you the > exam FREE. > http://ads.osdn.com/?ad_id149&alloc_id66&op=click > _______________________________________________ > Springframework-developer mailing list > Spr...@li... > https://lists.sourceforge.net/lists/listinfo/springframework-developer ____________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html |
