From torque-user-return-6618-apmail-db-torque-user-archive=db.apache.org@db.apache.org Tue Dec 06 19:18:10 2005 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 35912 invoked from network); 6 Dec 2005 19:18:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 6 Dec 2005 19:18:10 -0000 Received: (qmail 2067 invoked by uid 500); 6 Dec 2005 19:18:08 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 2054 invoked by uid 500); 6 Dec 2005 19:18:08 -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 2036 invoked by uid 99); 6 Dec 2005 19:18:07 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Dec 2005 11:18:07 -0800 X-ASF-Spam-Status: No, hits=4.1 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,RCVD_IN_WHOIS_INVALID,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of Paul.Husek@pfizer.com designates 148.168.34.153 as permitted sender) Received: from [148.168.34.153] (HELO gromsgom01i.pfizer.com) (148.168.34.153) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Dec 2005 11:18:06 -0800 Received: from groamrexc02.amer.pfizer.com (groamrexc02.amer.pfizer.com [172.30.8.169]) by gromsgom01i.pfizer.com (8.13.4/8.13.4) with ESMTP id jB6JH0eN002675 for ; Tue, 6 Dec 2005 14:17:00 -0500 Received: from mopamrexc02.amer.pfizer.com ([170.116.30.68]) by groamrexc02.amer.pfizer.com with Microsoft SMTPSVC(6.0.3790.211); Tue, 6 Dec 2005 14:17:44 -0500 Received: from mopamrexm25.amer.pfizer.com ([170.116.6.57]) by mopamrexc02.amer.pfizer.com with Microsoft SMTPSVC(6.0.3790.211); Tue, 6 Dec 2005 14:17:44 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: RE: as400 ordering problem Date: Tue, 6 Dec 2005 14:17:40 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: as400 ordering problem Thread-Index: AcX6RvfG49TzqUmVRsmUkAZw1v9sFAAUlurg From: "Husek, Paul" To: "Apache Torque Users List" X-OriginalArrivalTime: 06 Dec 2005 19:17:44.0101 (UTC) FILETIME=[BC006550:01C5FA99] X-Proofpoint-Spam-Reason: safe X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Thomas, Thanks tons for the quick response. Your recommendation for a fix worked! As time permits I'll see if I can determine why it was failing and contribute to the project through a patch. Paul -----Original Message----- From: Thomas Fischer [mailto:fischer@seitenbau.net]=20 Sent: Tuesday, December 06, 2005 4:24 AM To: Apache Torque Users List Subject: RE: as400 ordering problem Hi, What you can do is to override the method ignoreCaseInOrderBy(String) in your DB adapter (most probably DBDB2400.java). If you do not know why it does not work you can just return the argument. Note that if you do this, all orderBy's will be case sensitive. Alternatively, you can try to fix its behaviour. I am afraid there is no way to turn case insensitive ordering off in a criteria. Look at SQLBuilder.processOrderBy() to see yourself. If you found out what the problem is and how to fix it, can you please open up an issue in scarab on the problem ? Thomas "Husek, Paul" schrieb am 06.12.2005 00:21:14: > I'm using torque with the as400 driver. Most the time it works great. > Lately though I've notice when I do a > > > > addAscendingOrderBy() to a criteria I get a sql error: > > > > [SQL0171] Argument 1 of function UCASE not valid > > > > I'm looking for a quick workaround for this. I'm not sure I can wait > for a torque patch Can I add a custom order by where it won't cause > this ucase function to be called? > > > > Thanks! > > > > Paul > > > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org