|
From: <tri...@tr...> - 2004-02-09 20:32:25
|
Have you tried using ojdbc14.jar - I don't recall having any problems accessing an 8i database with the latest version. I'm not at work today, but I could try it tomorrow on both 8i and 9i with various jdbc drivers. Are you running the imagedb sample app? Thomas Quoting Colin Sampaleanu <col...@ex...>: > 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 > 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 > of people are still using 8i, so it's probably worth it for me to do it. > > Colin > > > jürgen höller [werk3AT] wrote: > > >Colin, > > > >The answer is in OracleLobHandler's javadoc, end of first paragraph: > "Developed and tested on Oracle 9i." ;-) > > > >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' > >zip/jar from Oracle, which works with Oracle 8. With that version, I get > >the following exception: > > > >2004-02-09 10:56:09,655 ERROR [org.jboss.web.localhost.Engine] ----- > >Root Cause ----- > >java.lang.NoSuchFieldException: DURATION_SESSION > > at java.lang.Class.getField(Class.java:911) > > at > >org.springframework.jdbc.support.lob.OracleLobHandler.<init>(OracleLobHandler.java:101) > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > > at > >sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > > at > >sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.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 > >org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:31) > > at > >org.springframework.beans.BeanWrapperImpl.<init>(BeanWrapperImpl.java:150) > > at > >org.springframework.beans.factory.support.AbstractBeanFactory.createBean(AbstractBeanFactory.java:570) > > at > >org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:184) > > > >Note that there is a later 'classes12' zip/jar targetted at Oracle 9, > >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ürgen höller [werk3AT] wrote: > > > > > > > >>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: > >> > >> > >> > >> > >> > >>>-----BEGIN PGP SIGNED MESSAGE----- > >>>Hash: SHA1 > >>> > >>>On Wednesday 04 February 2004 19:11, jürgen höller [werk3AT] wrote: > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>>>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. > >>>> > >>>> > >>>> > >>>> > >>>> > >>>> > >>>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) > >>> > >>> > >>> > > > > ------------------------------------------------------- > 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 > |