Menu
▾
▴
Re: [Springframework-developer] re: OracleLobCreator
|
From: <jue...@we...> - 2004-05-31 10:55:27
|
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= mpl .java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.pr= epa reLob(OracleLobHandler.java:375) > > at > org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.cr= eat eLob(OracleLobHandler.java:327) > > at > org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.se= tCl 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=3D3149&alloc_id=3D8166&op=3Dclick _______________________________________________ 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=3D3149&alloc_id=3D8166&op=3Dclick _______________________________________________ Springframework-developer mailing list Spr...@li... https://lists.sourceforge.net/lists/listinfo/springframework-developer |
