Menu
▾
▴
springframework-developer
|
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 |
|
From: <jue...@we...> - 2004-05-31 15:03:42
|
I've done some quick googling, and found those related forum entries: =20 http://forum.java.sun.com/thread.jsp?thread=3D342767&forum=3D48&message=3D= 2018577 = <http://forum.java.sun.com/thread.jsp?thread=3D342767&forum=3D48&message=3D= 2018577>=20 http://coding.derkeiler.com/Archive/Java/comp.lang.java.databases/2003-10= /0156.html = <http://coding.derkeiler.com/Archive/Java/comp.lang.java.databases/2003-1= 0/0156.html>=20 http://www-106.ibm.com/developerworks/forums/dw_forum.jsp?forum=3D244&sta= rt=3D210&thRange=3D15&cat=3D10 = <http://www-106.ibm.com/developerworks/forums/dw_forum.jsp?forum=3D244&st= art=3D210&thRange=3D15&cat=3D10>=20 http://www.hibernate.org/56.html <http://www.hibernate.org/56.html>=20 So indeed Weblogic, WebSphere and OC4J seem to return special Connection = handles for Oracle - that are assignable to OracleConnection. = Nevertheless, we need to unwrap those for OracleLobHandler. You could configure your OracleLobHandler with Spring's = SimpleNativeJdbcExtractor: The latter uses a simple strategy of = retrieving the underlying Connection that should work with many pools = (namely, creating an empty java.sql.Statement and invoking getConnection = on it). For Spring 1.0.2, I've just changed SimpleNativeJdbcExtractor's strategy = (on the occasion of a comment in the Hibernate forum above): It attempts = to retrieve the underlying Connection via = conHandle.getMetaData().getConnection() now, which should work with even = more pools. I've also changed OracleLobHandler to use a SimpleNativeJdbcExtractor by = default, as the latter's new strategy should effectively work with = almost any connection pool (and a plain JDBC driver too). Note that OracleLobHandler just requires Connection unwrapping; For more = advanced usage of a NativeJdbcExtractor (for example with JdbcTemplate), = you still need specific NativeJdbcExtractor implementations for specific = connection pools. Juergen ________________________________ Von: spr...@li... im Auftrag = von j=FCrgen h=F6ller [werk3AT] Gesendet: Mo 31.05.2004 12:54 An: spr...@li... Betreff: Re: [Springframework-developer] re: OracleLobCreator 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.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 ------------------------------------------------------- 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_id=8166&op=3Dick _______________________________________________ Springframework-developer mailing list Spr...@li... https://lists.sourceforge.net/lists/listinfo/springframework-developer |
|
From: <jue...@we...> - 2004-05-31 20:30:52
|
Note that read access with OracleLobHandler does not need an unwrapped =
Connection; just write access via OracleLobCreator does.
=20
I've just decided to remove SimpleNativeJdbcExtractor as the =
OracleLobHandler default again, as it might be unwanted behavior if the =
pool offers handles that mirror the native Connections. There's a clear =
recommendation in the javadocs, though, particularly with respect to =
SimpleNativeJdbcExtractor's new strategy which should work with almost =
any connection pool.
=20
Juergen
=20
________________________________
Von: spr...@li... im Auftrag =
von tho...@tr...
Gesendet: Mo 31.05.2004 21:35
An: spr...@li...
Betreff: Re: [Springframework-developer] re: OracleLobCreator
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 =3D ds.getConnection();
lh =3D new OracleLobHandler();
ps =3D conn.prepareStatement("select text from docs where doc_id =
=3D 1");
rs =3D ps.executeQuery();
if (rs.next()) {
clobText =3D 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=FCrgen h=F6ller [werk3AT]" <jue...@we...>:
> OracleLobHandler needs to work on a native OracleConnection as it =
comes =3D
> from the driver. The usual problem in that respect is not the driver =
but =3D
> the connection pool: Every connection pool needs to wrap native =3D
> connections with pooled connections that at least have different =
closing =3D
> behavior.
> =3D20
> To address this, OracleLobHandler has the "nativeJdbcExtractor" =3D
> property, taking an implementation of Spring's NativeJdbcExtractor =3D
> interface. Spring includes out-of-the-box implementations for Commons =
=3D
> DBCP, XAPool, and JBoss. I guess what you need to do is write such an =
=3D
> extractor for Weblogic.
> =3D20
> What's odd about your exception is that OracleLobCreator does not =3D
> complain that it doesn't receive an OracleConnection (there's an =3D
> explicit check in there). It seems to get a wrapped connection that is =
=3D
> still assignable to OracleConnection, although it's not the native =3D
> OracleConnection from the driver...
> =3D20
> Maybe Weblogic uses some special way of pooling connections for the =
=3D
> Oracle driver, using poolable OracleConnections? The =3D
> getPhysicalConnection method will probably be in the OracleConnection =
=3D
> class, not in the CLOB class. Try writing a NativeJdbcExtractor that =
=3D
> unwraps an OracleConnection with that method.=3D20
> =3D20
> Juergen
> =3D20
>
> ________________________________
>
> Von: spr...@li... im Auftrag =
=3D
> 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 =
=3D
> thin
> drivers (not weblogic ones)=3D20
>
> 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 =3D
> 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=
=3D
> a:5
> 090)
> >
> > at
> >
> =
oracle.jdbc.driver.OracleConnection.physicalConnectionWithin(OracleConnec=
=3D
> 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=
=3D
> :39
> )
> >
> > at
> >
> =
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
=3D
> mpl
> .java:25)
> >
> > at java.lang.reflect.Method.invoke(Method.java:324)
> >
> > at
> >
> =
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.pr=
=3D
> epa
> reLob(OracleLobHandler.java:375)
> >
> > at
> >
> =
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.cr=
=3D
> eat
> eLob(OracleLobHandler.java:327)
> >
> > at
> >
> =
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.se=
=3D
> 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=3D3D3149&alloc_id=3D3D8166&op=3D3Dclick
> _______________________________________________
> 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=3D3D3149&alloc_id=3D3D8166&op=3D3Dclick
> _______________________________________________
> 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
>
-------------------------------------------------------
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
|
|
From: <jue...@we...> - 2004-05-31 20:36:14
|
Changing the pool should just affect the NativeJdbcExtractor choice, =
i.e. a different bean wired to OracleLobHandler's "nativeJdbcExtractor" =
property.
=20
Give SimpleNativeJdbcExtractor a try with a Weblogic pool; there's a =
good chance that it will work, avoiding the need for a specific Weblogic =
implementation of the NativeJdbcExtractor interface.
=20
As of Spring 1.0.2, SimpleNativeJdbcExtractor will even work with =
Commons DBCP too, avoiding the need for a different NativeJdbcExtractor =
configuration when switching between Commons DBCP and another pool.
=20
Side note: The new version of SimpleNativeJdbcExtractor will also work =
with C3P0. This allows the use of C3P0's ComboPooledDataSource as direct =
replacement of Commons DBCP's BasicDataSource.
=20
Juergen
=20
________________________________
Von: spr...@li... im Auftrag =
von Bronwen Cassidy
Gesendet: Mo 31.05.2004 22:25
An: spr...@li...
Betreff: Re: [Springframework-developer] re: OracleLobCreator
Hi
I have no concern as to the pool i use, i am actually
completely ignorant and have been blindly feeling my
way using the spring test cases, samples, docs and
some googling, until 4 months ago i had never used
oracle and until a week ago i did not need to do more
than work out db agnostic sql queries :-)
so please i am more than happy to use weblogic pool,
which i am using when the app is deployed, hence the
test time passes and deploy time failures most
likely!! I am guessing the changes are needed in the
nativeJdbcExtractor class in the spring.xml needs to
point to a weblogic equivalent??
--- Thomas Risberg <tho...@tr...> wrote:
> 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=FCrgen_h=F6ller_[werk3AT]
> ><jue...@we...> wrote: >
> >OracleLobHandler needs to work on a native
> >=20
> >
> >>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:
> >>
> >> =20
> >>
>
>spr...@li...
> >=20
> >
> >>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:
> >>
> >> =20
> >>
>
>spr...@li...
> >=20
> >
>
>[mailto:spr...@li...]
> >=20
> >
> >>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:
> >>
> >> =20
> >>
> >>>Hi I have a CLOB column in oracle and in the test
> >>> =20
> >>>
> >>there are no
> >> =20
> >>
> >>>problems, unfortunately deploying to weblogic I
> >>> =20
> >>>
> >>get the exception
> >> =20
> >>
> >>>below. We are using classes12.jar whereas
> weblogic
> >>> =20
> >>>
> >>uses ojdbc14.jar, I
> >> =20
> >>
> >>>firstly replaced weblogics jars and classpath
> >>> =20
> >>>
> >>settings to use the
> >> =20
> >>
> >>>classes12.jar, but got the same error, so I
> pulled
> >>> =20
> >>>
> >>weblogic oracle jar
> >> =20
> >>
> >>>into my test classpath to test if the problem was
> >>> =20
> >>>
> >>with the jars but
> >> =20
> >>
> >>>the test worked fine ?? I am really stuck as to
> >>> =20
> >>>
> >>whom this should go to
> >> =20
> >>
> >>>weblogic, oracle, or . I am hoping there is an
> >>> =20
> >>>
> >>expert there who can
> >> =20
> >>
> >>>shed some light. Google did not have a single
> >>> =20
> >>>
> >>match for variations of
> >> =20
> >>
> >>>the first 2 lines!!
> >>>
> >>>java.lang.ClassCastException
> >>>
> >>>at
> >>>
> >>> =20
> >>>
>
>oracle.jdbc.driver.OracleConnection.unwrapCompletely(OracleConnection.ja=
va:5
> >=20
>
=3D=3D=3D message truncated =3D=3D=3D
=20
=20
=20
____________________________________________________________
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=3D3149&alloc_id=3D8166&op=3Dclick
_______________________________________________
Springframework-developer mailing list
Spr...@li...
https://lists.sourceforge.net/lists/listinfo/springframework-developer
|
|
From: <tho...@tr...> - 2004-05-31 21:46:51
|
I was finally able to reproduce the error in my own environment using Spring
1.0.1. I will try 1.0.2 (current CVS) and see what happens.
Thomas
Here is my stack trace:
org.springframework.dao.DataAccessResourceFailureException: Could not create
Oracle LOB; nested exception is java.lang.ClassCastException: null
java.lang.ClassCastException
at
oracle.jdbc.driver.OracleConnection.unwrapCompletely(OracleConnection.java:5090)
at
oracle.jdbc.driver.OracleConnection.physicalConnectionWithin(OracleConnection.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.prepareLob(OracleLobHandler.java:375)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.createLob(OracleLobHandler.java:327)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.setClobAsString(OracleLobHandler.java:255)
at org.buggybean.web.TestServlet.doGet(TestServlet.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:971)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:402)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:305)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6350)
at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3635)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2585)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
Quoting "jürgen höller [werk3AT]" <jue...@we...>:
> Changing the pool should just affect the NativeJdbcExtractor choice, =
> i.e. a different bean wired to OracleLobHandler's "nativeJdbcExtractor" =
> property.
> =20
> Give SimpleNativeJdbcExtractor a try with a Weblogic pool; there's a =
> good chance that it will work, avoiding the need for a specific Weblogic =
> implementation of the NativeJdbcExtractor interface.
> =20
> As of Spring 1.0.2, SimpleNativeJdbcExtractor will even work with =
> Commons DBCP too, avoiding the need for a different NativeJdbcExtractor =
> configuration when switching between Commons DBCP and another pool.
> =20
> Side note: The new version of SimpleNativeJdbcExtractor will also work =
> with C3P0. This allows the use of C3P0's ComboPooledDataSource as direct =
> replacement of Commons DBCP's BasicDataSource.
> =20
> Juergen
> =20
>
> ________________________________
>
> Von: spr...@li... im Auftrag =
> von Bronwen Cassidy
> Gesendet: Mo 31.05.2004 22:25
> An: spr...@li...
> Betreff: Re: [Springframework-developer] re: OracleLobCreator
>
>
>
> Hi
> I have no concern as to the pool i use, i am actually
> completely ignorant and have been blindly feeling my
> way using the spring test cases, samples, docs and
> some googling, until 4 months ago i had never used
> oracle and until a week ago i did not need to do more
> than work out db agnostic sql queries :-)
>
> so please i am more than happy to use weblogic pool,
> which i am using when the app is deployed, hence the
> test time passes and deploy time failures most
> likely!! I am guessing the changes are needed in the
> nativeJdbcExtractor class in the spring.xml needs to
> point to a weblogic equivalent??
>
> --- Thomas Risberg <tho...@tr...> wrote:
> > 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=FCrgen_h=F6ller_[werk3AT]
> > ><jue...@we...> wrote: >
> > >OracleLobHandler needs to work on a native
> > >=20
> > >
> > >>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:
> > >>
> > >> =20
> > >>
> >
> >spr...@li...
> > >=20
> > >
> > >>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:
> > >>
> > >> =20
> > >>
> >
> >spr...@li...
> > >=20
> > >
> >
> >[mailto:spr...@li...]
> > >=20
> > >
> > >>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:
> > >>
> > >> =20
> > >>
> > >>>Hi I have a CLOB column in oracle and in the test
> > >>> =20
> > >>>
> > >>there are no
> > >> =20
> > >>
> > >>>problems, unfortunately deploying to weblogic I
> > >>> =20
> > >>>
> > >>get the exception
> > >> =20
> > >>
> > >>>below. We are using classes12.jar whereas
> > weblogic
> > >>> =20
> > >>>
> > >>uses ojdbc14.jar, I
> > >> =20
> > >>
> > >>>firstly replaced weblogics jars and classpath
> > >>> =20
> > >>>
> > >>settings to use the
> > >> =20
> > >>
> > >>>classes12.jar, but got the same error, so I
> > pulled
> > >>> =20
> > >>>
> > >>weblogic oracle jar
> > >> =20
> > >>
> > >>>into my test classpath to test if the problem was
> > >>> =20
> > >>>
> > >>with the jars but
> > >> =20
> > >>
> > >>>the test worked fine ?? I am really stuck as to
> > >>> =20
> > >>>
> > >>whom this should go to
> > >> =20
> > >>
> > >>>weblogic, oracle, or . I am hoping there is an
> > >>> =20
> > >>>
> > >>expert there who can
> > >> =20
> > >>
> > >>>shed some light. Google did not have a single
> > >>> =20
> > >>>
> > >>match for variations of
> > >> =20
> > >>
> > >>>the first 2 lines!!
> > >>>
> > >>>java.lang.ClassCastException
> > >>>
> > >>>at
> > >>>
> > >>> =20
> > >>>
> >
> >oracle.jdbc.driver.OracleConnection.unwrapCompletely(OracleConnection.ja=
> va:5
> > >=20
> >
> =3D=3D=3D message truncated =3D=3D=3D
>
>
> =20
> =20
> =20
> ____________________________________________________________
> 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=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=3149&alloc_id=8166&op=click
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
|
|
From: <bro...@ya...> - 2004-05-31 21:58:39
|
Hi,
Just tried with SimpleNativeJdbcExtractor using the
latest spring.jar from cvs :-) I am including my
context-jdbc.xml, it may shed some light as to what i
am doing wrong..
<bean id="dataSource"
class="org.springframework.jndi.JndiObjectFactoryBean">
<property
name="jndiName"><value>jdbc/TSDS</value></property>
</bean>
<bean id="jdbcTemplate"
class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource"><ref
local="dataSource"/></property>
<property name="exceptionTranslator"><ref
bean="oracleSqlExceptionTranslator"/></property>
</bean>
<bean id="nativeJdbcExtractor"
class="org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor"
lazy-init="true"/>
<bean id="oracleLobHandler"
class="org.springframework.jdbc.support.lob.OracleLobHandler">
<property name="nativeJdbcExtractor"><ref
local="nativeJdbcExtractor"/></property>
</bean>
the error (after a complete clean, uninstall delete
all previous version)
org.springframework.dao.DataAccessResourceFailureException:
Could not create Oracle LOB; nested exception is
java.lang.ClassCastExcepti
on: null
java.lang.ClassCastException
at
oracle.jdbc.driver.OracleConnection.unwrapCompletely(OracleConnection.java:5090)
at
oracle.jdbc.driver.OracleConnection.physicalConnectionWithin(OracleConnection.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.prepareLob(OracleLobHandler.java:383)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.createLob(OracleLobHandler.java:336)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.setClobAsString(OracleLobHandler.java:264)
Bronwen
--- tho...@tr... wrote: >
> I was finally able to reproduce the error in my own
> environment using Spring
> 1.0.1. I will try 1.0.2 (current CVS) and see what
> happens.
>
> Thomas
>
>
> Here is my stack trace:
>
>
org.springframework.dao.DataAccessResourceFailureException:
> Could not create
> Oracle LOB; nested exception is
> java.lang.ClassCastException: null
> java.lang.ClassCastException
> at
>
oracle.jdbc.driver.OracleConnection.unwrapCompletely(OracleConnection.java:5090)
> at
>
oracle.jdbc.driver.OracleConnection.physicalConnectionWithin(OracleConnection.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.prepareLob(OracleLobHandler.java:375)
> at
>
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.createLob(OracleLobHandler.java:327)
> at
>
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.setClobAsString(OracleLobHandler.java:255)
> at
>
org.buggybean.web.TestServlet.doGet(TestServlet.java:94)
> at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:971)
> at
>
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:402)
> at
>
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:305)
> at
>
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6350)
> at
>
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
> at
>
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
> at
>
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3635)
> at
>
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2585)
> at
>
weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
> at
>
weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
>
>
>
>
> Quoting "jürgen höller [werk3AT]"
> <jue...@we...>:
>
> > Changing the pool should just affect the
> NativeJdbcExtractor choice, =
> > i.e. a different bean wired to OracleLobHandler's
> "nativeJdbcExtractor" =
> > property.
> > =20
> > Give SimpleNativeJdbcExtractor a try with a
> Weblogic pool; there's a =
> > good chance that it will work, avoiding the need
> for a specific Weblogic =
> > implementation of the NativeJdbcExtractor
> interface.
> > =20
> > As of Spring 1.0.2, SimpleNativeJdbcExtractor will
> even work with =
> > Commons DBCP too, avoiding the need for a
> different NativeJdbcExtractor =
> > configuration when switching between Commons DBCP
> and another pool.
> > =20
> > Side note: The new version of
> SimpleNativeJdbcExtractor will also work =
> > with C3P0. This allows the use of C3P0's
> ComboPooledDataSource as direct =
> > replacement of Commons DBCP's BasicDataSource.
> > =20
> > Juergen
> > =20
> >
> > ________________________________
> >
> > Von:
>
spr...@li...
> im Auftrag =
> > von Bronwen Cassidy
> > Gesendet: Mo 31.05.2004 22:25
> > An:
> spr...@li...
> > Betreff: Re: [Springframework-developer] re:
> OracleLobCreator
> >
> >
> >
> > Hi
> > I have no concern as to the pool i use, i am
> actually
> > completely ignorant and have been blindly feeling
> my
> > way using the spring test cases, samples, docs and
> > some googling, until 4 months ago i had never used
> > oracle and until a week ago i did not need to do
> more
> > than work out db agnostic sql queries :-)
> >
> > so please i am more than happy to use weblogic
> pool,
> > which i am using when the app is deployed, hence
> the
> > test time passes and deploy time failures most
> > likely!! I am guessing the changes are needed in
> the
> > nativeJdbcExtractor class in the spring.xml needs
> to
> > point to a weblogic equivalent??
> >
> > --- Thomas Risberg <tho...@tr...>
> wrote:
> > > 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=FCrgen_h=F6ller_[werk3AT]
> > > ><jue...@we...> wrote: >
> > > >OracleLobHandler needs to work on a native
> > > >=20
> > > >
> > > >>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
>
=== message truncated ===
____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
|
|
From: Bronwen C. <bro...@ya...> - 2004-05-31 22:02:32
|
Hi,
My tests pass though using different datasource the config for a passing
test ...
<bean id=3D"nativeJdbcExtractor"
class=3D"org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtr=
acto"
lazy-init=3D"true"/>
<bean id=3D"oracleLobHandler"
class=3D"org.springframework.jdbc.support.lob.OracleLobHandler"
lazy-init=3D"true">
<property name=3D"nativeJdbcExtractor"><ref
local=3D"nativeJdbcExtractor"/></property>
</bean>
<bean id=3D"dataSource" class=3D"oracle.jdbc.pool.OracleDataSource">
<property
name=3D"driverType"><value>oracle.jdbc.OracleDriver</value></property>
<property
name=3D"URL"><value>jdbc:oracle:thin:@localhost:1521:ROBIN</value></prope=
rty>
<property name=3D"user"><value>talentstudio</value></property>
<property
name=3D"password"><value>talentstudio</value></property>
</bean>
<bean id=3D"template" =
class=3D"org.springframework.jdbc.core.JdbcTemplate">
<property name=3D"dataSource"><ref =
local=3D"dataSource"/></property>
</bean>
The only difference is the datasource is not looked up!! I will try the
weblogic one in the test and see if that works.
Thanx=20
Bronwen
-----Original Message-----
From: spr...@li...
[mailto:spr...@li...] On Behalf =
Of
tho...@tr...
Sent: 31 May 2004 21:47
To: spr...@li...
Subject: Re: [Springframework-developer] re: OracleLobCreator
I was finally able to reproduce the error in my own environment using =
Spring
1.0.1. I will try 1.0.2 (current CVS) and see what happens.
Thomas
Here is my stack trace:
org.springframework.dao.DataAccessResourceFailureException: Could not =
create
Oracle LOB; nested exception is java.lang.ClassCastException: null
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)
at org.buggybean.web.TestServlet.doGet(TestServlet.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(Ser=
vle
tStubImpl.java:971)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.j=
ava
:402)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.j=
ava
:305)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.ru=
n(W
ebAppServletContext.java:6350)
at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSub=
jec
t.java:317)
at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)=
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServle=
tCo
ntext.java:3635)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.j=
ava
:2585)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
Quoting "j=FCrgen h=F6ller [werk3AT]" <jue...@we...>:
> Changing the pool should just affect the NativeJdbcExtractor choice, =
=3D
> i.e. a different bean wired to OracleLobHandler's =
"nativeJdbcExtractor" =3D
> property.
> =3D20
> Give SimpleNativeJdbcExtractor a try with a Weblogic pool; there's a =
=3D
> good chance that it will work, avoiding the need for a specific =
Weblogic =3D
> implementation of the NativeJdbcExtractor interface.
> =3D20
> As of Spring 1.0.2, SimpleNativeJdbcExtractor will even work with =3D
> Commons DBCP too, avoiding the need for a different =
NativeJdbcExtractor =3D
> configuration when switching between Commons DBCP and another pool.
> =3D20
> Side note: The new version of SimpleNativeJdbcExtractor will also work =
=3D
> with C3P0. This allows the use of C3P0's ComboPooledDataSource as =
direct =3D
> replacement of Commons DBCP's BasicDataSource.
> =3D20
> Juergen
> =3D20
>
> ________________________________
>
> Von: spr...@li... im Auftrag =
=3D
> von Bronwen Cassidy
> Gesendet: Mo 31.05.2004 22:25
> An: spr...@li...
> Betreff: Re: [Springframework-developer] re: OracleLobCreator
>
>
>
> Hi
> I have no concern as to the pool i use, i am actually
> completely ignorant and have been blindly feeling my
> way using the spring test cases, samples, docs and
> some googling, until 4 months ago i had never used
> oracle and until a week ago i did not need to do more
> than work out db agnostic sql queries :-)
>
> so please i am more than happy to use weblogic pool,
> which i am using when the app is deployed, hence the
> test time passes and deploy time failures most
> likely!! I am guessing the changes are needed in the
> nativeJdbcExtractor class in the spring.xml needs to
> point to a weblogic equivalent??
>
> --- Thomas Risberg <tho...@tr...> wrote:
> > 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=3DFCrgen_h=3DF6ller_[werk3AT]
> > ><jue...@we...> wrote: >
> > >OracleLobHandler needs to work on a native
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> >
> >spr...@li...
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> >
> >spr...@li...
> > >=3D20
> > >
> >
> >[mailto:spr...@li...]
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> > >>>Hi I have a CLOB column in oracle and in the test
> > >>> =3D20
> > >>>
> > >>there are no
> > >> =3D20
> > >>
> > >>>problems, unfortunately deploying to weblogic I
> > >>> =3D20
> > >>>
> > >>get the exception
> > >> =3D20
> > >>
> > >>>below. We are using classes12.jar whereas
> > weblogic
> > >>> =3D20
> > >>>
> > >>uses ojdbc14.jar, I
> > >> =3D20
> > >>
> > >>>firstly replaced weblogics jars and classpath
> > >>> =3D20
> > >>>
> > >>settings to use the
> > >> =3D20
> > >>
> > >>>classes12.jar, but got the same error, so I
> > pulled
> > >>> =3D20
> > >>>
> > >>weblogic oracle jar
> > >> =3D20
> > >>
> > >>>into my test classpath to test if the problem was
> > >>> =3D20
> > >>>
> > >>with the jars but
> > >> =3D20
> > >>
> > >>>the test worked fine ?? I am really stuck as to
> > >>> =3D20
> > >>>
> > >>whom this should go to
> > >> =3D20
> > >>
> > >>>weblogic, oracle, or . I am hoping there is an
> > >>> =3D20
> > >>>
> > >>expert there who can
> > >> =3D20
> > >>
> > >>>shed some light. Google did not have a single
> > >>> =3D20
> > >>>
> > >>match for variations of
> > >> =3D20
> > >>
> > >>>the first 2 lines!!
> > >>>
> > >>>java.lang.ClassCastException
> > >>>
> > >>>at
> > >>>
> > >>> =3D20
> > >>>
> >
> =
>oracle.jdbc.driver.OracleConnection.unwrapCompletely(OracleConnection.ja=
=3D
> va:5
> > >=3D20
> >
> =3D3D=3D3D=3D3D message truncated =3D3D=3D3D=3D3D
>
>
> =3D20
> =3D20
> =3D20
> ____________________________________________________________
> 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=3D3D3149&alloc_id=3D3D8166&op=3D3Dclick
> _______________________________________________
> 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
>
-------------------------------------------------------
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
|
|
From: Bronwen C. <bro...@ya...> - 2004-05-31 22:24:46
|
Hi,
OK the results when changing the driver for the pool from =
jdbc:oracle:thin
to: jdbc:weblogic:oracle using SimpleNativeJdbcExtractor
Error:
org.springframework.dao.DataAccessResourceFailureException: Could not =
create
Oracle LOB; nested exception is org.springframework.dao.In
validDataAccessApiUsageException: OracleLobHandler needs to work on
oracle.jdbc.OracleConnection - specify a proper NativeJdbcExtractor
org.springframework.dao.InvalidDataAccessApiUsageException: =
OracleLobHandler
needs to work on oracle.jdbc.OracleConnection - specify a
proper NativeJdbcExtractor
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.ge=
tOr
acleConnection(OracleLobHandler.java:366)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.cr=
eat
eLob(OracleLobHandler.java:336)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.se=
tCl
obAsString(OracleLobHandler.java:264)
at
com.zynap.talentstudio.dao.jdbc.oracle.datamanipulation.PortfolioDataMani=
pul
ation$1.setValues(PortfolioDataManipulation.java
:50)
at
org.springframework.jdbc.core.support.AbstractLobCreatingPreparedStatemen=
tCa
llback.doInPreparedStatement(AbstractLobCreating
PreparedStatementCallback.java:71)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:292)=
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:308)=
-----Original Message-----
From: spr...@li...
[mailto:spr...@li...] On Behalf =
Of
tho...@tr...
Sent: 31 May 2004 21:47
To: spr...@li...
Subject: Re: [Springframework-developer] re: OracleLobCreator
I was finally able to reproduce the error in my own environment using =
Spring
1.0.1. I will try 1.0.2 (current CVS) and see what happens.
Thomas
Here is my stack trace:
org.springframework.dao.DataAccessResourceFailureException: Could not =
create
Oracle LOB; nested exception is java.lang.ClassCastException: null
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)
at org.buggybean.web.TestServlet.doGet(TestServlet.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(Ser=
vle
tStubImpl.java:971)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.j=
ava
:402)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.j=
ava
:305)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.ru=
n(W
ebAppServletContext.java:6350)
at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSub=
jec
t.java:317)
at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)=
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServle=
tCo
ntext.java:3635)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.j=
ava
:2585)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
Quoting "j=FCrgen h=F6ller [werk3AT]" <jue...@we...>:
> Changing the pool should just affect the NativeJdbcExtractor choice, =
=3D
> i.e. a different bean wired to OracleLobHandler's =
"nativeJdbcExtractor" =3D
> property.
> =3D20
> Give SimpleNativeJdbcExtractor a try with a Weblogic pool; there's a =
=3D
> good chance that it will work, avoiding the need for a specific =
Weblogic =3D
> implementation of the NativeJdbcExtractor interface.
> =3D20
> As of Spring 1.0.2, SimpleNativeJdbcExtractor will even work with =3D
> Commons DBCP too, avoiding the need for a different =
NativeJdbcExtractor =3D
> configuration when switching between Commons DBCP and another pool.
> =3D20
> Side note: The new version of SimpleNativeJdbcExtractor will also work =
=3D
> with C3P0. This allows the use of C3P0's ComboPooledDataSource as =
direct =3D
> replacement of Commons DBCP's BasicDataSource.
> =3D20
> Juergen
> =3D20
>
> ________________________________
>
> Von: spr...@li... im Auftrag =
=3D
> von Bronwen Cassidy
> Gesendet: Mo 31.05.2004 22:25
> An: spr...@li...
> Betreff: Re: [Springframework-developer] re: OracleLobCreator
>
>
>
> Hi
> I have no concern as to the pool i use, i am actually
> completely ignorant and have been blindly feeling my
> way using the spring test cases, samples, docs and
> some googling, until 4 months ago i had never used
> oracle and until a week ago i did not need to do more
> than work out db agnostic sql queries :-)
>
> so please i am more than happy to use weblogic pool,
> which i am using when the app is deployed, hence the
> test time passes and deploy time failures most
> likely!! I am guessing the changes are needed in the
> nativeJdbcExtractor class in the spring.xml needs to
> point to a weblogic equivalent??
>
> --- Thomas Risberg <tho...@tr...> wrote:
> > 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=3DFCrgen_h=3DF6ller_[werk3AT]
> > ><jue...@we...> wrote: >
> > >OracleLobHandler needs to work on a native
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> >
> >spr...@li...
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> >
> >spr...@li...
> > >=3D20
> > >
> >
> >[mailto:spr...@li...]
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> > >>>Hi I have a CLOB column in oracle and in the test
> > >>> =3D20
> > >>>
> > >>there are no
> > >> =3D20
> > >>
> > >>>problems, unfortunately deploying to weblogic I
> > >>> =3D20
> > >>>
> > >>get the exception
> > >> =3D20
> > >>
> > >>>below. We are using classes12.jar whereas
> > weblogic
> > >>> =3D20
> > >>>
> > >>uses ojdbc14.jar, I
> > >> =3D20
> > >>
> > >>>firstly replaced weblogics jars and classpath
> > >>> =3D20
> > >>>
> > >>settings to use the
> > >> =3D20
> > >>
> > >>>classes12.jar, but got the same error, so I
> > pulled
> > >>> =3D20
> > >>>
> > >>weblogic oracle jar
> > >> =3D20
> > >>
> > >>>into my test classpath to test if the problem was
> > >>> =3D20
> > >>>
> > >>with the jars but
> > >> =3D20
> > >>
> > >>>the test worked fine ?? I am really stuck as to
> > >>> =3D20
> > >>>
> > >>whom this should go to
> > >> =3D20
> > >>
> > >>>weblogic, oracle, or . I am hoping there is an
> > >>> =3D20
> > >>>
> > >>expert there who can
> > >> =3D20
> > >>
> > >>>shed some light. Google did not have a single
> > >>> =3D20
> > >>>
> > >>match for variations of
> > >> =3D20
> > >>
> > >>>the first 2 lines!!
> > >>>
> > >>>java.lang.ClassCastException
> > >>>
> > >>>at
> > >>>
> > >>> =3D20
> > >>>
> >
> =
>oracle.jdbc.driver.OracleConnection.unwrapCompletely(OracleConnection.ja=
=3D
> va:5
> > >=3D20
> >
> =3D3D=3D3D=3D3D message truncated =3D3D=3D3D=3D3D
>
>
> =3D20
> =3D20
> =3D20
> ____________________________________________________________
> 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=3D3D3149&alloc_id=3D3D8166&op=3D3Dclick
> _______________________________________________
> 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
>
-------------------------------------------------------
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
|
|
From: <jue...@we...> - 2004-05-31 22:03:26
|
Thomas,
=20
Good timing - I've just created the distribution zips and am running =
final sanity checks. Gonna upload them to SourceForge within the next =
hour.
=20
You won't see any different with 1.0.2's standard OracleLobHandler, but =
it would be great if you could still test it within the next few =
minutes. Please grab the very latest CVS contents; I've applied some =
fine-tuning in the last couple of hours. Try setting a =
SimpleNativeJdbcExtractor and see whether it works then.
=20
Juergen
=20
________________________________
Von: spr...@li... im Auftrag =
von tho...@tr...
Gesendet: Mo 31.05.2004 23:46
An: spr...@li...
Betreff: Re: [Springframework-developer] re: OracleLobCreator
I was finally able to reproduce the error in my own environment using =
Spring
1.0.1. I will try 1.0.2 (current CVS) and see what happens.
Thomas
Here is my stack trace:
org.springframework.dao.DataAccessResourceFailureException: Could not =
create
Oracle LOB; nested exception is java.lang.ClassCastException: null
java.lang.ClassCastException
at
oracle.jdbc.driver.OracleConnection.unwrapCompletely(OracleConnection.jav=
a:5090)
at
oracle.jdbc.driver.OracleConnection.physicalConnectionWithin(OracleConnec=
tion.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=
epareLob(OracleLobHandler.java:375)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.cr=
eateLob(OracleLobHandler.java:327)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.se=
tClobAsString(OracleLobHandler.java:255)
at org.buggybean.web.TestServlet.doGet(TestServlet.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(Ser=
vletStubImpl.java:971)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.j=
ava:402)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.j=
ava:305)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.ru=
n(WebAppServletContext.java:6350)
at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSub=
ject.java:317)
at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)=
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServle=
tContext.java:3635)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.j=
ava:2585)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
Quoting "j=FCrgen h=F6ller [werk3AT]" <jue...@we...>:
> Changing the pool should just affect the NativeJdbcExtractor choice, =
=3D
> i.e. a different bean wired to OracleLobHandler's =
"nativeJdbcExtractor" =3D
> property.
> =3D20
> Give SimpleNativeJdbcExtractor a try with a Weblogic pool; there's a =
=3D
> good chance that it will work, avoiding the need for a specific =
Weblogic =3D
> implementation of the NativeJdbcExtractor interface.
> =3D20
> As of Spring 1.0.2, SimpleNativeJdbcExtractor will even work with =3D
> Commons DBCP too, avoiding the need for a different =
NativeJdbcExtractor =3D
> configuration when switching between Commons DBCP and another pool.
> =3D20
> Side note: The new version of SimpleNativeJdbcExtractor will also work =
=3D
> with C3P0. This allows the use of C3P0's ComboPooledDataSource as =
direct =3D
> replacement of Commons DBCP's BasicDataSource.
> =3D20
> Juergen
> =3D20
>
> ________________________________
>
> Von: spr...@li... im Auftrag =
=3D
> von Bronwen Cassidy
> Gesendet: Mo 31.05.2004 22:25
> An: spr...@li...
> Betreff: Re: [Springframework-developer] re: OracleLobCreator
>
>
>
> Hi
> I have no concern as to the pool i use, i am actually
> completely ignorant and have been blindly feeling my
> way using the spring test cases, samples, docs and
> some googling, until 4 months ago i had never used
> oracle and until a week ago i did not need to do more
> than work out db agnostic sql queries :-)
>
> so please i am more than happy to use weblogic pool,
> which i am using when the app is deployed, hence the
> test time passes and deploy time failures most
> likely!! I am guessing the changes are needed in the
> nativeJdbcExtractor class in the spring.xml needs to
> point to a weblogic equivalent??
>
> --- Thomas Risberg <tho...@tr...> wrote:
> > 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=3DFCrgen_h=3DF6ller_[werk3AT]
> > ><jue...@we...> wrote: >
> > >OracleLobHandler needs to work on a native
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> >
> >spr...@li...
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> >
> >spr...@li...
> > >=3D20
> > >
> >
> >[mailto:spr...@li...]
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> > >>>Hi I have a CLOB column in oracle and in the test
> > >>> =3D20
> > >>>
> > >>there are no
> > >> =3D20
> > >>
> > >>>problems, unfortunately deploying to weblogic I
> > >>> =3D20
> > >>>
> > >>get the exception
> > >> =3D20
> > >>
> > >>>below. We are using classes12.jar whereas
> > weblogic
> > >>> =3D20
> > >>>
> > >>uses ojdbc14.jar, I
> > >> =3D20
> > >>
> > >>>firstly replaced weblogics jars and classpath
> > >>> =3D20
> > >>>
> > >>settings to use the
> > >> =3D20
> > >>
> > >>>classes12.jar, but got the same error, so I
> > pulled
> > >>> =3D20
> > >>>
> > >>weblogic oracle jar
> > >> =3D20
> > >>
> > >>>into my test classpath to test if the problem was
> > >>> =3D20
> > >>>
> > >>with the jars but
> > >> =3D20
> > >>
> > >>>the test worked fine ?? I am really stuck as to
> > >>> =3D20
> > >>>
> > >>whom this should go to
> > >> =3D20
> > >>
> > >>>weblogic, oracle, or . I am hoping there is an
> > >>> =3D20
> > >>>
> > >>expert there who can
> > >> =3D20
> > >>
> > >>>shed some light. Google did not have a single
> > >>> =3D20
> > >>>
> > >>match for variations of
> > >> =3D20
> > >>
> > >>>the first 2 lines!!
> > >>>
> > >>>java.lang.ClassCastException
> > >>>
> > >>>at
> > >>>
> > >>> =3D20
> > >>>
> >
> =
>oracle.jdbc.driver.OracleConnection.unwrapCompletely(OracleConnection.ja=
=3D
> va:5
> > >=3D20
> >
> =3D3D=3D3D=3D3D message truncated =3D3D=3D3D=3D3D
>
>
> =3D20
> =3D20
> =3D20
> ____________________________________________________________
> 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=3D3D3149&alloc_id=3D3D8166&op=3D3Dclick
> _______________________________________________
> 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
>
-------------------------------------------------------
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
|
|
From: <jue...@we...> - 2004-05-31 22:52:56
|
Can you check what kind of wrappers the DataSource returns? Simply fetch =
the DataSource, invoke getConnection() and see what kind of handle it =
returns (System.out.println). Furthermore, invoke =
getConnection().getMetaData().getConnection() and see whether this is =
the native Connection (System.out.println again).=20
=20
However, if you have properly specified SimpleNativeJdbcExtractor for =
OracleLobHandler's "nativeJdbcExtractor" property and still get that =
exception, then I assume that Weblogic's own Oracle JDBC driver doesn't =
use the OracleConnection class at all. This would mean that =
OracleLobHandler cannot be used with it.
=20
Do I understand correctly that OracleLobHandler plus =
SimpleNativeJdbcExtractor work properly with Oracle's original JDBC =
driver plus Weblogic's connection pool?
=20
Juergen
=20
________________________________
Von: spr...@li... im Auftrag =
von Bronwen Cassidy
Gesendet: Di 01.06.2004 00:24
An: spr...@li...
Betreff: RE: [Springframework-developer] re: OracleLobCreator
Hi,
OK the results when changing the driver for the pool from =
jdbc:oracle:thin
to: jdbc:weblogic:oracle using SimpleNativeJdbcExtractor
Error:
org.springframework.dao.DataAccessResourceFailureException: Could not =
create
Oracle LOB; nested exception is org.springframework.dao.In
validDataAccessApiUsageException: OracleLobHandler needs to work on
oracle.jdbc.OracleConnection - specify a proper NativeJdbcExtractor
org.springframework.dao.InvalidDataAccessApiUsageException: =
OracleLobHandler
needs to work on oracle.jdbc.OracleConnection - specify a
proper NativeJdbcExtractor
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.ge=
tOr
acleConnection(OracleLobHandler.java:366)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.cr=
eat
eLob(OracleLobHandler.java:336)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.se=
tCl
obAsString(OracleLobHandler.java:264)
at
com.zynap.talentstudio.dao.jdbc.oracle.datamanipulation.PortfolioDataMani=
pul
ation$1.setValues(PortfolioDataManipulation.java
:50)
at
org.springframework.jdbc.core.support.AbstractLobCreatingPreparedStatemen=
tCa
llback.doInPreparedStatement(AbstractLobCreating
PreparedStatementCallback.java:71)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:292)=
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:308)=
-----Original Message-----
From: spr...@li...
[mailto:spr...@li...] On Behalf =
Of
tho...@tr...
Sent: 31 May 2004 21:47
To: spr...@li...
Subject: Re: [Springframework-developer] re: OracleLobCreator
I was finally able to reproduce the error in my own environment using =
Spring
1.0.1. I will try 1.0.2 (current CVS) and see what happens.
Thomas
Here is my stack trace:
org.springframework.dao.DataAccessResourceFailureException: Could not =
create
Oracle LOB; nested exception is java.lang.ClassCastException: null
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)
at org.buggybean.web.TestServlet.doGet(TestServlet.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(Ser=
vle
tStubImpl.java:971)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.j=
ava
:402)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.j=
ava
:305)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.ru=
n(W
ebAppServletContext.java:6350)
at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSub=
jec
t.java:317)
at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)=
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServle=
tCo
ntext.java:3635)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.j=
ava
:2585)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
Quoting "j=FCrgen h=F6ller [werk3AT]" <jue...@we...>:
> Changing the pool should just affect the NativeJdbcExtractor choice, =
=3D
> i.e. a different bean wired to OracleLobHandler's =
"nativeJdbcExtractor" =3D
> property.
> =3D20
> Give SimpleNativeJdbcExtractor a try with a Weblogic pool; there's a =
=3D
> good chance that it will work, avoiding the need for a specific =
Weblogic =3D
> implementation of the NativeJdbcExtractor interface.
> =3D20
> As of Spring 1.0.2, SimpleNativeJdbcExtractor will even work with =3D
> Commons DBCP too, avoiding the need for a different =
NativeJdbcExtractor =3D
> configuration when switching between Commons DBCP and another pool.
> =3D20
> Side note: The new version of SimpleNativeJdbcExtractor will also work =
=3D
> with C3P0. This allows the use of C3P0's ComboPooledDataSource as =
direct =3D
> replacement of Commons DBCP's BasicDataSource.
> =3D20
> Juergen
> =3D20
>
> ________________________________
>
> Von: spr...@li... im Auftrag =
=3D
> von Bronwen Cassidy
> Gesendet: Mo 31.05.2004 22:25
> An: spr...@li...
> Betreff: Re: [Springframework-developer] re: OracleLobCreator
>
>
>
> Hi
> I have no concern as to the pool i use, i am actually
> completely ignorant and have been blindly feeling my
> way using the spring test cases, samples, docs and
> some googling, until 4 months ago i had never used
> oracle and until a week ago i did not need to do more
> than work out db agnostic sql queries :-)
>
> so please i am more than happy to use weblogic pool,
> which i am using when the app is deployed, hence the
> test time passes and deploy time failures most
> likely!! I am guessing the changes are needed in the
> nativeJdbcExtractor class in the spring.xml needs to
> point to a weblogic equivalent??
>
> --- Thomas Risberg <tho...@tr...> wrote:
> > 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=3DFCrgen_h=3DF6ller_[werk3AT]
> > ><jue...@we...> wrote: >
> > >OracleLobHandler needs to work on a native
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> >
> >spr...@li...
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> >
> >spr...@li...
> > >=3D20
> > >
> >
> >[mailto:spr...@li...]
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> > >>>Hi I have a CLOB column in oracle and in the test
> > >>> =3D20
> > >>>
> > >>there are no
> > >> =3D20
> > >>
> > >>>problems, unfortunately deploying to weblogic I
> > >>> =3D20
> > >>>
> > >>get the exception
> > >> =3D20
> > >>
> > >>>below. We are using classes12.jar whereas
> > weblogic
> > >>> =3D20
> > >>>
> > >>uses ojdbc14.jar, I
> > >> =3D20
> > >>
> > >>>firstly replaced weblogics jars and classpath
> > >>> =3D20
> > >>>
> > >>settings to use the
> > >> =3D20
> > >>
> > >>>classes12.jar, but got the same error, so I
> > pulled
> > >>> =3D20
> > >>>
> > >>weblogic oracle jar
> > >> =3D20
> > >>
> > >>>into my test classpath to test if the problem was
> > >>> =3D20
> > >>>
> > >>with the jars but
> > >> =3D20
> > >>
> > >>>the test worked fine ?? I am really stuck as to
> > >>> =3D20
> > >>>
> > >>whom this should go to
> > >> =3D20
> > >>
> > >>>weblogic, oracle, or . I am hoping there is an
> > >>> =3D20
> > >>>
> > >>expert there who can
> > >> =3D20
> > >>
> > >>>shed some light. Google did not have a single
> > >>> =3D20
> > >>>
> > >>match for variations of
> > >> =3D20
> > >>
> > >>>the first 2 lines!!
> > >>>
> > >>>java.lang.ClassCastException
> > >>>
> > >>>at
> > >>>
> > >>> =3D20
> > >>>
> >
> =
>oracle.jdbc.driver.OracleConnection.unwrapCompletely(OracleConnection.ja=
=3D
> va:5
> > >=3D20
> >
> =3D3D=3D3D=3D3D message truncated =3D3D=3D3D=3D3D
>
>
> =3D20
> =3D20
> =3D20
> ____________________________________________________________
> 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=3D3D3149&alloc_id=3D3D8166&op=3D3Dclick
> _______________________________________________
> 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
>
-------------------------------------------------------
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_id149&alloc_id=8166&op=3Dick
_______________________________________________
Springframework-developer mailing list
Spr...@li...
https://lists.sourceforge.net/lists/listinfo/springframework-developer
|
|
From: Bronwen C. <bro...@ya...> - 2004-05-31 23:20:20
|
Hi,
If I understand your question, OracleLobHandler works in a test case =
without
weblogics pool, only using the oracle.jdbc.pool.OracleDataSource =
datasource
bean defined as:
<bean id=3D"dataSource" class=3D"oracle.jdbc.pool.OracleDataSource">
<property
name=3D"driverType"><value>oracle.jdbc.OracleDriver</value></property>
<property
name=3D"URL"><value>jdbc:oracle:thin:@localhost:1521:ROBIN</value></prope=
rty>
<property name=3D"user"><value>talentstudio</value></property>
<property
name=3D"password"><value>talentstudio</value></property>
</bean>
In deployment I have set up a weblogic pool using oracle thin driver, =
not a
weblogic oracle driver.=20
So from what I can determine weblogic pool + oracle driver +
oracleLobHandler throws the exception and
Oracle jdbc pool + oracleLobHandler (as in test case) works.
The printouts:
template.getDataSource().getConnection()=3D
weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_OracleConnection@=
112
connection.getMetaData().getConnection() =3D
weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_OracleConnection@=
112
-----Original Message-----
From: spr...@li...
[mailto:spr...@li...] On Behalf =
Of
j=FCrgen h=F6ller [werk3AT]
Sent: 31 May 2004 22:52
To: spr...@li...
Subject: Re: [Springframework-developer] re: OracleLobCreator
Can you check what kind of wrappers the DataSource returns? Simply fetch =
the
DataSource, invoke getConnection() and see what kind of handle it =
returns
(System.out.println). Furthermore, invoke
getConnection().getMetaData().getConnection() and see whether this is =
the
native Connection (System.out.println again).=20
=20
However, if you have properly specified SimpleNativeJdbcExtractor for
OracleLobHandler's "nativeJdbcExtractor" property and still get that
exception, then I assume that Weblogic's own Oracle JDBC driver doesn't =
use
the OracleConnection class at all. This would mean that OracleLobHandler
cannot be used with it.
=20
Do I understand correctly that OracleLobHandler plus
SimpleNativeJdbcExtractor work properly with Oracle's original JDBC =
driver
plus Weblogic's connection pool?
=20
Juergen
=20
________________________________
Von: spr...@li... im Auftrag =
von
Bronwen Cassidy
Gesendet: Di 01.06.2004 00:24
An: spr...@li...
Betreff: RE: [Springframework-developer] re: OracleLobCreator
Hi,
OK the results when changing the driver for the pool from =
jdbc:oracle:thin
to: jdbc:weblogic:oracle using SimpleNativeJdbcExtractor
Error:
org.springframework.dao.DataAccessResourceFailureException: Could not =
create
Oracle LOB; nested exception is org.springframework.dao.In
validDataAccessApiUsageException: OracleLobHandler needs to work on
oracle.jdbc.OracleConnection - specify a proper NativeJdbcExtractor
org.springframework.dao.InvalidDataAccessApiUsageException: =
OracleLobHandler
needs to work on oracle.jdbc.OracleConnection - specify a
proper NativeJdbcExtractor
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.ge=
tOr
acleConnection(OracleLobHandler.java:366)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.cr=
eat
eLob(OracleLobHandler.java:336)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.se=
tCl
obAsString(OracleLobHandler.java:264)
at
com.zynap.talentstudio.dao.jdbc.oracle.datamanipulation.PortfolioDataMani=
pul
ation$1.setValues(PortfolioDataManipulation.java
:50)
at
org.springframework.jdbc.core.support.AbstractLobCreatingPreparedStatemen=
tCa
llback.doInPreparedStatement(AbstractLobCreating
PreparedStatementCallback.java:71)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:292)=
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:308)=
-----Original Message-----
From: spr...@li...
[mailto:spr...@li...] On Behalf =
Of
tho...@tr...
Sent: 31 May 2004 21:47
To: spr...@li...
Subject: Re: [Springframework-developer] re: OracleLobCreator
I was finally able to reproduce the error in my own environment using =
Spring
1.0.1. I will try 1.0.2 (current CVS) and see what happens.
Thomas
Here is my stack trace:
org.springframework.dao.DataAccessResourceFailureException: Could not =
create
Oracle LOB; nested exception is java.lang.ClassCastException: null
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)
at org.buggybean.web.TestServlet.doGet(TestServlet.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(Ser=
vle
tStubImpl.java:971)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.j=
ava
:402)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.j=
ava
:305)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.ru=
n(W
ebAppServletContext.java:6350)
at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSub=
jec
t.java:317)
at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)=
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServle=
tCo
ntext.java:3635)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.j=
ava
:2585)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
Quoting "j=FCrgen h=F6ller [werk3AT]" <jue...@we...>:
> Changing the pool should just affect the NativeJdbcExtractor choice, =
=3D
> i.e. a different bean wired to OracleLobHandler's =
"nativeJdbcExtractor" =3D
> property.
> =3D20
> Give SimpleNativeJdbcExtractor a try with a Weblogic pool; there's a =
=3D
> good chance that it will work, avoiding the need for a specific =
Weblogic =3D
> implementation of the NativeJdbcExtractor interface.
> =3D20
> As of Spring 1.0.2, SimpleNativeJdbcExtractor will even work with =3D
> Commons DBCP too, avoiding the need for a different =
NativeJdbcExtractor =3D
> configuration when switching between Commons DBCP and another pool.
> =3D20
> Side note: The new version of SimpleNativeJdbcExtractor will also work =
=3D
> with C3P0. This allows the use of C3P0's ComboPooledDataSource as =
direct =3D
> replacement of Commons DBCP's BasicDataSource.
> =3D20
> Juergen
> =3D20
>
> ________________________________
>
> Von: spr...@li... im Auftrag =
=3D
> von Bronwen Cassidy
> Gesendet: Mo 31.05.2004 22:25
> An: spr...@li...
> Betreff: Re: [Springframework-developer] re: OracleLobCreator
>
>
>
> Hi
> I have no concern as to the pool i use, i am actually
> completely ignorant and have been blindly feeling my
> way using the spring test cases, samples, docs and
> some googling, until 4 months ago i had never used
> oracle and until a week ago i did not need to do more
> than work out db agnostic sql queries :-)
>
> so please i am more than happy to use weblogic pool,
> which i am using when the app is deployed, hence the
> test time passes and deploy time failures most
> likely!! I am guessing the changes are needed in the
> nativeJdbcExtractor class in the spring.xml needs to
> point to a weblogic equivalent??
>
> --- Thomas Risberg <tho...@tr...> wrote:
> > 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=3DFCrgen_h=3DF6ller_[werk3AT]
> > ><jue...@we...> wrote: >
> > >OracleLobHandler needs to work on a native
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> >
> >spr...@li...
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> >
> >spr...@li...
> > >=3D20
> > >
> >
> >[mailto:spr...@li...]
> > >=3D20
> > >
> > >>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:
> > >>
> > >> =3D20
> > >>
> > >>>Hi I have a CLOB column in oracle and in the test
> > >>> =3D20
> > >>>
> > >>there are no
> > >> =3D20
> > >>
> > >>>problems, unfortunately deploying to weblogic I
> > >>> =3D20
> > >>>
> > >>get the exception
> > >> =3D20
> > >>
> > >>>below. We are using classes12.jar whereas
> > weblogic
> > >>> =3D20
> > >>>
> > >>uses ojdbc14.jar, I
> > >> =3D20
> > >>
> > >>>firstly replaced weblogics jars and classpath
> > >>> =3D20
> > >>>
> > >>settings to use the
> > >> =3D20
> > >>
> > >>>classes12.jar, but got the same error, so I
> > pulled
> > >>> =3D20
> > >>>
> > >>weblogic oracle jar
> > >> =3D20
> > >>
> > >>>into my test classpath to test if the problem was
> > >>> =3D20
> > >>>
> > >>with the jars but
> > >> =3D20
> > >>
> > >>>the test worked fine ?? I am really stuck as to
> > >>> =3D20
> > >>>
> > >>whom this should go to
> > >> =3D20
> > >>
> > >>>weblogic, oracle, or . I am hoping there is an
> > >>> =3D20
> > >>>
> > >>expert there who can
> > >> =3D20
> > >>
> > >>>shed some light. Google did not have a single
> > >>> =3D20
> > >>>
> > >>match for variations of
> > >> =3D20
> > >>
> > >>>the first 2 lines!!
> > >>>
> > >>>java.lang.ClassCastException
> > >>>
> > >>>at
> > >>>
> > >>> =3D20
> > >>>
> >
> =
>oracle.jdbc.driver.OracleConnection.unwrapCompletely(OracleConnection.ja=
=3D
> va:5
> > >=3D20
> >
> =3D3D=3D3D=3D3D message truncated =3D3D=3D3D=3D3D
>
>
> =3D20
> =3D20
> =3D20
> ____________________________________________________________
> 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=3D3D3149&alloc_id=3D3D8166&op=3D3Dclick
> _______________________________________________
> 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
>
-------------------------------------------------------
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_id149&alloc_id=8166&op=3Dick
_______________________________________________
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_id=8166&op=3Dick
_______________________________________________
Springframework-developer mailing list
Spr...@li...
https://lists.sourceforge.net/lists/listinfo/springframework-developer
|
|
From: Bronwen C. <bro...@ya...> - 2004-05-31 23:51:30
|
Hi I found this, Does this mean anything to you?? The link is here:=20 http://e-docs.bea.com/wls/docs81/jdbc/thirdparty.html#1045809 WebLogic Server provides its own interfaces to access the extension = methods for those classes (CLOBS and BLOBS) In this try catch block, you get the BLOB locator and access the Oracle = BLOB extension.=20 try {=20 // get our BLOB locator..=20 myStatement =3D myConnect.createStatement(); rs =3D myStatement.executeQuery(selectBlob); while (rs.next()) { myRegularBlob =3D rs.getBlob("blobCol");=20 } // Access the underlying Oracle extension functionality for // writing. Cast to the OracleThinBlob interface to access // the = Oracle method. os =3D ((OracleThinBlob)myRegularBlob).getBinaryOutputStream(); = ... } catch (SQLException sqe) { = System.out.println("ERROR(general SQE): " + sqe.getMessage()); } Once you cast to the Oracle.ThinBlob interface, you can access the BEA supported methods -----Original Message----- From: spr...@li... [mailto:spr...@li...] On Behalf = Of Bronwen Cassidy Sent: 31 May 2004 23:20 To: spr...@li... Subject: RE: [Springframework-developer] re: OracleLobCreator Hi, If I understand your question, OracleLobHandler works in a test case = without weblogics pool, only using the oracle.jdbc.pool.OracleDataSource = datasource bean defined as: <bean id=3D"dataSource" class=3D"oracle.jdbc.pool.OracleDataSource"> <property name=3D"driverType"><value>oracle.jdbc.OracleDriver</value></property> <property name=3D"URL"><value>jdbc:oracle:thin:@localhost:1521:ROBIN</value></prope= rty> <property name=3D"user"><value>talentstudio</value></property> <property name=3D"password"><value>talentstudio</value></property> </bean> In deployment I have set up a weblogic pool using oracle thin driver, = not a weblogic oracle driver.=20 So from what I can determine weblogic pool + oracle driver + oracleLobHandler throws the exception and Oracle jdbc pool + oracleLobHandler (as in test case) works. The printouts: template.getDataSource().getConnection()=3D weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_OracleConnection@= 112 connection.getMetaData().getConnection() =3D weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_OracleConnection@= 112 -----Original Message----- From: spr...@li... [mailto:spr...@li...] On Behalf = Of j=FCrgen h=F6ller [werk3AT] Sent: 31 May 2004 22:52 To: spr...@li... Subject: Re: [Springframework-developer] re: OracleLobCreator Can you check what kind of wrappers the DataSource returns? Simply fetch = the DataSource, invoke getConnection() and see what kind of handle it = returns (System.out.println). Furthermore, invoke getConnection().getMetaData().getConnection() and see whether this is = the native Connection (System.out.println again).=20 =20 However, if you have properly specified SimpleNativeJdbcExtractor for OracleLobHandler's "nativeJdbcExtractor" property and still get that exception, then I assume that Weblogic's own Oracle JDBC driver doesn't = use the OracleConnection class at all. This would mean that OracleLobHandler cannot be used with it. =20 Do I understand correctly that OracleLobHandler plus SimpleNativeJdbcExtractor work properly with Oracle's original JDBC = driver plus Weblogic's connection pool? =20 Juergen =20 ________________________________ Von: spr...@li... im Auftrag = von Bronwen Cassidy Gesendet: Di 01.06.2004 00:24 An: spr...@li... Betreff: RE: [Springframework-developer] re: OracleLobCreator Hi, OK the results when changing the driver for the pool from = jdbc:oracle:thin to: jdbc:weblogic:oracle using SimpleNativeJdbcExtractor Error: org.springframework.dao.DataAccessResourceFailureException: Could not = create Oracle LOB; nested exception is org.springframework.dao.In validDataAccessApiUsageException: OracleLobHandler needs to work on oracle.jdbc.OracleConnection - specify a proper NativeJdbcExtractor org.springframework.dao.InvalidDataAccessApiUsageException: = OracleLobHandler needs to work on oracle.jdbc.OracleConnection - specify a proper NativeJdbcExtractor at org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.ge= tOr acleConnection(OracleLobHandler.java:366) at org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.cr= eat eLob(OracleLobHandler.java:336) at org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.se= tCl obAsString(OracleLobHandler.java:264) at com.zynap.talentstudio.dao.jdbc.oracle.datamanipulation.PortfolioDataMani= pul ation$1.setValues(PortfolioDataManipulation.java :50) at org.springframework.jdbc.core.support.AbstractLobCreatingPreparedStatemen= tCa llback.doInPreparedStatement(AbstractLobCreating PreparedStatementCallback.java:71) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:292)= at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:308)= -----Original Message----- From: spr...@li... [mailto:spr...@li...] On Behalf = Of tho...@tr... Sent: 31 May 2004 21:47 To: spr...@li... Subject: Re: [Springframework-developer] re: OracleLobCreator I was finally able to reproduce the error in my own environment using = Spring 1.0.1. I will try 1.0.2 (current CVS) and see what happens. Thomas Here is my stack trace: org.springframework.dao.DataAccessResourceFailureException: Could not = create Oracle LOB; nested exception is java.lang.ClassCastException: null 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) at org.buggybean.web.TestServlet.doGet(TestServlet.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(Ser= vle tStubImpl.java:971) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.j= ava :402) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.j= ava :305) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.ru= n(W ebAppServletContext.java:6350) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSub= jec t.java:317) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)= at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServle= tCo ntext.java:3635) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.j= ava :2585) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170) Quoting "j=FCrgen h=F6ller [werk3AT]" <jue...@we...>: > Changing the pool should just affect the NativeJdbcExtractor choice, = =3D > i.e. a different bean wired to OracleLobHandler's = "nativeJdbcExtractor" =3D > property. > =3D20 > Give SimpleNativeJdbcExtractor a try with a Weblogic pool; there's a = =3D > good chance that it will work, avoiding the need for a specific = Weblogic =3D > implementation of the NativeJdbcExtractor interface. > =3D20 > As of Spring 1.0.2, SimpleNativeJdbcExtractor will even work with =3D > Commons DBCP too, avoiding the need for a different = NativeJdbcExtractor =3D > configuration when switching between Commons DBCP and another pool. > =3D20 > Side note: The new version of SimpleNativeJdbcExtractor will also work = =3D > with C3P0. This allows the use of C3P0's ComboPooledDataSource as = direct =3D > replacement of Commons DBCP's BasicDataSource. > =3D20 > Juergen > =3D20 > > ________________________________ > > Von: spr...@li... im Auftrag = =3D > von Bronwen Cassidy > Gesendet: Mo 31.05.2004 22:25 > An: spr...@li... > Betreff: Re: [Springframework-developer] re: OracleLobCreator > > > > Hi > I have no concern as to the pool i use, i am actually > completely ignorant and have been blindly feeling my > way using the spring test cases, samples, docs and > some googling, until 4 months ago i had never used > oracle and until a week ago i did not need to do more > than work out db agnostic sql queries :-) > > so please i am more than happy to use weblogic pool, > which i am using when the app is deployed, hence the > test time passes and deploy time failures most > likely!! I am guessing the changes are needed in the > nativeJdbcExtractor class in the spring.xml needs to > point to a weblogic equivalent?? > > --- Thomas Risberg <tho...@tr...> wrote: > > 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=3DFCrgen_h=3DF6ller_[werk3AT] > > ><jue...@we...> wrote: > > > >OracleLobHandler needs to work on a native > > >=3D20 > > > > > >>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: > > >> > > >> =3D20 > > >> > > > >spr...@li... > > >=3D20 > > > > > >>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: > > >> > > >> =3D20 > > >> > > > >spr...@li... > > >=3D20 > > > > > > >[mailto:spr...@li...] > > >=3D20 > > > > > >>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: > > >> > > >> =3D20 > > >> > > >>>Hi I have a CLOB column in oracle and in the test > > >>> =3D20 > > >>> > > >>there are no > > >> =3D20 > > >> > > >>>problems, unfortunately deploying to weblogic I > > >>> =3D20 > > >>> > > >>get the exception > > >> =3D20 > > >> > > >>>below. We are using classes12.jar whereas > > weblogic > > >>> =3D20 > > >>> > > >>uses ojdbc14.jar, I > > >> =3D20 > > >> > > >>>firstly replaced weblogics jars and classpath > > >>> =3D20 > > >>> > > >>settings to use the > > >> =3D20 > > >> > > >>>classes12.jar, but got the same error, so I > > pulled > > >>> =3D20 > > >>> > > >>weblogic oracle jar > > >> =3D20 > > >> > > >>>into my test classpath to test if the problem was > > >>> =3D20 > > >>> > > >>with the jars but > > >> =3D20 > > >> > > >>>the test worked fine ?? I am really stuck as to > > >>> =3D20 > > >>> > > >>whom this should go to > > >> =3D20 > > >> > > >>>weblogic, oracle, or . I am hoping there is an > > >>> =3D20 > > >>> > > >>expert there who can > > >> =3D20 > > >> > > >>>shed some light. Google did not have a single > > >>> =3D20 > > >>> > > >>match for variations of > > >> =3D20 > > >> > > >>>the first 2 lines!! > > >>> > > >>>java.lang.ClassCastException > > >>> > > >>>at > > >>> > > >>> =3D20 > > >>> > > > = >oracle.jdbc.driver.OracleConnection.unwrapCompletely(OracleConnection.ja= =3D > va:5 > > >=3D20 > > > =3D3D=3D3D=3D3D message truncated =3D3D=3D3D=3D3D > > > =3D20 > =3D20 > =3D20 > ____________________________________________________________ > 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=3D3D3149&alloc_id=3D3D8166&op=3D3Dclick > _______________________________________________ > 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 > ------------------------------------------------------- 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_id149&alloc_id=8166&op=3Dick _______________________________________________ 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_id=8166&op=3Dick _______________________________________________ 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_id=8166&op=3Dick _______________________________________________ Springframework-developer mailing list Spr...@li... https://lists.sourceforge.net/lists/listinfo/springframework-developer |
|
From: <tho...@tr...> - 2004-05-31 19:35:33
|
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=
> 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
>
>
>
>
> -------------------------------------------------------
> 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
>
|
|
From: <bro...@ya...> - 2004-05-31 20:03:03
|
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
|
|
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 |
|
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 > > > > > |
|
From: <bro...@ya...> - 2004-05-31 20:25:56
|
Hi I have no concern as to the pool i use, i am actually completely ignorant and have been blindly feeling my way using the spring test cases, samples, docs and some googling, until 4 months ago i had never used oracle and until a week ago i did not need to do more than work out db agnostic sql queries :-) so please i am more than happy to use weblogic pool, which i am using when the app is deployed, hence the test time passes and deploy time failures most likely!! I am guessing the changes are needed in the nativeJdbcExtractor class in the spring.xml needs to point to a weblogic equivalent?? --- Thomas Risberg <tho...@tr...> wrote: > 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 > > > === message truncated === ____________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html |
