Menu
▾
▴
Re: [Springframework-developer] re: OracleLobCreator
|
From: Thomas R. <tho...@tr...> - 2004-05-31 20:02:58
|
Since you are using the Commons DBCP rather than a WebLogic pool the issue is slightly different. We have to figure out why the connection returned from the DBCP pool is not unwrapped properly. Thomas Bronwen Cassidy wrote: >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 > > >------------------------------------------------------- >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 > > > > > |
