From torque-user-return-7999-apmail-db-torque-user-archive=db.apache.org@db.apache.org Fri Oct 03 01:18:45 2008 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 41215 invoked from network); 3 Oct 2008 01:18:45 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 3 Oct 2008 01:18:45 -0000 Received: (qmail 96154 invoked by uid 500); 3 Oct 2008 01:18:43 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 96100 invoked by uid 500); 3 Oct 2008 01:18:43 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 96089 invoked by uid 99); 3 Oct 2008 01:18:43 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Oct 2008 18:18:43 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of walkerrichardj@gmail.com designates 72.14.220.157 as permitted sender) Received: from [72.14.220.157] (HELO fg-out-1718.google.com) (72.14.220.157) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Oct 2008 01:17:42 +0000 Received: by fg-out-1718.google.com with SMTP id l27so911383fgb.43 for ; Thu, 02 Oct 2008 18:17:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=mMKWpx3FbspzaEV+Eg7jQM+GJ5pdLNwTe1RCkruq/OI=; b=eIYd6RbWotax5xd3U4BpqTq1OElxV+t4Ng0Gq2tTTUnq3wEUcc7rvwUobpI1EClSRU NBLdr5yAd19FLmtCFoG5XO5dyTok3+jY/K8iK0zIs8DIZzL74mJIKMCVDRpn/GeSQC5v YCYBQWJ/0giN95cq9B3kj0+s4qEoFQJzMxEvY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=WGfKHOIR/bE/PQY/Sp0Q96Tt/c5yMPZbUVIAsOOfhqxOj1FMcKA/H3W90gVDeMsxrt Jd6XTzn+WoxZQkJwbArgkezU7o1mb1qoxPHy8XQLm6kb5J7un/oOyJkd59Zb0L2tun7I LGbcu+X6YBMvCLZ2ngvwu5bFLWm002zNgB7tk= Received: by 10.187.175.6 with SMTP id c6mr35515fap.89.1222996678540; Thu, 02 Oct 2008 18:17:58 -0700 (PDT) Received: by 10.187.164.18 with HTTP; Thu, 2 Oct 2008 18:17:57 -0700 (PDT) Message-ID: Date: Fri, 3 Oct 2008 11:17:57 +1000 From: "Richard Walker" To: "Apache Torque Users List" Subject: Re: Will migrating from 3.0 to 3.3 help me? In-Reply-To: <48E4C54D.3040504@backstagetech.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <48E3091E.3050502@backstagetech.com.au> <48E4C54D.3040504@backstagetech.com.au> X-Virus-Checked: Checked by ClamAV on apache.org >> How about you make yourself a copy of village.jar with the offending lines >> in the Column class commented out and see if your queries still execute >> correctly. Really this would just be the opposite of having the stub >> methods in the old JDBC driver. Provided your application is not accessing >> the metadata present in the Column class (directly or indirectly) this >> should be a valid approach. I've traced the extra queries to these two lines in Column.java: this.nullAllowed = rsmd.isNullable(columnNumber) == 1; this.autoIncrement = rsmd.isAutoIncrement(columnNumber); I checked the source of the old driver; it hard-codes the results of those queries, so this.nullAllowed and this.autoIncrement are always set to false. So I made this modification: this.nullAllowed = false; // rsmd.isNullable(columnNumber) == 1; this.autoIncrement = false; // rsmd.isAutoIncrement(columnNumber); And it works! No more extra queries. Problem solved - for me, anyway. Thanks for the hints. --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org