|
From: <jue...@we...> - 2004-02-09 17:09:51
|
I take your word for it - as I said in another mail, I haven't seen the = 9i driver work on an 8i database myself, and frankly, I have no trust in = the general viability of such a combo. So it'd be great if you can come = up with an 8i-capable OracleLobHandler! (possibly in the Spring 1.1 = timeframe) Maybe we can simply auto-detect the Oracle driver version through = introspection in a single unified OracleLobHandler implementation. = AFAIK, the difference is that the 8i driver didn't have the notion of = temporary LOBs; the Oracle BLOB and CLOB implementation classes = themselves should be compatible. So there's a chance for some code = reuse. Juergen -----Original Message----- From: spr...@li... [mailto:spr...@li...]On Behalf Of Colin Sampaleanu Sent: Monday, February 09, 2004 5:53 PM To: spr...@li... Subject: Re: [Springframework-developer] Ready for 1.0 RC1 No, I have personal experience that using the 9i classes12 against an 8i = 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 = 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: = "Developed 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 against 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 the 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 = Method) > 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 = hours; 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 = (unfortunately, 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 = promptly. I'd also be happy if you give some of the sample apps a try = (particularly 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 = snippet I posted for a setCurrentTransactionRollbackOnly method works = nicely when 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 = von 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 = thoroughly. >>>>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 = with >>>hibernate. Both seem fine through normal usage. >>> >>>Using the autobuilds' modified jpetstore app, I tested on resin2, = resin3, >>>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 = taken by >>>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 = database >>>tables for sane numbers) >>> =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 |