Hello Ron, I've just modified our repository.xml file in order to specify OJB we're using a 2.0 driver (surprising that it wouldn't be configured this way), and I tried using setStartAtIndex. It does work, but performance is terrible : instead of taking 9 seconds to perform, the test now takes 40 seconds, only to retrieve the same 30 rows. Any ideas what could be causing such trouble ? I'm not getting any significant output from OJB. Thanks. Patrick.
-----Message d'origine----- De : Ron Gallagher [mailto:[EMAIL PROTECTED] Envoy� : mardi 25 mars 2003 14:32 � : [EMAIL PROTECTED] Objet : Re: Using setStartAtIndex with Oracle 8i Patrick -- You can use it with oracle 8i. Just set the jdbc level in the connection descriptor you're using to 2.0 or greater. Ron Gallagher Atlanta, GA [EMAIL PROTECTED] > > From: Patrick Prodhon <[EMAIL PROTECTED]> > Date: 2003/03/25 Tue AM 08:11:05 EST > To: [EMAIL PROTECTED] > Subject: Using setStartAtIndex with Oracle 8i > > Hello OJB world, > > We are currently facing some performance problems on our project, and we'd > like to be able to use setStartAtIndex and setEndAtIndex with Oracle 8i. > Yet, it seems that when we try and use it, it won't work. I get these > "[org.apache.ojb.broker.accesslayer.SqlBasedRsIterator] INFO: Your driver > does not support advanced JDBC Functionality, you cannot call size()" > messages, which don't sound friendly at all : does this mean I can't use > this functionnality with Oracle 8i ? Has anyone been able to use it ? If so, > how ? > We're using Oracle's driver (classes12.jar). > > Thanks. > Patrick. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
