Re: [Springframework-developer] Ready for 1.0 RC1

[Colin S. <col...@ex...>]

No, I have personal experience that using the 9i classes12 against an 8i=20
database has weird (bad) results.

As I mentioned in a subsequent message, I do have working code for the=20
8i driver (figured out at great pain :-) ), and can produce a lobhandler=20
for that. Given the fact that database migration is such a pain, a lot=20
of people are still using 8i, so it's probably worth it for me to do it.

Colin


j=FCrgen h=F6ller [werk3AT] wrote:

>Colin,
>
>The answer is in OracleLobHandler's javadoc, end of first paragraph: "De=
veloped and tested on Oracle 9i." ;-)=20
>
>The Oracle 8i drivers did not have the current proprietary BLOB/CLOB API=
. Nevertheless, I've heard that someone has used the Oracle 9i drivers ag=
ainst an 8i database with OracleLobHandler, and it did work. In any case,=
 I don't see a chance to explicitly support Oracle 8i here, as we need th=
e LOB API.
>
>Juergen
>
>
>-----Original Message-----
>From: spr...@li...
>[mailto:spr...@li...]On Behalf
>Of Colin Sampaleanu
>Sent: Monday, February 09, 2004 5:07 PM
>To: spr...@li...
>Subject: Re: [Springframework-developer] Ready for 1.0 RC1
>
>
>Juergen,
>
>What Oracle JDBC driver version did you develop Oracle LobHandler with?
>
>I am using it with the last version of the JDK 1.2/1.3 'classes12'=20
>zip/jar from Oracle, which works with Oracle 8. With that version, I get=
=20
>the following exception:
>
>2004-02-09 10:56:09,655 ERROR [org.jboss.web.localhost.Engine] -----=20
>Root Cause -----
>java.lang.NoSuchFieldException: DURATION_SESSION
>    at java.lang.Class.getField(Class.java:911)
>    at=20
>org.springframework.jdbc.support.lob.OracleLobHandler.<init>(OracleLobHa=
ndler.java:101)
>    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Met=
hod)
>    at=20
>sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA=
ccessorImpl.java:39)
>    at=20
>sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons=
tructorAccessorImpl.java:27)
>    at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
>    at java.lang.Class.newInstance0(Class.java:308)
>    at java.lang.Class.newInstance(Class.java:261)
>    at=20
>org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:31)
>    at=20
>org.springframework.beans.BeanWrapperImpl.<init>(BeanWrapperImpl.java:15=
0)
>    at=20
>org.springframework.beans.factory.support.AbstractBeanFactory.createBean=
(AbstractBeanFactory.java:570)
>    at=20
>org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Ab=
stractBeanFactory.java:184)
>
>Note that there is a later 'classes12' zip/jar targetted at Oracle 9,=20
>which will not work with Oracle 8.
>
>There is also a JDK 1.4 'ojdbc14.jar' which is good with Oracle 9 only.
>
>Regards,
>Colin
>
>
>
>j=FCrgen h=F6ller [werk3AT] wrote:
>
> =20
>
>>I'm gonna commit some minor code polishing within the next couple of ho=
urs; I'm gonna re-test everything I have this afternoon. I'll also update=
 our CVS libs to Hibernate 2.1.2 and iBATIS Database Layer 1.3.1 (unfortu=
nately, CGLIB 2.0 is still at RC2).
>>
>>Colin, Darren, It would be great if you could give the most current CVS=
 head another go then. I'm gonna do the release tomorrow morning (my time=
, that is in less than 24 hours). Please report any urgent issues promptl=
y. I'd also be happy if you give some of the sample apps a try (particula=
rly the new "imagedb").
>>
>>I'm inclined to include neither a PlatformTransactionManagerUtils nor a=
 CurrentTransactionStatus class in this release, if we haven't settled on=
 how we want to proceed there. For the time being, the 4-line code snippe=
t I posted for a setCurrentTransactionRollbackOnly method works nicely wh=
en coded by hand.
>>
>>BTW, could someone please generate a current reference doc PDF into the=
 docs directory in CVS? The current version there is from November, and I=
 still haven't set up the required libraries on my machine here...
>>
>>Juergen
>>
>>
>>________________________________
>>
>>Von: spr...@li... im Auftrag v=
on Colin Sampaleanu
>>Gesendet: Mo 09.02.2004 01:15
>>An: spr...@li...
>>Betreff: Re: [Springframework-developer] Ready for 1.0 RC1
>>
>>
>>
>>I've been in a big crunch mode here, including working most of the
>>weekend, so have not tested Spring functionality not related to my main
>>app. However, for my main app, the new code from Wed/Thurs has been
>>running with no problems (this includes multi-context use, AOP for
>>transaction and Hibernate session wrapping, Hibernate OR support code,
>>and small amounts of JDBC code, against Oracle).
>>
>>Some time later tonight I'll pull down any changes, and give that ago,
>>also adding in the new Hibernate 2.12...
>>
>>
>>Darren Davison wrote:
>>
>>=20
>>
>>   =20
>>
>>>-----BEGIN PGP SIGNED MESSAGE-----
>>>Hash: SHA1
>>>
>>>On Wednesday 04 February 2004 19:11, j=FCrgen h=F6ller [werk3AT] wrote=
:
>>>
>>>
>>>
>>>  =20
>>>
>>>     =20
>>>
>>>>I'd like to encourage everybody to test the current CVS head thorough=
ly.
>>>>I will test our sample apps myself too, against HSQLDB and MySQL, but=
 I'm
>>>>primarily talking of custom applications here. Please report any
>>>>remaining issues promptly; I intend to release RC1 this weekend.
>>>>=20
>>>>
>>>>    =20
>>>>
>>>>       =20
>>>>
>>>I've run a couple of apps this weekend without any issues on tomcat5 -
>>>they're lightweight web apps, one with JDBC access to MySQL and one wi=
th
>>>hibernate.  Both seem fine through normal usage.
>>>
>>>Using the autobuilds' modified jpetstore app, I tested on resin2, resi=
n3,
>>>tomcat4, tomcat5, jboss3/tomcat (all using hsqldb) with no problems.  =
Jetty
>>>4.2.17 standalone failed as usual due to not reading the tld's in the =
jar
>>>files.
>>>
>>>Just for the hell of it, I ran all of the above tests on Sun JDK 1.4.1=
,
>>>Blackdown JDK 1.3.1 and Blackdown JDK 1.4.1.
>>>
>>>Fairly meaningless, but interesting nonetheless, the average time take=
n by
>>>each app server for the 'testPurchase' test case over 5 runs each on m=
y
>>>machine (with the Sun JDK) is below.
>>>
>>>resin2: 10s
>>>resin3: 30s
>>>tomcat4: 25s
>>>tomcat5: 12s
>>>jboss3/tomcat: 36s (gotta love those JBoss guys)
>>>
>>>(testPurchase involves browsing the items, adding to cart, changing th=
e
>>>order, logging in incorrectly, logging in correctly, changing user
>>>registration details, completing the purchase and checking the databas=
e
>>>tables for sane numbers)
>>>  =20
>>>     =20
>>>