From torquemelissalambert@example.org Fri Apr 01 08:26:33 2005 Return-Path: <torquemelissalambert@example.org> Delivered-To: melissalambert@example.org Received: (qmail 1699 invoked from network); 1 Apr 2005 08:26:33 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Apr 2005 08:26:33 -0000 Received: (qmail 34584 invoked by uid 500); 1 Apr 2005 08:19:33 -0000 Delivered-To: melissalambert@example.org Received: (qmail 34485 invoked by uid 500); 1 Apr 2005 08:19:32 -0000 Mailing-List: contact melissalambert@example.org; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:melissalambert@example.org> List-Subscribe: <mailto:melissalambert@example.org> List-Help: <mailto:melissalambert@example.org> List-Post: <mailto:melissalambert@example.org> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <melissalambert@example.org> Delivered-To: mailing list melissalambert@example.org Received: (qmail 34472 invoked by uid 99); 1 Apr 2005 08:19:32 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail.seitenbau.net (HELO mail.seitenbau.net) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 01 Apr 2005 00:19:30 -0800 Received: from [83.161.120.155] (helo=www.seitenbau.net) by router1.seitenbau.net with esmtp (Exim 4.43) id 1DHHNG-000697-C0 for melissalambert@example.org; Fri, 01 Apr 2005 10:19:26 +0200 In-Reply-To: <{{EMAIL+SOCIAL_SECURITY_NUMBER}}> Subject: RE: sql/db-init/Control.vm & ResourceNotFoundException To: "Apache Torque Users List" <melissalambert@example.org> X-Mailer: Lotus Notes Release 6.0 September 26, 2002 Message-ID: <melissalambert@example.org> From: Thomas Fischer <melissalambert@example.org> Date: Fri, 1 Apr 2005 10:19:25 +0200 X-MIMETrack: Serialize by Router on www/seitenbau(Release 6.5.1|January 21, 2004) at 01.04.2005 10:19:25 AM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Laran, which database are you using (the torque.database setting in the build.properties of the generator) ? And which Torque version are you using ? Thomas "Laran Evans" <melissalambert@example.org> schrieb am 979.866.0673:01:01: > I get this when running the create-db Ant task. > > org.apache.velocity.exception.ResourceNotFoundException: Unable to find > resource > 'sql/db-init/Control.vm' > > The torque and torque-gen .jars are in my classpath. I've tried with both > torque.useClasspath=true and torque.useClasspath=false. Both failed. > > Any suggestions? > > -- > Laran Evans - Cornell University > p: 979.866.0673 f: 979.866.0673 > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: melissalambert@example.org > For additional commands, e-mail: melissalambert@example.org > --------------------------------------------------------------------- To unsubscribe, e-mail: melissalambert@example.org For additional commands, e-mail: melissalambert@example.org From torquemelissalambert@example.org Fri Apr 01 08:36:56 2005 Return-Path: <torquemelissalambert@example.org> Delivered-To: melissalambert@example.org Received: (qmail 7080 invoked from network); 1 Apr 2005 08:36:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Apr 2005 08:36:56 -0000 Received: (qmail 55028 invoked by uid 500); 1 Apr 2005 08:36:54 -0000 Delivered-To: melissalambert@example.org Received: (qmail 55009 invoked by uid 500); 1 Apr 2005 08:36:54 -0000 Mailing-List: contact melissalambert@example.org; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:melissalambert@example.org> List-Subscribe: <mailto:melissalambert@example.org> List-Help: <mailto:melissalambert@example.org> List-Post: <mailto:melissalambert@example.org> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <melissalambert@example.org> Delivered-To: mailing list melissalambert@example.org Received: (qmail 54996 invoked by uid 99); 1 Apr 2005 08:36:54 -0000 X-ASF-Spam-Status: No, hits=0.9 required=10.0 tests=DNS_FROM_RFC_ABUSE,WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from web42003.mail.yahoo.com (HELO web42003.mail.yahoo.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with SMTP; Fri, 01 Apr 2005 00:36:52 -0800 Received: (qmail 43272 invoked by uid 60001); 1 Apr 2005 08:36:49 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=Wq2YfB6G3g+UddwA5ivA/B58xuFWQGWuZ4mLcArh0vWjpiweywIWpZstnQcD7Ad8TgtkTka2g3rToL1qkeh958NEj/EUThlMXgJ4YRE1+RpAOqc0IHdcCpnuEeU5w4M52B8sF/pGd4QsmPPuedFxYf34br4k8FJpX16OatLJiR8= ; Message-ID: <melissalambert@example.org> Received: from [83.161.120.155] by web42003.mail.yahoo.com via HTTP; Fri, 01 Apr 2005 00:36:49 PST Date: Fri, 1 Apr 2005 00:36:49 -0800 (PST) From: Robert Bowen <melissalambert@example.org> Subject: RE: Criteria.setIgnoreCase() and boolean fields? To: Apache Torque Users List <melissalambert@example.org> In-Reply-To: <melissalambert@example.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hello Thomas, sorry about the delay. In my templates/sql/base/postgresql/db.props I have: BOOLEANCHAR = char In my build.properties I have: torque.database = postgresql My Java is the following: criteria.add(ApdNotificationPeer.IS_VALID, false); And the generated SQL is this: SELECT * FROM apd_notification WHERE UPPER(apd_notification.IS_VALID)=UPPER(0) If I change the Java to: criteria.add(ApdNotificationPeer.IS_VALID, "false"); The Sql is: UPPER(apd_notification.IS_VALID)=UPPER('false') And the error is the same -- can't perform an UPPER() on a boolean field. So it seems the problem isn't with the UPPER(0) or (UPPER('false') but rather the UPPER(apd_notification.IS_VALID). I'd *love* to have a workaround ... Unfortunately I can't really just piece together a SQL statement and call the Peer.execute() because the SQL is veeeeery long. Still looking ... Bob --- Thomas Fischer <melissalambert@example.org> wrote: > > > > > Robert, > > please omit also the port number: > > http://issues.apache.org/scarab/issues/template/Confirm.vm/confirm/... > > Can you please check your db.props file in the > generator ? There it should > say > BOOLEANCHAR = char > > so the column in the database should be a char > column, and the upper() > should work. > > Are you sure you have set > > torque.database = postgresql > > in your generator properties file ? > > Thomas > > > Robert Bowen <melissalambert@example.org> schrieb am 31.03.2005 > 12:19:52: > > > Hi Thomas, > > > > I am using Postgre 8.0.1 for Windoze, Torque 3.1. > > > > In my Torque schema I use data type BOOLEANCHAR, > but > > the field in the database itself is boolean. I > don't > > think there is a 'boolchar' option, or anything > > similar in Postgre. I guess that's why it's > crashing. > > Ideally Torque would recognize that it is a > boolean > > field and not try to perform an UPPER() on it. > > > > Incidentally, I registered for an account on > scarab > > and got a message to confirm my subscription. > > Unfortunately the link sent in the confirm email > is > > wrong: > > > > > http://localhost:38080/scarab/issues/template/Confirm.vm/confirm/... > > > > localhost!? > > > > I tried putting issues.apache.org and > www.apache.org > > instead of localhost but it doesn't work. > > > > Any idea? > > > > Tanky, > > Bob > > > > > > @seitenbau.net> wrote: > > > > > > > > > > > > > > > Robert, > > > > > > Which database and Torque version are you using > ? > > > To my knowledge, booleanchar is usually > implemented > > > as a char field in the > > > database (at least for oracle and Torque 3.1.1), > so > > > upper should work > > > there. > > > > > > by the way, Scarab is the issue tracker for > torqe: > > > http://issues.apache.org/scarab/issues > > > request a role as observer for Torque->Source > and > > > then you are able to > > > create issues > > > > > > Thomas > > > > > > > > > > > > Robert Bowen <melissalambert@example.org> schrieb am > 31.03.2005 > > > 11:03:00: > > > > > > > I *am* using BOOLEANCHAR, and it still doesn't > > > work. > > > > > > > > I'll have to take a look at scarab, don't know > > > what it > > > > is! > > > > > > > > syg > > > > > > > > --- Thomas Fischer <melissalambert@example.org> > wrote: > > > > > > > > > > > > > > > > > > > > > > > > > Sounds like a bug to me. Can you please > enter > > > this > > > > > in scarab, including the > > > > > database and the torque version you use ? > > > > > > > > > > As a workaround, you can try to change your > > > > > datamodel such that you use the > > > > > data type booleanchar instead of boolean. > > > > > > > > > > Thomas > > > > > > > > > > Robert Bowen <melissalambert@example.org> schrieb am > > > 31.03.2005 > > > > > 10:02:13: > > > > > > > > > > > Hello all. I have a class that sets a > whole > > > bunch > > > > > of > > > > > > conditions for a search. Most of the > fields I > > > > > search > > > > > > on are text so using > Criteria.setIgnoreCase() > > > has > > > > > been > > > > > > working. > > > > > > > > > > > > I recently added another search criteria, > on a > > > > > boolean > > > > > > field: > > > > > > > > > > > > criteria.add(NotificationPeer.IS_COMPLETE, > > > false); > > > > > > > > > > > > But since the setIgnoreCase() is set to > true > > > for > > > > > the > > > > > > Criteria, Torque tries to do an UPPER() on > a > > > > > boolean > > > > > > field! > > > > > > > > > > > > Can I avoid this somehow? Currently it > crashes > > > in > > > > > a > > > > > > rather ugly way ... > > > > > > > > > > > > Thanks! > > > > > > syg > > > > > > > > > > > > > > > > > > > > > > > > __________________________________ > > > > > > Do you Yahoo!? > > > > > > Make Yahoo! your home page > > > > > > http://www.yahoo.com/r/hs > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > > To unsubscribe, e-mail: > > > > > melissalambert@example.org > > > > > > For additional commands, e-mail: > > > > > melissalambert@example.org > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > To unsubscribe, e-mail: > > > > > melissalambert@example.org > > > > > For additional commands, e-mail: > > > > > melissalambert@example.org > > > > > > > > > > > > > > > > > > > > > > > > > > __________________________________ > > > > Do you Yahoo!? > > > > Yahoo! Small Business - Try our new resources > > > site! > > > > http://smallbusiness.yahoo.com/resources/ > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: > > > melissalambert@example.org > > > > For additional commands, e-mail: > > > melissalambert@example.org > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: > > > melissalambert@example.org > > > For additional commands, e-mail: > > > melissalambert@example.org > > > > > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Mail - Easier than ever with enhanced > search. Learn more. > > http://info.mail.yahoo.com/mail_250 > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > melissalambert@example.org > > For additional commands, e-mail: > melissalambert@example.org > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > melissalambert@example.org > For additional commands, e-mail: > melissalambert@example.org > > __________________________________ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail --------------------------------------------------------------------- To unsubscribe, e-mail: melissalambert@example.org For additional commands, e-mail: melissalambert@example.org From torquemelissalambert@example.org Fri Apr 01 09:15:41 2005 Return-Path: <torquemelissalambert@example.org> Delivered-To: melissalambert@example.org Received: (qmail 25546 invoked from network); 1 Apr 2005 09:15:41 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Apr 2005 09:15:41 -0000 Received: (qmail 11778 invoked by uid 500); 1 Apr 2005 09:15:38 -0000 Delivered-To: melissalambert@example.org Received: (qmail 11762 invoked by uid 500); 1 Apr 2005 09:15:37 -0000 Mailing-List: contact melissalambert@example.org; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:melissalambert@example.org> List-Subscribe: <mailto:melissalambert@example.org> List-Help: <mailto:melissalambert@example.org> List-Post: <mailto:melissalambert@example.org> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <melissalambert@example.org> Delivered-To: mailing list melissalambert@example.org Received: (qmail 11740 invoked by uid 99); 1 Apr 2005 09:15:37 -0000 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail.seitenbau.net (HELO mail.seitenbau.net) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 01 Apr 2005 01:15:35 -0800 Received: from [83.161.120.155] (helo=www.seitenbau.net) by router1.seitenbau.net with esmtp (Exim 4.43) id 1DHIFU-0006Qa-Gi for melissalambert@example.org; Fri, 01 Apr 2005 11:15:28 +0200 In-Reply-To: <melissalambert@example.org> Subject: RE: Criteria.setIgnoreCase() and boolean fields? To: "Apache Torque Users List" <melissalambert@example.org> X-Mailer: Lotus Notes Release 6.0 September 26, 2002 Message-ID: <melissalambert@example.org> From: Thomas Fischer <melissalambert@example.org> Date: Fri, 1 Apr 2005 11:15:27 +0200 X-MIMETrack: Serialize by Router on www/seitenbau(Release 6.5.1|January 21, 2004) at 01.04.2005 11:15:27 AM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Robert, what I still do not understand is why upper(apd_notification.IS_VALID) does not work. I am no postgresql guru and I have no postgresql implementation available now, but I thought that one can do an upper() on a char column. can you do something like describe (Apd_Notification); (or whatever that command is in postgresql) in a postgresql console and see if the IS_VALID column is indeed a char ? If not, can you regenerate the sql to create the db and see what type the IS_VALID column in Apd_Notification is generated ? If yes, can you create a test table in postgresql with a char column and see whether upper() works on that column ? Thomas Robert Bowen <melissalambert@example.org> schrieb am 01.04.2005 10:36:49: > Hello Thomas, sorry about the delay. > > In my templates/sql/base/postgresql/db.props I have: > > BOOLEANCHAR = char > > In my build.properties I have: > > torque.database = postgresql > > My Java is the following: > > criteria.add(ApdNotificationPeer.IS_VALID, false); > > And the generated SQL is this: > > SELECT * FROM apd_notification > WHERE UPPER(apd_notification.IS_VALID)=UPPER(0) > > If I change the Java to: > > criteria.add(ApdNotificationPeer.IS_VALID, "false"); > > The Sql is: > > UPPER(apd_notification.IS_VALID)=UPPER('false') > > And the error is the same -- can't perform an UPPER() > on a boolean field. So it seems the problem isn't with > the UPPER(0) or (UPPER('false') but rather the > UPPER(apd_notification.IS_VALID). > > I'd *love* to have a workaround ... Unfortunately I > can't really just piece together a SQL statement and > call the Peer.execute() because the SQL is veeeeery > long. > > Still looking ... > Bob > > > --- Thomas Fischer <melissalambert@example.org> wrote: > > > > > > > > > > > Robert, > > > > please omit also the port number: > > > > > http://issues.apache.org/scarab/issues/template/Confirm.vm/confirm/... > > > > Can you please check your db.props file in the > > generator ? There it should > > say > > BOOLEANCHAR = char > > > > so the column in the database should be a char > > column, and the upper() > > should work. > > > > Are you sure you have set > > > > torque.database = postgresql > > > > in your generator properties file ? > > > > Thomas > > > > > > Robert Bowen <melissalambert@example.org> schrieb am 31.03.2005 > > 12:19:52: > > > > > Hi Thomas, > > > > > > I am using Postgre 8.0.1 for Windoze, Torque 3.1. > > > > > > In my Torque schema I use data type BOOLEANCHAR, > > but > > > the field in the database itself is boolean. I > > don't > > > think there is a 'boolchar' option, or anything > > > similar in Postgre. I guess that's why it's > > crashing. > > > Ideally Torque would recognize that it is a > > boolean > > > field and not try to perform an UPPER() on it. > > > > > > Incidentally, I registered for an account on > > scarab > > > and got a message to confirm my subscription. > > > Unfortunately the link sent in the confirm email > > is > > > wrong: > > > > > > > > > http://localhost:38080/scarab/issues/template/Confirm.vm/confirm/... > > > > > > localhost!? > > > > > > I tried putting issues.apache.org and > > www.apache.org > > > instead of localhost but it doesn't work. > > > > > > Any idea? > > > > > > Tanky, > > > Bob > > > > > > > > > @seitenbau.net> wrote: > > > > > > > > > > > > > > > > > > > > Robert, > > > > > > > > Which database and Torque version are you using > > ? > > > > To my knowledge, booleanchar is usually > > implemented > > > > as a char field in the > > > > database (at least for oracle and Torque 3.1.1), > > so > > > > upper should work > > > > there. > > > > > > > > by the way, Scarab is the issue tracker for > > torqe: > > > > http://issues.apache.org/scarab/issues > > > > request a role as observer for Torque->Source > > and > > > > then you are able to > > > > create issues > > > > > > > > Thomas > > > > > > > > > > > > > > > > Robert Bowen <melissalambert@example.org> schrieb am > > 31.03.2005 > > > > 11:03:00: > > > > > > > > > I *am* using BOOLEANCHAR, and it still doesn't > > > > work. > > > > > > > > > > I'll have to take a look at scarab, don't know > > > > what it > > > > > is! > > > > > > > > > > syg > > > > > > > > > > --- Thomas Fischer <melissalambert@example.org> > > wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Sounds like a bug to me. Can you please > > enter > > > > this > > > > > > in scarab, including the > > > > > > database and the torque version you use ? > > > > > > > > > > > > As a workaround, you can try to change your > > > > > > datamodel such that you use the > > > > > > data type booleanchar instead of boolean. > > > > > > > > > > > > Thomas > > > > > > > > > > > > Robert Bowen <melissalambert@example.org> schrieb am > > > > 31.03.2005 > > > > > > 10:02:13: > > > > > > > > > > > > > Hello all. I have a class that sets a > > whole > > > > bunch > > > > > > of > > > > > > > conditions for a search. Most of the > > fields I > > > > > > search > > > > > > > on are text so using > > Criteria.setIgnoreCase() > > > > has > > > > > > been > > > > > > > working. > > > > > > > > > > > > > > I recently added another search criteria, > > on a > > > > > > boolean > > > > > > > field: > > > > > > > > > > > > > > criteria.add(NotificationPeer.IS_COMPLETE, > > > > false); > > > > > > > > > > > > > > But since the setIgnoreCase() is set to > > true > > > > for > > > > > > the > > > > > > > Criteria, Torque tries to do an UPPER() on > > a > > > > > > boolean > > > > > > > field! > > > > > > > > > > > > > > Can I avoid this somehow? Currently it > > crashes > > > > in > > > > > > a > > > > > > > rather ugly way ... > > > > > > > > > > > > > > Thanks! > > > > > > > syg > > > > > > > > > > > > > > > > > > > > > > > > > > > > __________________________________ > > > > > > > Do you Yahoo!? > > > > > > > Make Yahoo! your home page > > > > > > > http://www.yahoo.com/r/hs > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > > > To unsubscribe, e-mail: > > > > > > melissalambert@example.org > > > > > > > For additional commands, e-mail: > > > > > > melissalambert@example.org > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > > To unsubscribe, e-mail: > > > > > > melissalambert@example.org > > > > > > For additional commands, e-mail: > > > > > > melissalambert@example.org > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > __________________________________ > > > > > Do you Yahoo!? > > > > > Yahoo! Small Business - Try our new resources > > > > site! > > > > > http://smallbusiness.yahoo.com/resources/ > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > To unsubscribe, e-mail: > > > > melissalambert@example.org > > > > > For additional commands, e-mail: > > > > melissalambert@example.org > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: > > > > melissalambert@example.org > > > > For additional commands, e-mail: > > > > melissalambert@example.org > > > > > > > > > > > > > > > > > > > > __________________________________ > > > Do you Yahoo!? > > > Yahoo! Mail - Easier than ever with enhanced > > search. Learn more. > > > http://info.mail.yahoo.com/mail_250 > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: > > melissalambert@example.org > > > For additional commands, e-mail: > > melissalambert@example.org > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > > melissalambert@example.org > > For additional commands, e-mail: > > melissalambert@example.org > > > > > > > > > __________________________________ > Do you Yahoo!? > Read only the mail you want - Yahoo! Mail SpamGuard. > http://promotions.yahoo.com/new_mail > > --------------------------------------------------------------------- > To unsubscribe, e-mail: melissalambert@example.org > For additional commands, e-mail: melissalambert@example.org > --------------------------------------------------------------------- To unsubscribe, e-mail: melissalambert@example.org For additional commands, e-mail: melissalambert@example.org From torquemelissalambert@example.org Fri Apr 01 10:29:20 2005 Return-Path: <torquemelissalambert@example.org> Delivered-To: melissalambert@example.org Received: (qmail 44014 invoked from network); 1 Apr 2005 10:29:20 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Apr 2005 10:29:20 -0000 Received: (qmail 99556 invoked by uid 500); 1 Apr 2005 10:29:19 -0000 Delivered-To: melissalambert@example.org Received: (qmail 99165 invoked by uid 500); 1 Apr 2005 10:29:17 -0000 Mailing-List: contact melissalambert@example.org; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:melissalambert@example.org> List-Subscribe: <mailto:melissalambert@example.org> List-Help: <mailto:melissalambert@example.org> List-Post: <mailto:melissalambert@example.org> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <melissalambert@example.org> Delivered-To: mailing list melissalambert@example.org Received: (qmail 99149 invoked by uid 99); 1 Apr 2005 10:29:17 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail.seitenbau.net (HELO mail.seitenbau.net) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 01 Apr 2005 02:29:14 -0800 Received: from [83.161.120.155] (helo=www.seitenbau.net) by router1.seitenbau.net with esmtp (Exim 4.43) id 1DHJOj-0006oN-I8 for melissalambert@example.org; Fri, 01 Apr 2005 12:29:05 +0200 In-Reply-To: <melissalambert@example.org> Subject: RE: [Encoding] Oracle 8.1.7 and Jdk 1.4.1_07 To: "Apache Torque Users List" <melissalambert@example.org> X-Mailer: Lotus Notes Release 6.0 September 26, 2002 Message-ID: <melissalambert@example.org> From: Thomas Fischer <melissalambert@example.org> Date: Fri, 1 Apr 2005 12:29:04 +0200 X-MIMETrack: Serialize by Router on www/seitenbau(Release 6.5.1|January 21, 2004) at 01.04.2005 12:29:05 PM MIME-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hello Raphael, character encoding problems are very ugly in my experience. They are ha= rd to find by the user, and even harder by remote advice. The only thing I can advice you is to pluck the process apart, and find= out exactly where the problem sits, e.g. by inserting and retrieving via sq= l console as compared to insert by jdbc and retrieving via sql console, a= nd so on... One point worth while checking is that the database encoding is such th= at it can actually store accentuated characters correctly. I am quite sure that it is not a Torque problem. One thing you might want to know for further research is that Torque us= es prepared statements for all inserts. Thomas Rapha=EBl Pi=E9roni <melissalambert@example.org> schrieb am 979.866.0673= :15:36: > Hello, > > I'm currently having some troubles using Torque 3.0 on linux (debian > stable kernel 2.4.20) with the Sun jdk (1.4.1_07-b02). > > I now present the problem : > i use the maven torque plugin 3.0 to insert sql files in the database= > (when i cat those files, i can see correctly the accentuated > characters) > > then i use junit tests to check the retreiving of values in the > database > > i systematically had the error > expected <...?> but was <...?> > > i know it is an encoding problem, but i cannot figure how to get rid = of > it. > > may someone please help me. > > Best regards > > Rapha=EBl > > ------------------------------------ > | Rapha=EBl Pi=E9roni | > | 33+ 223 351 354 | > | mailto:melissalambert@example.org | > | http://www.dexem.com | > | mailing:melissalambert@example.org | > ------------------------------------ > > > > > > > __________________________________________________________________ > D=E9couvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour= > vos mails ! > Cr=E9ez votre Yahoo! Mail sur http://fr.mail.yahoo.com/ > > ---------------------------------------------------------------------= > To unsubscribe, e-mail: melissalambert@example.org > For additional commands, e-mail: melissalambert@example.org >= --------------------------------------------------------------------- To unsubscribe, e-mail: melissalambert@example.org For additional commands, e-mail: melissalambert@example.org From torquemelissalambert@example.org Fri Apr 01 15:39:17 2005 Return-Path: <torquemelissalambert@example.org> Delivered-To: melissalambert@example.org Received: (qmail 45668 invoked from network); 1 Apr 2005 15:39:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Apr 2005 15:39:17 -0000 Received: (qmail 28048 invoked by uid 500); 1 Apr 2005 15:39:15 -0000 Delivered-To: melissalambert@example.org Received: (qmail 28026 invoked by uid 500); 1 Apr 2005 15:39:14 -0000 Mailing-List: contact melissalambert@example.org; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:melissalambert@example.org> List-Subscribe: <mailto:melissalambert@example.org> List-Help: <mailto:melissalambert@example.org> List-Post: <mailto:melissalambert@example.org> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <melissalambert@example.org> Delivered-To: mailing list melissalambert@example.org Received: (qmail 28012 invoked by uid 99); 1 Apr 2005 15:39:14 -0000 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=FROM_ENDS_IN_NUMS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from postoffice6.mail.cornell.edu (HELO postoffice6.mail.cornell.edu) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 01 Apr 2005 07:39:12 -0800 Received: from [83.161.120.155] ([83.161.120.155]) by postoffice6.mail.cornell.edu (8.12.10/8.12.6) with ESMTP id j31Fd8gm023719 for <melissalambert@example.org>; Fri, 1 Apr 2005 10:39:09 -0500 (EST) Message-ID: <melissalambert@example.org> Date: Fri, 01 Apr 2005 10:39:07 -0500 From: Laran Evans <melissalambert@example.org> Reply-To: melissalambert@example.org Organization: Cornell University User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Apache Torque Users List <melissalambert@example.org> Subject: create-db.sql and default database References: <melissalambert@example.org> In-Reply-To: <melissalambert@example.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I'm running Torque 3.1.1 (torque itself and generator) against MySQL 4.1.10a-nt. When I run create-db the sql file that is generated contains the text: --- drop database if exists default; create database default; --- When I run the target I get : --- [sql] Failed to execute: drop database if exists default [sql] java.sql.SQLException: You have an error in your SQL syntax; check t he manual that corresponds to your MySQL server version for the right syntax to use near 'default' at line 1 [sql] Failed to execute: create database default [sql] java.sql.SQLException: You have an error in your SQL syntax; check t he manual that corresponds to your MySQL server version for the right syntax to use near 'default' at line 1 [sql] 0 of 2 SQL statements executed successfully Is there a way around this? I have set the name of my schema in the build file. Thanks --------------------------------------------------------------------- To unsubscribe, e-mail: melissalambert@example.org For additional commands, e-mail: melissalambert@example.org From torquemelissalambert@example.org Fri Apr 01 16:08:14 2005 Return-Path: <torquemelissalambert@example.org> Delivered-To: melissalambert@example.org Received: (qmail 52909 invoked from network); 1 Apr 2005 16:08:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Apr 2005 16:08:14 -0000 Received: (qmail 76813 invoked by uid 500); 1 Apr 2005 16:08:12 -0000 Delivered-To: melissalambert@example.org Received: (qmail 76790 invoked by uid 500); 1 Apr 2005 16:08:12 -0000 Mailing-List: contact melissalambert@example.org; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:melissalambert@example.org> List-Subscribe: <mailto:melissalambert@example.org> List-Help: <mailto:melissalambert@example.org> List-Post: <mailto:melissalambert@example.org> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <melissalambert@example.org> Delivered-To: mailing list melissalambert@example.org Received: (qmail 76772 invoked by uid 99); 1 Apr 2005 16:08:11 -0000 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=FROM_ENDS_IN_NUMS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from postoffice6.mail.cornell.edu (HELO postoffice6.mail.cornell.edu) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 01 Apr 2005 08:08:10 -0800 Received: from [83.161.120.155] ([83.161.120.155]) by postoffice6.mail.cornell.edu (8.12.10/8.12.6) with ESMTP id j31G87gm017554 for <melissalambert@example.org>; Fri, 1 Apr 2005 11:08:08 -0500 (EST) Message-ID: <melissalambert@example.org> Date: Fri, 01 Apr 2005 11:08:05 -0500 From: Laran Evans <melissalambert@example.org> Reply-To: melissalambert@example.org Organization: Cornell University User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Apache Torque Users List <melissalambert@example.org> Subject: Re: sql/db-init/Control.vm & ResourceNotFoundException References: <melissalambert@example.org> In-Reply-To: <melissalambert@example.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I re-read the documentation on the torque.templatePath property. I was surprised to see that it was required to be a relative path. I had it set to an absolute path built from the relative paths of my build file. In any case, once I specified the templatePath correctly as a relative path, the Control file was found. Thanks Thomas Fischer wrote: > > >Laran, > >which database are you using (the torque.database setting in the >build.properties of the generator) ? And which Torque version are you using >? > > Thomas > >"Laran Evans" <melissalambert@example.org> schrieb am 979.866.0673:01:01: > > > >>I get this when running the create-db Ant task. >> >>org.apache.velocity.exception.ResourceNotFoundException: Unable to find >>resource >> 'sql/db-init/Control.vm' >> >>The torque and torque-gen .jars are in my classpath. I've tried with >> >> >both > > >>torque.useClasspath=true and torque.useClasspath=false. Both failed. >> >>Any suggestions? >> >>-- >>Laran Evans - Cornell University >>p: 979.866.0673 f: 979.866.0673 >> >> >>--------------------------------------------------------------------- >>To unsubscribe, e-mail: melissalambert@example.org >>For additional commands, e-mail: melissalambert@example.org >> >> >> > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: melissalambert@example.org >For additional commands, e-mail: melissalambert@example.org > > > --------------------------------------------------------------------- To unsubscribe, e-mail: melissalambert@example.org For additional commands, e-mail: melissalambert@example.org From torquemelissalambert@example.org Sat Apr 02 05:36:55 2005 Return-Path: <torquemelissalambert@example.org> Delivered-To: melissalambert@example.org Received: (qmail 21547 invoked from network); 2 Apr 2005 05:36:55 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Apr 2005 05:36:55 -0000 Received: (qmail 68642 invoked by uid 500); 2 Apr 2005 05:36:54 -0000 Delivered-To: melissalambert@example.org Received: (qmail 68618 invoked by uid 500); 2 Apr 2005 05:36:53 -0000 Mailing-List: contact melissalambert@example.org; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:melissalambert@example.org> List-Subscribe: <mailto:melissalambert@example.org> List-Help: <mailto:melissalambert@example.org> List-Post: <mailto:melissalambert@example.org> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <melissalambert@example.org> Delivered-To: mailing list melissalambert@example.org Received: (qmail 68605 invoked by uid 99); 2 Apr 2005 05:36:53 -0000 X-ASF-Spam-Status: No, hits=-10.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from minotaur.apache.org (HELO minotaur.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.28) with SMTP; Fri, 01 Apr 2005 21:36:53 -0800 Received: (qmail 21542 invoked by uid 1977); 2 Apr 2005 05:36:52 -0000 Received: from localhost (melissalambert@example.org) by localhost with SMTP; 2 Apr 2005 05:36:52 -0000 Date: Fri, 1 Apr 2005 21:36:52 -0800 (PST) From: Thomas Fischer <melissalambert@example.org> To: Apache Torque Users List <melissalambert@example.org>, melissalambert@example.org Subject: Re: create-db.sql and default database In-Reply-To: <melissalambert@example.org> Message-ID: <melissalambert@example.org> References: <melissalambert@example.org> <melissalambert@example.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Spam-Rating: localhost 1.6.2 0/1000/N X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Laran, you have used 'default' as database name. 'default' is a reseverd word in Mysql (and in many other databases) and should not be used as name of a database or table or column. Please choose another name. Thomas On Fri, 1 Apr 2005, Laran Evans wrote: > I'm running Torque 3.1.1 (torque itself and generator) against MySQL > 4.1.10a-nt. > > When I run create-db the sql file that is generated contains the text: > > --- > drop database if exists default; > create database default; > --- > > When I run the target I get : > > --- > [sql] Failed to execute: drop database if exists default > [sql] java.sql.SQLException: You have an error in your SQL syntax; check t > he manual that corresponds to your MySQL server version for the right syntax > to > use near 'default' at line 1 > [sql] Failed to execute: create database default > [sql] java.sql.SQLException: You have an error in your SQL syntax; check t > he manual that corresponds to your MySQL server version for the right syntax > to > use near 'default' at line 1 > [sql] 0 of 2 SQL statements executed successfully > > Is there a way around this? I have set the name of my schema in the build > file. > > Thanks > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: melissalambert@example.org > For additional commands, e-mail: melissalambert@example.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: melissalambert@example.org For additional commands, e-mail: melissalambert@example.org From torquemelissalambert@example.org Sun Apr 03 21:14:36 2005 Return-Path: <torquemelissalambert@example.org> Delivered-To: melissalambert@example.org Received: (qmail 59082 invoked from network); 3 Apr 2005 21:14:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Apr 2005 21:14:36 -0000 Received: (qmail 27236 invoked by uid 500); 3 Apr 2005 21:14:34 -0000 Delivered-To: melissalambert@example.org Received: (qmail 27218 invoked by uid 500); 3 Apr 2005 21:14:34 -0000 Mailing-List: contact melissalambert@example.org; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:melissalambert@example.org> List-Subscribe: <mailto:melissalambert@example.org> List-Help: <mailto:melissalambert@example.org> List-Post: <mailto:melissalambert@example.org> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <melissalambert@example.org> Delivered-To: mailing list melissalambert@example.org Received: (qmail 27204 invoked by uid 99); 3 Apr 2005 21:14:34 -0000 X-ASF-Spam-Status: No, hits=1.8 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,FORGED_RCVD_HELO,MSGID_FROM_MTA_HEADER,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of melissalambert@example.org designates 83.161.120.155 as permitted sender) Received: from omc1-s18.bay6.hotmail.com (HELO OMC1-S18.phx.gbl) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Sun, 03 Apr 2005 14:14:32 -0700 Received: from hotmail.com ([83.161.120.155]) by OMC1-S18.phx.gbl with Microsoft SMTPSVC(6.0.3790.211); Sun, 3 Apr 2005 14:14:31 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sun, 3 Apr 2005 14:14:31 -0700 Message-ID: <melissalambert@example.org> Received: from 83.161.120.155 by by1fd.bay1.hotmail.msn.com with HTTP; Sun, 03 Apr 2005 21:14:31 GMT X-Originating-IP: [83.161.120.155] X-Originating-Email: [melissalambert@example.org] X-Sender: melissalambert@example.org In-Reply-To: <melissalambert@example.org> From: "Tom Lianza" <melissalambert@example.org> To: melissalambert@example.org Bcc: Subject: RE: Builds fine on Windows, Fails on Linux (SOLVED) Date: Sun, 03 Apr 2005 17:14:31 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 03 Apr 2005 21:14:31.0330 (UTC) FILETIME=[209A7020:01C53892] X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N For anyone else who might have run into this problem - I figured out the cause. I was trying to build with ant version 1.6.2, but that version of torque came with ant-1.5. When I rebuilt with ant 1.5, those errors went away. >From: Thomas Fischer <melissalambert@example.org> >Reply-To: "Apache Torque Users List" <melissalambert@example.org> >To: "Apache Torque Users List" <melissalambert@example.org> >Subject: RE: Builds fine on Windows, Fails on Linux >Date: Tue, 29 Mar 2005 09:17:07 +0200 > > > > > >Tom, > >I do not think the operation system is a problem. I have no experience with >3.0.2, but from 3.1 on, the builds run also on linux. >Are you sure you do not have any absolute paths in your configuration ? > >Perhaps it is best to start the installation from scratch on linux and copy >only the files you have modified, reviewing them as you copy them. > > Thomas > >"Tom Lianza" <melissalambert@example.org> schrieb am 979.866.0673:39:42: > > > Hi All, > > > > I have a torque project based on Torque 3.0.2. Everything works fine >when I > > do a build on Windows. However, when I copy all of my files down to my > > linux machine and try and run ant -f build-torque.xml I get the >following > > > error message: > > > > /home/tlianza/workspace/usoil/torque/build-torque.xml:122: The following > > error occurred while executing this line: > > /home/tlianza/workspace/usoil/torque/build-torque.xml:185: The following > > error occurred while executing this line: > > /home/tlianza/workspace/usoil/torque/build-torque.xml:216: Generation > > failed. For more information consult the velocity log, or invoke ant >with > > > the -debug flag. > > > > That error corresponds to the "templatePath" argument of the torque-sql >tag > > in my sql-template target. Velocity.log doesn't show anything that I >can > > > see as useful: > > > > ----------------2005-03-26 16:31:59,618 - Starting Jakarta Velocity v1.3 > > 2005-03-26 16:31:59,618 - RuntimeInstance initializing. > > 2005-03-26 16:31:59,618 - Default Properties File: > > org/apache/velocity/runtime/defaults/velocity.properties > > 2005-03-26 16:31:59,618 - Trying to use logger class > > org.apache.velocity.runtime.log.AvalonLogSystem > > 2005-03-26 16:31:59,618 - Couldn't find class > > org.apache.velocity.runtime.log.AvalonLogSystem or necessary supporting > > classes in classpath. Exception : java.lang.NoClassDefFoundError: > > org/apache/log/format/Formatter > > 2005-03-26 16:31:59,618 - Trying to use logger class > > org.apache.velocity.runtime.log.SimpleLog4JLogSystem > > 2005-03-26 16:31:59,618 - Using logger class > > org.apache.velocity.runtime.log.SimpleLog4JLogSystem > > 2005-03-26 16:31:59,621 - Default ResourceManager initializing. (class > > org.apache.velocity.runtime.resource.ResourceManagerImpl) > > 2005-03-26 16:31:59,624 - Resource Loader Instantiated: > > org.apache.velocity.runtime.resource.loader.FileResourceLoader > > 2005-03-26 16:31:59,625 - FileResourceLoader : initialization starting. > > 2005-03-26 16:31:59,625 - FileResourceLoader : adding path > > '/home/tlianza/workspace/usoil/torque/templates' > > 2005-03-26 16:31:59,625 - FileResourceLoader : initialization complete. > > 2005-03-26 16:31:59,629 - ResourceCache : initialized. (class > > org.apache.velocity.runtime.resource.ResourceCacheImpl) > > 2005-03-26 16:31:59,629 - Default ResourceManager initialization >complete. > > 2005-03-26 16:31:59,631 - Loaded System Directive: > > org.apache.velocity.runtime.directive.Literal > > 2005-03-26 16:31:59,632 - Loaded System Directive: > > org.apache.velocity.runtime.directive.Macro > > 2005-03-26 16:31:59,633 - Loaded System Directive: > > org.apache.velocity.runtime.directive.Parse > > 2005-03-26 16:31:59,635 - Loaded System Directive: > > org.apache.velocity.runtime.directive.Include > > 2005-03-26 16:31:59,637 - Loaded System Directive: > > org.apache.velocity.runtime.directive.Foreach > > 2005-03-26 16:31:59,733 - Created: 20 parsers. > > 2005-03-26 16:31:59,733 - Velocimacro : initialization starting. > > 2005-03-26 16:31:59,733 - Velocimacro : adding VMs from VM library >template > > : VM_global_library.vm > > 2005-03-26 16:31:59,736 - ResourceManager : unable to find resource > > 'VM_global_library.vm' in any resource loader. > > 2005-03-26 16:31:59,736 - Velocimacro : error using VM library template > > VM_global_library.vm : > > org.apache.velocity.exception.ResourceNotFoundException: Unable to find > > resource 'VM_global_library.vm' > > 2005-03-26 16:31:59,736 - Velocimacro : VM library template macro > > registration complete. > > 2005-03-26 16:31:59,736 - Velocimacro : allowInline = true : VMs can be > > defined inline in templates > > 2005-03-26 16:31:59,736 - Velocimacro : allowInlineToOverride = false : >VMs > > defined inline may NOT replace previous VM definitions > > 2005-03-26 16:31:59,736 - Velocimacro : allowInlineLocal = false : VMs > > defined inline will be global in scope if allowed. > > 2005-03-26 16:31:59,736 - Velocimacro : messages on : VM system will >output > > logging messages > > 2005-03-26 16:31:59,736 - Velocimacro : autoload off : VM system will >not > > automatically reload global library macros > > 2005-03-26 16:31:59,736 - Velocimacro : initialization complete. > > 2005-03-26 16:31:59,736 - Velocity successfully started. > > ------------------------- > > > > Any ideas? This same set of files builds fine with Windows, so I'm >thinking > > it's either something environmental (classpath environment variable?) or > > os-dependent... I just don't see what that could be. > > > > Thanks! > > Tom > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: melissalambert@example.org > > For additional commands, e-mail: melissalambert@example.org > > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: melissalambert@example.org >For additional commands, e-mail: melissalambert@example.org > --------------------------------------------------------------------- To unsubscribe, e-mail: melissalambert@example.org For additional commands, e-mail: melissalambert@example.org From torquemelissalambert@example.org Tue Apr 05 02:01:08 2005 Return-Path: <torquemelissalambert@example.org> Delivered-To: melissalambert@example.org Received: (qmail 93539 invoked from network); 5 Apr 2005 02:01:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Apr 2005 02:01:08 -0000 Received: (qmail 67218 invoked by uid 500); 5 Apr 2005 02:01:06 -0000 Delivered-To: melissalambert@example.org Received: (qmail 67196 invoked by uid 500); 5 Apr 2005 02:01:05 -0000 Mailing-List: contact melissalambert@example.org; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:melissalambert@example.org> List-Subscribe: <mailto:melissalambert@example.org> List-Help: <mailto:melissalambert@example.org> List-Post: <mailto:melissalambert@example.org> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <melissalambert@example.org> Delivered-To: mailing list melissalambert@example.org Received: (qmail 67183 invoked by uid 99); 5 Apr 2005 02:01:05 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) Received: from mx.udtech.co.jp (HELO gw.udtech.co.jp) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 04 Apr 2005 19:01:04 -0700 Received: from ichikawa.seta.co.jp ([83.161.120.155]) by gw.udtech.co.jp (8.12.10/8.12.10) with ESMTP id j3520kdS005056 for <melissalambert@example.org>; Tue, 5 Apr 2005 11:00:50 +0900 Message-Id: <melissalambert@example.org> X-Sender: melissalambert@example.org X-Mailer: QUALCOMM Windows Eudora Version 6J-Jr3 Date: Tue, 05 Apr 2005 11:00:30 +0900 To: melissalambert@example.org From: Kenji Ichikawa <melissalambert@example.org> Subject: How to fetch the rows with Peer class Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hello, I'm ichikawa. I would like to implement to fetch the rows with Peer class of Torque, becase the table row size is too large, so probably OutOfMemoryError will heppen if the following code is executed. Criteria criteria = new Criteria(); List list = MyTablePeer.doSelect( criteria ); I would like to know how to fetch the rows with Peer class, it's like the following code of JDBC implementation. Statement st = conn.createStatement(); st.setFetchSize(50); ResultSet rs = st.executeQuery("SELECT * FROM my_table"); while (rs.next()) { System.out.print("a row was returned."); } rs.close(); st.close(); If you know how to do, Could you give me advice ? --------------------------- Kenji Ichikawa mailto:melissalambert@example.org http://www.seta.co.jp/ --------------------------------------------------------------------- To unsubscribe, e-mail: melissalambert@example.org For additional commands, e-mail: melissalambert@example.org From torquemelissalambert@example.org Tue Apr 05 10:36:28 2005 Return-Path: <torquemelissalambert@example.org> Delivered-To: melissalambert@example.org Received: (qmail 15137 invoked from network); 5 Apr 2005 10:36:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Apr 2005 10:36:28 -0000 Received: (qmail 67980 invoked by uid 500); 5 Apr 2005 10:36:27 -0000 Delivered-To: melissalambert@example.org Received: (qmail 67593 invoked by uid 500); 5 Apr 2005 10:36:26 -0000 Mailing-List: contact melissalambert@example.org; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:melissalambert@example.org> List-Subscribe: <mailto:melissalambert@example.org> List-Help: <mailto:melissalambert@example.org> List-Post: <mailto:melissalambert@example.org> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <melissalambert@example.org> Delivered-To: mailing list melissalambert@example.org Received: (qmail 60966 invoked by uid 99); 5 Apr 2005 09:39:46 -0000 X-ASF-Spam-Status: No, hits=0.4 required=10.0 tests=DNS_FROM_RFC_ABUSE,RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of melissalambert@example.org designates 83.161.120.155 as permitted sender) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=Rxmw1vmsVacED7NtX+ZxdHmdJlrGiFTqgeVzvSjSxX/QQ96piozyUXsIQtFLjP4vRh9ixuBsY5xzDhyKJOwdE28ulc1lf75maV8vHbWi8Mw3ugW4jIeEnbb9Y4rp8rLL62iILbmEGNy95/+DvjVtKr/kj7yEHL3d34Dg7M2mjgQ= Message-ID: <melissalambert@example.org> Date: Tue, 5 Apr 2005 15:09:43 +0530 From: Anil More <melissalambert@example.org> Reply-To: Anil More <melissalambert@example.org> To: melissalambert@example.org Subject: Torque Runtime configuration in torque-3.1.1.tar.gz Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi, The Tutorial says: " The runtime distribution archive includes an Ant build file that can be used to generate your Torque runtime configuration. When you unpack the archive you will see the following: " However, I don't see a build.xml file in the runtime bundle I downloaded - torque-3.1.1.tar.gz. Thank you. - Anil --------------------------------------------------------------------- To unsubscribe, e-mail: melissalambert@example.org For additional commands, e-mail: melissalambert@example.org From torquemelissalambert@example.org Tue Apr 05 10:38:02 2005 Return-Path: <torquemelissalambert@example.org> Delivered-To: melissalambert@example.org Received: (qmail 15589 invoked from network); 5 Apr 2005 10:38:02 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Apr 2005 10:38:02 -0000 Received: (qmail 70187 invoked by uid 500); 5 Apr 2005 10:38:00 -0000 Delivered-To: melissalambert@example.org Received: (qmail 70178 invoked by uid 500); 5 Apr 2005 10:38:00 -0000 Mailing-List: contact melissalambert@example.org; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:melissalambert@example.org> List-Subscribe: <mailto:melissalambert@example.org> List-Help: <mailto:melissalambert@example.org> List-Post: <mailto:melissalambert@example.org> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <melissalambert@example.org> Delivered-To: mailing list melissalambert@example.org Received: (qmail 46056 invoked by uid 99); 5 Apr 2005 09:33:27 -0000 X-ASF-Spam-Status: No, hits=0.1 required=10.0 tests=FORGED_RCVD_HELO,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C539C2.D02266A2" Disposition-Notification-To: "Anil More" <melissalambert@example.org> Subject: Help - Tutorial Date: Tue, 5 Apr 2005 02:35:32 -0700 Message-ID: <CE89F669E67F12458039DCD317EBF45602A2F395@xch001> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Help - Tutorial Thread-Index: AcU5wnT5+ehnvvSdSQ2EOQK32Vs5QQ== From: "Anil More" <melissalambert@example.org> To: <melissalambert@example.org> X-Virus-Scanned: at azulsystems.com X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------_=_NextPart_001_01C539C2.D02266A2 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, =20 An extract from the Tutorial - Step 2: =20 =20 {1. You configure the generator by setting properties in the project.properties file in root directory of your project - this is the = file that we will edit first.} =20 If torque.project =3D bookstore, then is the "root directory" of the = project "bookstore"? =20 Thank you. =20 - Anil ------_=_NextPart_001_01C539C2.D02266A2-- From torquemelissalambert@example.org Tue Apr 05 10:40:21 2005 Return-Path: <torquemelissalambert@example.org> Delivered-To: melissalambert@example.org Received: (qmail 17049 invoked from network); 5 Apr 2005 10:40:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Apr 2005 10:40:21 -0000 Received: (qmail 76411 invoked by uid 500); 5 Apr 2005 10:40:18 -0000 Delivered-To: melissalambert@example.org Received: (qmail 76389 invoked by uid 500); 5 Apr 2005 10:40:18 -0000 Mailing-List: contact melissalambert@example.org; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:melissalambert@example.org> List-Subscribe: <mailto:melissalambert@example.org> List-Help: <mailto:melissalambert@example.org> List-Post: <mailto:melissalambert@example.org> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <melissalambert@example.org> Delivered-To: mailing list melissalambert@example.org Received: (qmail 76374 invoked by uid 99); 5 Apr 2005 10:40:18 -0000 X-ASF-Spam-Status: No, hits=0.1 required=10.0 tests=FORGED_RCVD_HELO,RCVD_BY_IP X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mta.pagenic.nl (HELO bangkok.pagenic.nl) (83.161.120.155) by apache.org (qpsmtpd/0.28) with SMTP; Tue, 05 Apr 2005 03:40:17 -0700 Received: (qmail 27932 invoked by uid 1002); 5 Apr 2005 10:40:14 -0000 Received: from unknown (HELO amsterdam.pagelink) (83.161.120.155) by 83.161.120.155 with SMTP; 5 Apr 2005 10:40:14 -0000 Received: by amsterdam.pagelink with Internet Mail Service (5.5.2653.19) id <ZDSMVYQJ>; Tue, 5 Apr 2005 12:40:13 +0200 Message-ID: <melissalambert@example.org> From: Robert Kromkamp <melissalambert@example.org> To: 'Apache Torque Users List' <melissalambert@example.org> Subject: RE: Torque Runtime configuration in torque-3.1.1.tar.gz Date: Tue, 5 Apr 2005 12:40:12 +0200 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi, Torque-3.1.1. uses Maven instead of Ant, you can read it in: http://db.apache.org/torque/maven-howto.html If you don't want to use maven you can try to copy the build.xml from the 3.1 release. Robert -----Original Message----- From: Anil More [mailto:melissalambert@example.org] Sent: dinsdag 5 april 2005 11:40 To: melissalambert@example.org Subject: Torque Runtime configuration in torque-3.1.1.tar.gz Hi, The Tutorial says: " The runtime distribution archive includes an Ant build file that can be used to generate your Torque runtime configuration. When you unpack the archive you will see the following: " However, I don't see a build.xml file in the runtime bundle I downloaded - torque-3.1.1.tar.gz. Thank you. - Anil --------------------------------------------------------------------- To unsubscribe, e-mail: melissalambert@example.org For additional commands, e-mail: melissalambert@example.org --------------------------------------------------------------------- To unsubscribe, e-mail: melissalambert@example.org For additional commands, e-mail: melissalambert@example.org From torquemelissalambert@example.org Tue Apr 05 10:41:06 2005 Return-Path: <torquemelissalambert@example.org> Delivered-To: melissalambert@example.org Received: (qmail 17246 invoked from network); 5 Apr 2005 10:41:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Apr 2005 10:41:05 -0000 Received: (qmail 77453 invoked by uid 500); 5 Apr 2005 10:41:03 -0000 Delivered-To: melissalambert@example.org Received: (qmail 77281 invoked by uid 500); 5 Apr 2005 10:41:02 -0000 Mailing-List: contact melissalambert@example.org; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:melissalambert@example.org> List-Subscribe: <mailto:melissalambert@example.org> List-Help: <mailto:melissalambert@example.org> List-Post: <mailto:melissalambert@example.org> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <melissalambert@example.org> Delivered-To: mailing list melissalambert@example.org Received: (qmail 77267 invoked by uid 99); 5 Apr 2005 10:41:02 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail.seitenbau.net (HELO
{'source': 'Apache Software Foundation Public Mail Archives'}