Return-Path: <prescott@prescottbalch.org>
Mailing-List: contact turbine-torque-user-help@jakarta.apache.org;
 run by ezmlm
Delivered-To: mailing list turbine-torque-user@jakarta.apache.org
Received: (qmail 7450 invoked by uid 98); 18 Dec 2002 01:54:46 -0000
X-Antivirus: nagoya (v4218 created Aug 14 2002)
Received: (qmail 7431 invoked from network); 18 Dec 2002 01:54:44 -0000
Received: from daedalus.apache.org (HELO apache.org) (63.251.56.142)
  by nagoya.betaversion.org with SMTP; 18 Dec 2002 01:54:44 -0000
Received: (qmail 73351 invoked by uid 500); 18 Dec 2002 01:53:25 -0000
Received: (qmail 73344 invoked from network); 18 Dec 2002 01:53:24 -0000
Received: from dsl-64-131-210-17.telocity.com (HELO www.prescottbalch.org)
 (64.131.210.17)
  by daedalus.apache.org with SMTP; 18 Dec 2002 01:53:24 -0000
Received: (qmail 17693 invoked from network); 18 Dec 2002 01:53:32 -0000
Received: from unknown (HELO localhost) (127.0.0.1)
  by localhost with SMTP; 18 Dec 2002 01:53:32 -0000
Date: Tue, 17 Dec 2002 19:53:32 -0600 (CST)
Message-Id: <20021217.195332.78725276.prescott@prescottbalch.org>
To: turbine-torque-user@jakarta.apache.org, eric@ericemminger.com
Subject: Re: addAscendingOrderBy problem
From: Prescott R. Balch <prescott@prescottbalch.org>
In-Reply-To: <1040172192.6179.428.camel@linux>
References: <1040080140.6180.387.camel@linux>
	<20021216.173016.68049313.prescott@prescottbalch.org>
	<1040172192.6179.428.camel@linux>
X-Mailer: Mew version 2.1 on Emacs 20.7 / Mule 4.0 (HANANOEN)
Mime-Version: 1.0
Content-Type: Text/Plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N


Thanks for your help.  I'm stumped too.  I'm going to start over with
a fresh install, fresh tables, fresh everything, and see if I can get
it to work.  

> Prescott
> 
> I'm not exactly sure what to tell you. I tried your schema with Torque
> 3.0 (the production release) inside a Turbine app. It worked and no
> exceptions were thrown.
> 
> Here's the code I used.
> 
> ----- Java code -----
>         List list = null;
>         Criteria crit = new Criteria();
>         crit.add(RuntypePeer.RUNNERID, 2);
>         crit.addAscendingOrderByColumn(RuntypePeer.RUNTYPE);
>         crit.addAscendingOrderByColumn(RuntypePeer.RUNTYPEID);
>         Log.debug("order by columns: " +
> crit.getOrderByColumns().toString());
>         Log.debug("order by size: " + crit.getOrderByColumns().size());
>         Log.debug("crit: " + crit.toString());
>         try
>         {
>             list = RuntypePeer.doSelect(crit);
>         }
>         catch (TorqueException te)
>         {
>             list = null;
>             Log.error("Could not select runtypes: " + te.toString());
>             te.printStackTrace();
>         }
> ----- Java code -----
> 
> Could Torque be configured incorrectly in your app? I've only used
> Torque within Turbine, so I'm not familiar with all the settings. If
> you're sure the setup is correct, then it may relate to your specific
> setup. In that case, file a bug in Scarab. The Torque developers will be
> more helpful than I.
> 
> > No problem.  Here's the schema.  I'm a pretty serious runner and I've
> > written a Java app that manages all my training data.  I started it
> > long ago with InstantDB but the thing fell apart with a bit of data in
> > it.  I switched to using Torque and MySQL and all was going well until
> > the 3.0 release and this problem.
> 
> I'm curious. How often and how far do you run?
> 
> Eric
> 
> -- 
> Eric Emminger
> eric@ericemminger.com
> 
> 
> --
> To unsubscribe, e-mail:   <mailto:turbine-torque-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <mailto:turbine-torque-user-help@jakarta.apache.org>
>