Re: [Springframework-developer] Ready for 1.0 RC1

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

I tried ojdbc14.jar around August, and this was the version which had=20
files inside it dated 2002-6-11 for the most part, with some dated=20
2003-2-19(. It mostly worked, but broke some part of our app;=20
unfortunately I don't remember exactly what the problem was. However, if=20
I remember, ojdbc14 is even listed on the Oracle site as being only for=20
9i+...

I've only tried imagedb with the 8i classes12 driver, which broke in the=20
fashion described in this thread. It may even work with 8i with the=20
ojdbc14 driver, but unfortuantely that doesn't mean other apps will=20
necessarilly work ok.

I must say, for a bilion dollar company, Oracle has totally f*cked up=20
the implementation, bundling, and documentation of their JDBC drivers.=20
Quite inexcusable...


tri...@tr... wrote:

>Have you tried using ojdbc14.jar - I don't recall having any problems ac=
cessing
>an 8i database with the latest version.  I'm not at work today, but I co=
uld try
>it tomorrow on both 8i and 9i with various jdbc drivers.  Are you runnin=
g the
>imagedb sample app?
>
>Thomas
>
>
>Quoting Colin Sampaleanu <col...@ex...>:
>
> =20
>
>>No, I have personal experience that using the 9i classes12 against an 8=
i=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 lobhandle=
r=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:
>>
>>   =20
>>
>>>Colin,
>>>
>>>The answer is in OracleLobHandler's javadoc, end of first paragraph:
>>>     =20
>>>
>>"Developed and tested on Oracle 9i." ;-)=20
>>   =20
>>
>>>The Oracle 8i drivers did not have the current proprietary BLOB/CLOB A=
PI.
>>>     =20
>>>
>>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 d=
on't
>>see a chance to explicitly support Oracle 8i here, as we need the LOB A=
PI.
>>   =20
>>
>>>Juergen
>>>
>>>
>>>-----Original Message-----
>>>From: spr...@li...
>>>[mailto:spr...@li...]On Behal=
f
>>>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 g=
et=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
>>>     =20
>>>
>>org.springframework.jdbc.support.lob.OracleLobHandler.<init>(OracleLobH=
andler.java:101)
>>   =20
>>
>>>   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>>>     =20
>>>
>>Method)
>>   =20
>>
>>>   at=20
>>>     =20
>>>
>>sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructor=
AccessorImpl.java:39)
>>   =20
>>
>>>   at=20
>>>     =20
>>>
>>sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCon=
structorAccessorImpl.java:27)
>>   =20
>>
>>>   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:=
150)
>>>   at=20
>>>     =20
>>>
>>org.springframework.beans.factory.support.AbstractBeanFactory.createBea=
n(AbstractBeanFactory.java:570)
>>   =20
>>
>>>   at=20
>>>     =20
>>>
>>org.springframework.beans.factory.support.AbstractBeanFactory.getBean(A=
bstractBeanFactory.java:184)
>>   =20
>>
>>>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
>>>
>>>     =20
>>>
>>>>I'm gonna commit some minor code polishing within the next couple of =
hours;
>>>>       =20
>>>>
>>I'm gonna re-test everything I have this afternoon. I'll also update ou=
r CVS
>>libs to Hibernate 2.1.2 and iBATIS Database Layer 1.3.1 (unfortunately,=
 CGLIB
>>2.0 is still at RC2).
>>   =20
>>
>>>>Colin, Darren, It would be great if you could give the most current C=
VS
>>>>       =20
>>>>
>>head another go then. I'm gonna do the release tomorrow morning (my tim=
e,
>>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 (particularly t=
he new
>>"imagedb").
>>   =20
>>
>>>>I'm inclined to include neither a PlatformTransactionManagerUtils nor=
 a
>>>>       =20
>>>>
>>CurrentTransactionStatus class in this release, if we haven't settled o=
n how
>>we want to proceed there. For the time being, the 4-line code snippet I
>>posted for a setCurrentTransactionRollbackOnly method works nicely when=
 coded
>>by hand.
>>   =20
>>
>>>>BTW, could someone please generate a current reference doc PDF into t=
he
>>>>       =20
>>>>
>>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...
>>   =20
>>
>>>>Juergen
>>>>
>>>>
>>>>________________________________
>>>>
>>>>Von: spr...@li... im Auftrag=
 von
>>>>       =20
>>>>
>>Colin Sampaleanu
>>   =20
>>
>>>>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 ma=
in
>>>>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] wro=
te:
>>>>>
>>>>>
>>>>>
>>>>> =20
>>>>>
>>>>>    =20
>>>>>
>>>>>         =20
>>>>>
>>>>>>I'd like to encourage everybody to test the current CVS head thorou=
ghly.
>>>>>>I will test our sample apps myself too, against HSQLDB and MySQL, b=
ut
>>>>>>           =20
>>>>>>
>>I'm
>>   =20
>>
>>>>>>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 =
with
>>>>>hibernate.  Both seem fine through normal usage.
>>>>>
>>>>>Using the autobuilds' modified jpetstore app, I tested on resin2, re=
sin3,
>>>>>tomcat4, tomcat5, jboss3/tomcat (all using hsqldb) with no problems.=
=20
>>>>>         =20
>>>>>
>>Jetty
>>   =20
>>
>>>>>4.2.17 standalone failed as usual due to not reading the tld's in th=
e 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 ta=
ken
>>>>>         =20
>>>>>
>>by
>>   =20
>>
>>>>>each app server for the 'testPurchase' test case over 5 runs each on=
 my
>>>>>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 =
the
>>>>>order, logging in incorrectly, logging in correctly, changing user
>>>>>registration details, completing the purchase and checking the datab=
ase
>>>>>tables for sane numbers)
>>>>> =20
>>>>>    =20
>>>>>
>>>>>         =20
>>>>>
>>
>>-------------------------------------------------------
>>The SF.Net email is sponsored by EclipseCon 2004
>>Premiere Conference on Open Tools Development and Integration
>>See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
>>http://www.eclipsecon.org/osdn
>>_______________________________________________
>>Springframework-developer mailing list
>>Spr...@li...
>>https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>
>>   =20
>>
>
>
>
> =20
>