Return-Path: Mailing-List: contact ojb-dev-help@jakarta.apache.org; run by ezmlm Delivered-To: mailing list ojb-dev@jakarta.apache.org Received: (qmail 22206 invoked by uid 98); 20 Dec 2002 06:31:54 -0000 X-Antivirus: nagoya (v4218 created Aug 14 2002) Received: (qmail 22187 invoked from network); 20 Dec 2002 06:31:52 -0000 Received: from daedalus.apache.org (HELO apache.org) (63.251.56.142) by nagoya.betaversion.org with SMTP; 20 Dec 2002 06:31:52 -0000 Received: (qmail 54807 invoked by uid 500); 20 Dec 2002 06:30:30 -0000 Received: (qmail 54797 invoked from network); 20 Dec 2002 06:30:30 -0000 Received: from mail.du.gtn.com (194.77.9.57) by daedalus.apache.org with SMTP; 20 Dec 2002 06:30:30 -0000 Received: from apache.org (line003.essen.home.ins.de [195.162.231.131] (may be forged)) by mail.du.gtn.com (8.11.0.Beta3/8.11.0.Beta3) with ESMTP id gBK6UdR12942 for ; Fri, 20 Dec 2002 07:30:39 +0100 (MET) Message-ID: <3E02B922.3010106@apache.org> Date: Fri, 20 Dec 2002 07:30:58 +0100 From: Thomas Mahler User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020903 X-Accept-Language: en-us, en MIME-Version: 1.0 To: OJB Developers List Subject: Re: Scrollable Result Sets and Oracle JDBC Performance References: <008101c2a788$2b239be0$d000a8c0@Tucana> X-Enigmail-Version: 0.63.3.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Hi Matt, Matt Mastrangelo wrote: > OJB's hard coded use of scrollable result sets causes a performance > issue with Oracle's JDBC drivers. > > Are there any plans to implement such a feature, which would allow > the explicit specification of the result set type? No there are no such plans. At least from my side. Of course all code contributions are welcome. > This would seem > to be crucial to OJB's compatibility with Oracle. I don't agree that it is a crucial issue. You can set the jdbc-level flag at runtime. SO you can already use scrollable and non-scrollable resultsets within the same OJB application. Maybe the solution is not elegant. But it works. And it is for free! cheers, Thomas > Thanks, > > Matt >