From torquenrice@example.net Wed Oct 07 19:31:18 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 12922 invoked from network); 7 Oct 2009 19:31:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 7 Oct 2009 19:31:18 -0000 Received: (qmail 93986 invoked by uid 500); 7 Oct 2009 19:31:18 -0000 Delivered-To: nrice@example.net Received: (qmail 93921 invoked by uid 500); 7 Oct 2009 19:31:18 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 93910 invoked by uid 99); 7 Oct 2009 19:31:17 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Oct 2009 19:31:17 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of nrice@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO kuber.nabble.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Oct 2009 19:31:07 +0000 Received: from isper.nabble.com ([83.161.120.155]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from <nrice@example.net>) id 1MvcDn-0002v4-6Q for nrice@example.net; Wed, 07 Oct 2009 12:30:47 -0700 Message-ID: <nrice@example.net> Date: Wed, 7 Oct 2009 12:30:47 -0700 (PDT) From: dizzle <nrice@example.net> To: nrice@example.net Subject: Transactioning with MySQL MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: nrice@example.net X-Virus-Checked: Checked by ClamAV on apache.org Can someone explain why my transaction is being committed on loc.save(connection) when it should be rolled back? Torque.init("Torque.properties"); java.sql.Connection connection = org.apache.torque.util.Transaction.begin(Torque.getDefaultDB()); Location loc = new Location(); loc.setAltitude(BigDecimal.ONE); loc.setLongitude(BigDecimal.ONE); loc.setLatitude(BigDecimal.ONE); loc.save(connection); org.apache.torque.util.Transaction.safeRollback(connection); I'm using a MySQL db and I am able to successfully use torque with everything other than Transactioning. Any help would be appreciated. - Dom -- View this message in context: http://www.nabble.com/Transactioning-with-MySQL-tp25792863p25792863.html Sent from the Apache DB - Torque Users mailing list nrice@example.net. --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Thu Oct 08 05:32:37 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 83648 invoked from network); 8 Oct 2009 05:32:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 8 Oct 2009 05:32:37 -0000 Received: (qmail 7188 invoked by uid 500); 8 Oct 2009 05:32:37 -0000 Delivered-To: nrice@example.net Received: (qmail 7128 invoked by uid 500); 8 Oct 2009 05:32:37 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 7118 invoked by uid 99); 8 Oct 2009 05:32:36 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Oct 2009 05:32:36 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [83.161.120.155] (HELO mail.seitenbau.net) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Oct 2009 05:32:27 +0000 Received: from [83.161.120.155] (helo=www.seitenbau.net) by router.seitenbau.net with esmtp (Exim 4.43) id 1Mvlmx-0007CN-1T for nrice@example.net; Thu, 08 Oct 2009 07:43:44 +0200 In-Reply-To: <nrice@example.net> References: <nrice@example.net> Subject: RE: Transactioning with MySQL X-KeepSent: C43D4939:81E0D3C5-C1257649:001E0757; type=4; name=$KeepSent To: "Apache Torque Users List" <nrice@example.net> X-Mailer: Lotus Notes Release 8.5 December 05, 2008 Message-ID: <nrice@example.net> From: Thomas Fischer <nrice@example.net> Date: Thu, 8 Oct 2009 07:32:01 +0200 X-MIMETrack: Serialize by Router on www/seitenbau(Release 8.5HF467 | May 15, 2009) at 08.10.2009 07:32:01 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Spam-Score: -1.4 (-) X-Spam-Report: -1.4 ALL_TRUSTED Passed through trusted hosts only via SMTP X-Virus-Checked: Checked by ClamAV on apache.org > Can someone explain why my transaction is being committed on > loc.save(connection) when it should be rolled back? > ... - Check that you use a mysql engine that supports transactions (the default engine MyISAM does NOT support transactions) - check that autocommit is set false in your database properties (you can also use connection.getAutocommit() to check) - If that still does not work (which I doubt), please debug into the Torque code and check when the commit occurs. Thomas --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Thu Oct 08 13:05:44 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 12713 invoked from network); 8 Oct 2009 13:05:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 8 Oct 2009 13:05:43 -0000 Received: (qmail 55780 invoked by uid 500); 8 Oct 2009 13:05:42 -0000 Delivered-To: nrice@example.net Received: (qmail 55759 invoked by uid 500); 8 Oct 2009 13:05:42 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 55749 invoked by uid 99); 8 Oct 2009 13:05:42 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Oct 2009 13:05:42 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of nrice@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO kuber.nabble.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Oct 2009 13:05:32 +0000 Received: from isper.nabble.com ([83.161.120.155]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from <nrice@example.net>) id 1MvsgB-0004c8-WC for nrice@example.net; Thu, 08 Oct 2009 06:05:11 -0700 Message-ID: <nrice@example.net> Date: Thu, 8 Oct 2009 06:05:11 -0700 (PDT) From: dizzle <nrice@example.net> To: nrice@example.net Subject: RE: Transactioning with MySQL In-Reply-To: <nrice@example.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: nrice@example.net References: <nrice@example.net> <nrice@example.net> X-Virus-Checked: Checked by ClamAV on apache.org Changing my engine to innodb did the trick. Thank you. - Dom Thomas Fischer-11 wrote: > >> Can someone explain why my transaction is being committed on >> loc.save(connection) when it should be rolled back? >> ... > > - Check that you use a mysql engine that supports transactions (the > default > engine MyISAM does NOT support transactions) > - check that autocommit is set false in your database properties (you can > also use connection.getAutocommit() to check) > - If that still does not work (which I doubt), please debug into the > Torque > code and check when the commit occurs. > > Thomas > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: nrice@example.net > For additional commands, e-mail: nrice@example.net > > > -- View this message in context: http://www.nabble.com/Transactioning-with-MySQL-tp25792863p25802975.html Sent from the Apache DB - Torque Users mailing list nrice@example.net. --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Thu Oct 08 23:01:36 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 48172 invoked from network); 8 Oct 2009 23:01:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 8 Oct 2009 23:01:36 -0000 Received: (qmail 34031 invoked by uid 500); 8 Oct 2009 23:01:36 -0000 Delivered-To: nrice@example.net Received: (qmail 33980 invoked by uid 500); 8 Oct 2009 23:01:36 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 33970 invoked by uid 99); 8 Oct 2009 23:01:36 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Oct 2009 23:01:36 +0000 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: 83.161.120.155 is neither permitted nor denied by domain of nrice@example.net) Received: from [83.161.120.155] (HELO vps.cogentisolution.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Oct 2009 23:01:25 +0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=simmgene.com; h=Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding:X-Source:X-Source-Args:X-Source-Dir; b=YzZOA9e5PAPRyq7t3zg+ac9jnXp5+7XmtvHmHFDMp5W67k2Zdqimptxzfasj4LXIMyCuoBnPzCg+nxs1WuX59bQo07qkCLRepmC776pVJmelLCwMBQapEtEcGMElhlea; Received: from [83.161.120.155] (helo=[83.161.120.155]) by vps.cogentisolution.com with esmtpa (Exim 4.69) (envelope-from <nrice@example.net>) id 1Mw1yp-0007mf-Qt for nrice@example.net; Thu, 08 Oct 2009 23:01:03 +0000 Message-ID: <nrice@example.net> Date: Thu, 08 Oct 2009 17:03:46 -0600 From: Sheldon Ross <nrice@example.net> User-Agent: Thunderbird 83.161.120.155 (X11/20090817) MIME-Version: 1.0 To: nrice@example.net Subject: Update stalls Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - vps.cogentisolution.com X-AntiAbuse: Original Domain - db.apache.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - simmgene.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Checked: Checked by ClamAV on apache.org Is there a way to log peer updates, I'm trying to figure out why a save is failing. The last thing the torque log shows is this. 2009-10-08 16:57:08,248 [TP-Processor3] DEBUG org.apache.torque.util.BasePeer - BasePeer.doUpdate: whereClause=XXXXXX=4433148 It just appears to stall at this point. The application just hangs on the obj.save(); -- Sheldon Ross --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Fri Oct 09 11:58:44 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 60512 invoked from network); 9 Oct 2009 11:58:44 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 9 Oct 2009 11:58:44 -0000 Received: (qmail 17561 invoked by uid 500); 9 Oct 2009 11:58:44 -0000 Delivered-To: nrice@example.net Received: (qmail 17537 invoked by uid 500); 9 Oct 2009 11:58:44 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 17527 invoked by uid 99); 9 Oct 2009 11:58:44 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Oct 2009 11:58:44 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [83.161.120.155] (HELO mail.seitenbau.net) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Oct 2009 11:58:35 +0000 Received: from [83.161.120.155] (helo=www.seitenbau.net) by router.seitenbau.net with esmtp (Exim 4.43) id 1MwEIQ-0002we-N5 for nrice@example.net; Fri, 09 Oct 2009 14:10:07 +0200 In-Reply-To: <nrice@example.net> References: <nrice@example.net> Subject: Antwort: Update stalls X-KeepSent: 369DB2E6:20ECF3C7-C125764A:0041B0EA; type=4; name=$KeepSent To: "Apache Torque Users List" <nrice@example.net> X-Mailer: Lotus Notes Release 8.5 December 05, 2008 Message-ID: <nrice@example.net> From: Thomas Fischer <nrice@example.net> Date: Fri, 9 Oct 2009 13:58:13 +0200 X-MIMETrack: Serialize by Router on www/seitenbau(Release 8.5HF467 | May 15, 2009) at 09.10.2009 13:58:13 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Spam-Score: -1.4 (-) X-Spam-Report: -1.4 ALL_TRUSTED Passed through trusted hosts only via SMTP X-Virus-Checked: Checked by ClamAV on apache.org > Is there a way to log peer updates, I'm trying to figure out why a save > is failing. People have used p6spy for this. It wraps your db driver and logs all sql. Thomas --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Fri Oct 09 20:30:54 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 49640 invoked from network); 9 Oct 2009 20:30:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 9 Oct 2009 20:30:54 -0000 Received: (qmail 21051 invoked by uid 500); 9 Oct 2009 20:30:53 -0000 Delivered-To: nrice@example.net Received: (qmail 21006 invoked by uid 500); 9 Oct 2009 20:30:53 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 20996 invoked by uid 99); 9 Oct 2009 20:30:53 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Oct 2009 20:30:53 +0000 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: 83.161.120.155 is neither permitted nor denied by domain of nrice@example.net) Received: from [83.161.120.155] (HELO vps.cogentisolution.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Oct 2009 20:30:42 +0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=simmgene.com; h=Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding:X-Source:X-Source-Args:X-Source-Dir; b=VOMlOROUrqDSufgdh0esogrT4MYgScTBPPuoFD3okKvYZA6Ml8T7/MO6H+c5bjO8ruTYuwSk9eISPN8VvGY+5TbFo6h8+ksOP5KxGWZFtk4+RL+aTku0yWC3Wd+Q8dQY; Received: from [83.161.120.155] (helo=[83.161.120.155]) by vps.cogentisolution.com with esmtpa (Exim 4.69) (envelope-from <nrice@example.net>) id 1MwM6R-0005pF-8W for nrice@example.net; Fri, 09 Oct 2009 20:30:15 +0000 Message-ID: <nrice@example.net> Date: Fri, 09 Oct 2009 14:32:52 -0600 From: Sheldon Ross <nrice@example.net> User-Agent: Thunderbird 83.161.120.155 (X11/20090817) MIME-Version: 1.0 To: Apache Torque Users List <nrice@example.net> Subject: Re: Antwort: Update stalls References: <nrice@example.net> <nrice@example.net> In-Reply-To: <nrice@example.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - vps.cogentisolution.com X-AntiAbuse: Original Domain - db.apache.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - simmgene.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Checked: Checked by ClamAV on apache.org I've tracked it down to a Postgresql connection releasing problem, which apparently is known. The solution mentioned is to use the newer org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory rather than org.apache.torque.dsfactory.SharedPoolDataSourceFactory But I don't seem to have this Jdbc2PoolDataSourceFactory and I just downloaded the latest torque 3.3. Any thoughts? Thanks Thomas Fischer wrote: >> Is there a way to log peer updates, I'm trying to figure out why a save >> is failing. >> > > People have used p6spy for this. It wraps your db driver and logs all sql. > > Thomas > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: nrice@example.net > For additional commands, e-mail: nrice@example.net > > > -- Sheldon Ross --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Fri Oct 09 22:11:51 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 83069 invoked from network); 9 Oct 2009 22:11:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 9 Oct 2009 22:11:50 -0000 Received: (qmail 40234 invoked by uid 500); 9 Oct 2009 22:11:50 -0000 Delivered-To: nrice@example.net Received: (qmail 40181 invoked by uid 500); 9 Oct 2009 22:11:50 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 40171 invoked by uid 99); 9 Oct 2009 22:11:50 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Oct 2009 22:11:50 +0000 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: 83.161.120.155 is neither permitted nor denied by domain of nrice@example.net) Received: from [83.161.120.155] (HELO vps.cogentisolution.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Oct 2009 22:11:39 +0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=simmgene.com; h=Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding:X-Source:X-Source-Args:X-Source-Dir; b=ma5KvkVo8o/clCOWyzMkSSUJymlsDGDliC7bJXIDKDLrECRAXw7Trv2PsVjtceFgBH+GmUefyhapVkmM1GWlxmUTEzgVsE/5Jym2QjEXM0KPLyKZtEASvj+57uWRp+dr; Received: from [83.161.120.155] (helo=[83.161.120.155]) by vps.cogentisolution.com with esmtpa (Exim 4.69) (envelope-from <nrice@example.net>) id 1MwNdA-0005kq-Dd for nrice@example.net; Fri, 09 Oct 2009 22:08:08 +0000 Message-ID: <nrice@example.net> Date: Fri, 09 Oct 2009 16:10:44 -0600 From: Sheldon Ross <nrice@example.net> User-Agent: Thunderbird 83.161.120.155 (X11/20090817) MIME-Version: 1.0 To: Apache Torque Users List <nrice@example.net> Subject: Re: Antwort: Update stalls References: <nrice@example.net> <nrice@example.net> <nrice@example.net> In-Reply-To: <nrice@example.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - vps.cogentisolution.com X-AntiAbuse: Original Domain - db.apache.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - simmgene.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Checked: Checked by ClamAV on apache.org Ah found it at last, commons-dbcp, and commons-pool needed to be updated. Works great now. Sheldon Ross wrote: > I've tracked it down to a Postgresql connection releasing problem, > which apparently is known. > The solution mentioned is to use the newer > > org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory > > rather than > > org.apache.torque.dsfactory.SharedPoolDataSourceFactory > > But I don't seem to have this Jdbc2PoolDataSourceFactory and I just > downloaded the latest torque 3.3. > > Any thoughts? > > Thanks > > Thomas Fischer wrote: >>> Is there a way to log peer updates, I'm trying to figure out why a save >>> is failing. >>> >> >> People have used p6spy for this. It wraps your db driver and logs all >> sql. >> >> Thomas >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: nrice@example.net >> For additional commands, e-mail: nrice@example.net >> >> >> > -- Sheldon Ross Software Development American Simmental Association nrice@example.net +1-682-282-9971 --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Mon Oct 12 22:21:42 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 91061 invoked from network); 12 Oct 2009 22:21:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 12 Oct 2009 22:21:40 -0000 Received: (qmail 80617 invoked by uid 500); 12 Oct 2009 22:21:39 -0000 Delivered-To: nrice@example.net Received: (qmail 80582 invoked by uid 500); 12 Oct 2009 22:21:39 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 80572 invoked by uid 99); 12 Oct 2009 22:21:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Oct 2009 22:21:39 +0000 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: 83.161.120.155 is neither permitted nor denied by domain of nrice@example.net) Received: from [83.161.120.155] (HELO vps.cogentisolution.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Oct 2009 22:21:26 +0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=simmgene.com; h=Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding:X-Source:X-Source-Args:X-Source-Dir; b=b/U1WBLi37MSHPgCY/Z4PqFdyjix4svBdoGYRB3s1RoDaJJk2tCDq13FoVaSYllYKFph6/khGdBL4iPXAWAS4ZzW6X02OcR2A8ILqBeFTRAXvUYju3PRGd5RElLdxGxZ; Received: from [83.161.120.155] (helo=[83.161.120.155]) by vps.cogentisolution.com with esmtpa (Exim 4.69) (envelope-from <nrice@example.net>) id 1MxTGJ-00022x-KR for nrice@example.net; Mon, 12 Oct 2009 22:21:03 +0000 Message-ID: <nrice@example.net> Date: Mon, 12 Oct 2009 16:23:42 -0600 From: Sheldon Ross <nrice@example.net> User-Agent: Thunderbird 83.161.120.155 (X11/20090817) MIME-Version: 1.0 To: Apache Torque Users List <nrice@example.net> Subject: Criteria casting. Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - vps.cogentisolution.com X-AntiAbuse: Original Domain - db.apache.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - simmgene.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Checked: Checked by ClamAV on apache.org So I have Criteria subquery = new Criteria(); criteria.add(ThisObjectPeer.COLUMN_A,valueA); criteria.addSelectColumn(ThisObjectPeer.COLUMN_B); Criteria criteria = new Criteria(); criteria.add(TheOtherObjectPeer.COLUMN_C,subquery,Criteria.IN); The only problem is COLUMN_B is an string, and COLUMN_C is an integer. Is there any way to add a cast in the subquery, or select column as an integer? The new versions of Postgresql strongly enforce types and won't let you compare integer to character varying. Any thoughts? Thanks -- Sheldon Ross Software Development --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Tue Oct 13 05:26:50 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 37057 invoked from network); 13 Oct 2009 05:26:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 13 Oct 2009 05:26:50 -0000 Received: (qmail 94892 invoked by uid 500); 13 Oct 2009 05:26:49 -0000 Delivered-To: nrice@example.net Received: (qmail 94855 invoked by uid 500); 13 Oct 2009 05:26:49 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 94845 invoked by uid 99); 13 Oct 2009 05:26:48 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Oct 2009 05:26:48 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=BAYES_00 X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [83.161.120.155] (HELO mail.seitenbau.net) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Oct 2009 05:26:45 +0000 Received: from [83.161.120.155] (helo=www.seitenbau.net) by router.seitenbau.net with esmtp (Exim 4.43) id 1Mxa5y-0006ej-6b for nrice@example.net; Tue, 13 Oct 2009 07:38:51 +0200 In-Reply-To: <nrice@example.net> References: <nrice@example.net> Subject: RE: Criteria casting. X-KeepSent: AA34A729:11D1F669-C125764E:001C9B17; type=4; name=$KeepSent To: "Apache Torque Users List" <nrice@example.net> X-Mailer: Lotus Notes Release 8.5 December 05, 2008 Message-ID: <nrice@example.net> From: Thomas Fischer <nrice@example.net> Date: Tue, 13 Oct 2009 07:26:19 +0200 X-MIMETrack: Serialize by Router on www/seitenbau(Release 8.5HF467 | May 15, 2009) at +1-682-282-9971 07:26:19 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Spam-Score: -1.4 (-) X-Spam-Report: -1.4 ALL_TRUSTED Passed through trusted hosts only via SMTP What you can try to do is to use a postgresql function (if it exists) to convert the String to integer in the select statement. This should be accepted by Torque. Thomas Sheldon Ross <nrice@example.net> schrieb am +1-682-282-9971 00:23:42: > Von: > > Sheldon Ross <nrice@example.net> > > An: > > Apache Torque Users List <nrice@example.net> > > Datum: > > +1-682-282-9971 00:28 > > Betreff: > > Criteria casting. > > So I have > > Criteria subquery = new Criteria(); > criteria.add(ThisObjectPeer.COLUMN_A,valueA); > criteria.addSelectColumn(ThisObjectPeer.COLUMN_B); > > Criteria criteria = new Criteria(); > criteria.add(TheOtherObjectPeer.COLUMN_C,subquery,Criteria.IN); > > > The only problem is COLUMN_B is an string, and COLUMN_C is an integer. > Is there any way to add a cast in the subquery, or select column as an > integer? > > The new versions of Postgresql strongly enforce types and won't let you > compare integer to character varying. > > Any thoughts? > Thanks > > -- > Sheldon Ross > Software Development > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: nrice@example.net > For additional commands, e-mail: nrice@example.net > --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Tue Oct 20 08:28:47 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 51199 invoked from network); 20 Oct 2009 08:28:47 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 20 Oct 2009 08:28:47 -0000 Received: (qmail 29268 invoked by uid 500); 20 Oct 2009 08:28:47 -0000 Delivered-To: nrice@example.net Received: (qmail 29195 invoked by uid 500); 20 Oct 2009 08:28:46 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 29185 invoked by uid 99); 20 Oct 2009 08:28:46 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Oct 2009 08:28:46 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=BAYES_00 X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [83.161.120.155] (HELO email.internection.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Oct 2009 08:28:43 +0000 Received: from localhost (localhost [83.161.120.155]) by email.internection.com (Postfix) with ESMTP id 96872B9800E for <nrice@example.net>; Tue, 20 Oct 2009 03:24:55 -0500 (CDT) X-Virus-Scanned: Debian nrice@example.net Received: from email.internection.com ([83.161.120.155]) by localhost (email.internection.com [83.161.120.155]) (amavisd-new, port 10024) with ESMTP id jpEhFPJcTdHu for <nrice@example.net>; Tue, 20 Oct 2009 03:24:47 -0500 (CDT) Received: from [83.161.120.155] (c-68-48-87-28.hsd1.dc.comcast.net [83.161.120.155]) (Authenticated sender: nrice@example.net) by email.internection.com (Postfix) with ESMTPSA id 4CDFE10DBEC for <nrice@example.net>; Tue, 20 Oct 2009 03:24:47 -0500 (CDT) From: Jon August <nrice@example.net> Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Subject: maven torque:insert-sql fails: org/apache/tools/ant/PropertyHelper Date: Tue, 20 Oct 2009 04:28:13 -0400 Message-Id: <nrice@example.net> To: nrice@example.net Mime-Version: 1.0 (Apple Message framework v1076) X-Mailer: Apple Mail (2.1076) I moved to a new development machine and having some trouble getting back to normal here... Got everything working up until the maven torque:insert-sql I get this: __ __ | \/ |__ _Apache__ ___ | |\/| / _` \ V / -_) ' \ ~ intelligent projects ~ |_| |_\__,_|\_/\___|_||_| v. 1.0.2 Our new url -> jdbc:mysql://localhost/bizdirectory Executing file: /Users/jon/Documents/workspace/BizDirectory/target/sql/ id-table-schema.sql BUILD FAILED File...... /Users/jon/.maven/cache/maven-torque-plugin-3.3/plugin.jelly Element... torque-sql-exec Line...... 542 Column.... 40 org/apache/tools/ant/PropertyHelper Total time: 1 seconds Finished at: Tue Oct 20 04:19:25 EDT 2009 Thanks for the help. -Jon --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Tue Oct 20 20:00:32 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 86165 invoked from network); 20 Oct 2009 20:00:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 20 Oct 2009 20:00:31 -0000 Received: (qmail 10914 invoked by uid 500); 20 Oct 2009 20:00:31 -0000 Delivered-To: nrice@example.net Received: (qmail 10861 invoked by uid 500); 20 Oct 2009 20:00:30 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 10850 invoked by uid 99); 20 Oct 2009 20:00:30 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Oct 2009 20:00:30 +0000 X-ASF-Spam-Status: No, hits=-2.0 required=5.0 tests=AWL,BAYES_00 X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [83.161.120.155] (HELO outmail128173.authsmtp.co.uk) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Oct 2009 20:00:28 +0000 Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [83.161.120.155]) by punt8.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n9KK06K6099832 for <nrice@example.net>; Tue, 20 Oct 2009 21:00:06 +0100 (BST) Received: from parzival.fritz.box (p5B281348.dip0.t-ipconnect.de [83.161.120.155]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n9KJxxki068828 for <nrice@example.net>; Tue, 20 Oct 2009 21:00:00 +0100 (BST) Message-ID: <nrice@example.net> Date: Tue, 20 Oct 2009 22:00:01 +0200 From: Thomas Vandahl <nrice@example.net> User-Agent: Thunderbird 83.161.120.155 (Macintosh/20090812) MIME-Version: 1.0 To: Apache Torque Users List <nrice@example.net> Subject: Re: maven torque:insert-sql fails: org/apache/tools/ant/PropertyHelper References: <nrice@example.net> In-Reply-To: <nrice@example.net> X-Enigmail-Version: 0.96.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Server-Quench: 25fdcf7c-bdb3-11de-90cd-002264978518 X-Report-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyaAgQClZJUiwT EioPDCIGTh8qMAFL GwYeIE5HO1cTfQhb dE9CJ1FTPRsbX15P AWYUJAcQT19xWWpl aQtbbQVXYkoAVgR0 VEhXQ1tMEwd3AxkD AwEeHEd7DH8OMCUp ZUBqVnJTEkx4fAh/ RxgARjsBNnoyPDIc TUFZI1ZJeQMZKgJF alJ9UncEZm0CZ3Iu JQJhdzU4IzhZYDhS WBgQIAATR10GBCJ5 XAkGVTsmHEkeFW00 NRNhI0YVF0YcdVk1 Nl86HlseL1gqEApG EltREQ9UI0EMXUIA X-Authentic-SMTP: 61633138303539.1014:706/Kp X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system. Jon August wrote: > I moved to a new development machine and having some trouble getting > back to normal here... > > org/apache/tools/ant/PropertyHelper Looks like a ClassNotFoundException. Which versions of ANT do you have in your classpath? Bye, Thomas. --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Tue Oct 20 20:07:27 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 87612 invoked from network); 20 Oct 2009 20:07:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 20 Oct 2009 20:07:26 -0000 Received: (qmail 24344 invoked by uid 500); 20 Oct 2009 20:07:26 -0000 Delivered-To: nrice@example.net Received: (qmail 24320 invoked by uid 500); 20 Oct 2009 20:07:26 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 24310 invoked by uid 99); 20 Oct 2009 20:07:26 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Oct 2009 20:07:26 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=BAYES_00 X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [83.161.120.155] (HELO email.internection.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Oct 2009 20:07:24 +0000 Received: from localhost (localhost [83.161.120.155]) by email.internection.com (Postfix) with ESMTP id 189D1B98031 for <nrice@example.net>; Tue, 20 Oct 2009 15:03:36 -0500 (CDT) X-Virus-Scanned: Debian nrice@example.net Received: from email.internection.com ([83.161.120.155]) by localhost (email.internection.com [83.161.120.155]) (amavisd-new, port 10024) with ESMTP id OahLXtV7ABj5 for <nrice@example.net>; Tue, 20 Oct 2009 15:03:19 -0500 (CDT) Received: from [83.161.120.155] (c-68-48-87-28.hsd1.dc.comcast.net [83.161.120.155]) (Authenticated sender: nrice@example.net) by email.internection.com (Postfix) with ESMTPSA id AB46BB98001 for <nrice@example.net>; Tue, 20 Oct 2009 15:03:18 -0500 (CDT) Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes Mime-Version: 1.0 (Apple Message framework v1076) Subject: Re: maven torque:insert-sql fails: org/apache/tools/ant/PropertyHelper From: Jon August <nrice@example.net> In-Reply-To: <nrice@example.net> Date: Tue, 20 Oct 2009 16:06:45 -0400 Content-Transfer-Encoding: 7bit Message-Id: <nrice@example.net> References: <nrice@example.net> <nrice@example.net> To: "Apache Torque Users List" <nrice@example.net> X-Mailer: Apple Mail (2.1076) I don't remember setting the classpath before to use torque. My shell's classpath is empty. I use Eclipse to link libraries and compile... The version of ant maven is calling is this: jon$ ant -v Apache Ant version 1.7.0 compiled on July 20 2009 On Oct 20, 2009, at 4:00 PM, Thomas Vandahl wrote: > Jon August wrote: >> I moved to a new development machine and having some trouble getting >> back to normal here... >> >> org/apache/tools/ant/PropertyHelper > > Looks like a ClassNotFoundException. Which versions of ANT do you have > in your classpath? > > Bye, Thomas. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: nrice@example.net > For additional commands, e-mail: nrice@example.net > --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Tue Oct 20 20:14:01 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 89833 invoked from network); 20 Oct 2009 20:14:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 20 Oct 2009 20:14:01 -0000 Received: (qmail 34454 invoked by uid 500); 20 Oct 2009 20:14:01 -0000 Delivered-To: nrice@example.net Received: (qmail 34416 invoked by uid 500); 20 Oct 2009 20:14:01 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 34406 invoked by uid 99); 20 Oct 2009 20:14:01 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Oct 2009 20:14:01 +0000 X-ASF-Spam-Status: No, hits=-2.0 required=5.0 tests=AWL,BAYES_00,FB_WORD1_END_DOLLAR X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [83.161.120.155] (HELO outmail136040.authsmtp.co.uk) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Oct 2009 20:13:59 +0000 Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [83.161.120.155]) by punt9.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n9KKDbO4052800 for <nrice@example.net>; Tue, 20 Oct 2009 21:13:37 +0100 (BST) Received: from parzival.fritz.box (p5B281348.dip0.t-ipconnect.de [83.161.120.155]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n9KKDZfV078194 for <nrice@example.net>; Tue, 20 Oct 2009 21:13:35 +0100 (BST) Message-ID: <nrice@example.net> Date: Tue, 20 Oct 2009 22:13:37 +0200 From: Thomas Vandahl <nrice@example.net> User-Agent: Thunderbird 83.161.120.155 (Macintosh/20090812) MIME-Version: 1.0 To: Apache Torque Users List <nrice@example.net> Subject: Re: maven torque:insert-sql fails: org/apache/tools/ant/PropertyHelper References: <nrice@example.net> <nrice@example.net> <nrice@example.net> In-Reply-To: <nrice@example.net> X-Enigmail-Version: 0.96.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Server-Quench: 0c404402-bdb5-11de-90cd-002264978518 X-Report-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyaAgQClZJUiwT EioPDCIGTh8qMAFL GwYeIE5HO1cTfQhb dE9CJ1FTPRsbX15P AWYUJAcQT19xWWpl aQtbbAZXYU8AVgR0 VEhXQ1tMEwd3AxkD AwEeHEd7DH4yEigW ZUFqX3lfEkV6cE8z Qh1QFWkCZWV9OjRN VV1ZdlcBbQpKLUtY alB9VnUJaGIPY3to CTU+bXg0NCtSLmxJ RRsUMF9AQEAQEyQg AgsbGX0hFEwBXHd7 KAYpbVcEFU0RPwIu NlwlQhURNQNVMhdZ B0xXHD55Kl0ZSjBD X-Authentic-SMTP: 61633138303539.1014:706/Kp Jon August wrote: > I don't remember setting the classpath before to use torque. > > My shell's classpath is empty. I use Eclipse to link libraries and > compile... > > The version of ant maven is calling is this: > > jon$ ant -v > Apache Ant version 1.7.0 compiled on July 20 2009 I dimly remember version conflicts when seeing this class reference. What does "maven -e ..." tell you? Bye, Thomas --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Tue Oct 20 20:33:52 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 96231 invoked from network); 20 Oct 2009 20:33:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 20 Oct 2009 20:33:52 -0000 Received: (qmail 77761 invoked by uid 500); 20 Oct 2009 20:33:52 -0000 Delivered-To: nrice@example.net Received: (qmail 77737 invoked by uid 500); 20 Oct 2009 20:33:52 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 77727 invoked by uid 99); 20 Oct 2009 20:33:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Oct 2009 20:33:52 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FB_WORD1_END_DOLLAR,HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [83.161.120.155] (HELO email.internection.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Oct 2009 20:33:42 +0000 Received: from localhost (localhost [83.161.120.155]) by email.internection.com (Postfix) with ESMTP id EB724B9802D for <nrice@example.net>; Tue, 20 Oct 2009 15:29:52 -0500 (CDT) X-Virus-Scanned: Debian nrice@example.net Received: from email.internection.com ([83.161.120.155]) by localhost (email.internection.com [83.161.120.155]) (amavisd-new, port 10024) with ESMTP id uIDJ8FcV2HAG for <nrice@example.net>; Tue, 20 Oct 2009 15:29:44 -0500 (CDT) Received: from [83.161.120.155] (c-68-48-87-28.hsd1.dc.comcast.net [83.161.120.155]) (Authenticated sender: nrice@example.net) by email.internection.com (Postfix) with ESMTPSA id A8F37B98001 for <nrice@example.net>; Tue, 20 Oct 2009 15:29:40 -0500 (CDT) From: Jon August <nrice@example.net> Mime-Version: 1.0 (Apple Message framework v1076) Content-Type: multipart/alternative; boundary=Apple-Mail-30-738196832 Subject: Re: maven torque:insert-sql fails: org/apache/tools/ant/PropertyHelper Date: Tue, 20 Oct 2009 16:33:07 -0400 In-Reply-To: <nrice@example.net> To: "Apache Torque Users List" <nrice@example.net> References: <nrice@example.net> <nrice@example.net> <nrice@example.net> <nrice@example.net> Message-Id: <nrice@example.net> X-Mailer: Apple Mail (2.1076) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-30-738196832 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes Hmm - how do I make sure it has access to PropertyHelper? Thank you for your help. -Jon jon$ maven -e torque:insert-sql __ __ | \/ |__ _Apache__ ___ | |\/| / _` \ V / -_) ' \ ~ intelligent projects ~ |_| |_\__,_|\_/\___|_||_| v. 1.0.2 Our new url -> jdbc:mysql://localhost/bizdirectory Executing file: /Users/jon/Documents/workspace/BizDirectory/target/sql/ id-table-schema.sql BUILD FAILED java.lang.NoClassDefFoundError: nrice@example.net (TorqueSQLExec.java:657) at org.apache.torque.task.TorqueSQLExec$Transaction.runTransaction (TorqueSQLExec.java:928) at org.apache.torque.task.TorqueSQLExec$Transaction.access$000 (TorqueSQLExec.java:898) at org.apache.torque.task.TorqueSQLExec.insertDatabaseSqlFiles (TorqueSQLExec.java:573) at org.apache.torque.task.TorqueSQLExec.execute(TorqueSQLExec.java:482) at org.apache.tools.ant.Task.perform(Task.java:341) at org.apache.commons.jelly.tags.ant.AntTag.doTag(AntTag.java:185) at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279) at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135) at org.apache.maven.jelly.tags.werkz.MavenGoalTag.runBodyTag (MavenGoalTag.java:79) at org.apache.maven.jelly.tags.werkz.MavenGoalTag $MavenGoalAction.performAction(MavenGoalTag.java:110) at com.werken.werkz.Goal.fire(Goal.java:639) at com.werken.werkz.Goal.attain(Goal.java:575) at org.apache.maven.plugin.PluginManager.attainGoals (PluginManager.java:671) at org.apache.maven.MavenSession.attainGoals(MavenSession.java:263) at org.apache.maven.cli.App.doMain(App.java:488) at org.apache.maven.cli.App.main(App.java:1239) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.werken.forehead.Forehead.run(Forehead.java:551) at com.werken.forehead.Forehead.main(Forehead.java:581) Caused by: java.lang.ClassNotFoundException: nrice@example.net (AntClassLoader.java:1075) at org.apache.tools.ant.AntClassLoader.findClass(AntClassLoader.java: 1036) at org.apache.tools.ant.AntClassLoader.loadClass(AntClassLoader.java: 925) at java.lang.ClassLoader.loadClass(ClassLoader.java:254) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:399) ... 23 more File...... /Users/jon/.maven/cache/maven-torque-plugin-3.3/plugin.jelly Element... torque-sql-exec Line...... 542 Column.... 40 org/apache/tools/ant/PropertyHelper Total time: 1 seconds Finished at: Tue Oct 20 16:30:40 EDT 2009 On Oct 20, 2009, at 4:13 PM, Thomas Vandahl wrote: > Jon August wrote: >> I don't remember setting the classpath before to use torque. >> >> My shell's classpath is empty. I use Eclipse to link libraries and >> compile... >> >> The version of ant maven is calling is this: >> >> jon$ ant -v >> Apache Ant version 1.7.0 compiled on July 20 2009 > > I dimly remember version conflicts when seeing this class reference. > What does "maven -e ..." tell you? > > Bye, Thomas > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: nrice@example.net > For additional commands, e-mail: nrice@example.net > --Apple-Mail-30-738196832-- From torquenrice@example.net Wed Oct 21 21:41:19 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 44145 invoked from network); 21 Oct 2009 21:41:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 21 Oct 2009 21:41:19 -0000 Received: (qmail 55901 invoked by uid 500); 21 Oct 2009 21:41:19 -0000 Delivered-To: nrice@example.net Received: (qmail 55869 invoked by uid 500); 21 Oct 2009 21:41:18 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 55859 invoked by uid 99); 21 Oct 2009 21:41:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Oct 2009 21:41:18 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=BAYES_00 X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: 83.161.120.155 is neither permitted nor denied by domain of nrice@example.net) Received: from [83.161.120.155] (HELO vps.cogentisolution.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Oct 2009 21:41:15 +0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=simmgene.com; h=Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding:X-Source:X-Source-Args:X-Source-Dir; b=iSswqYEmsPVj9FQ3TtvEs2xUpmZLkg+2WZyqvTweGZYyd70BOlRhg2VKBH4XATbTATzA3fXEh6d7+R/29Yw9b8pSSMfmjYiemhfZCL6VThP+09S3Y1pdHltSyrtrIfLJ; Received: from [83.161.120.155] (helo=[83.161.120.155]) by vps.cogentisolution.com with esmtpa (Exim 4.69) (envelope-from <nrice@example.net>) id 1N0ivM-00031B-U3 for nrice@example.net; Wed, 21 Oct 2009 21:40:53 +0000 Message-ID: <nrice@example.net> Date: Wed, 21 Oct 2009 15:43:22 -0600 From: Sheldon Ross <nrice@example.net> User-Agent: Thunderbird 83.161.120.155 (X11/20090817) MIME-Version: 1.0 To: Apache Torque Users List <nrice@example.net> Subject: QueryDataSet constructing takes forever Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - vps.cogentisolution.com X-AntiAbuse: Original Domain - db.apache.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - simmgene.com X-Source: X-Source-Args: X-Source-Dir: Hello, The following code produces some interesting results in my system. connection = Torque.getConnection(Torque.getDefaultDB()); PreparedStatement statement = connection.prepareStatement(dynamicQuery); ResultSet set = statement.executeQuery(); long startTime = System.currentTimeMillis(); QueryDataSet dataSet = new QueryDataSet(set); log.debug("DDAElapsed time="+ (System.currentTimeMillis() - startTime) + " ms"); return BasePeer.getSelectResults(dataSet); The actual elapsed time of the query is very small, but it seems to take a very long time to create the querydataset. 2009-10-21 15:37:06,969 [TP-Processor3] DEBUG org.simmental.datamods.utils.DirectDataAccessor - DDAElapsed time=133 ms 2009-10-21 15:37:06,970 [TP-Processor3] DEBUG org.simmental.datamods.om.AnmId - Elapsed time=140 ms The last is the total elapsed time, so It appears to me like it is taking ~ 7ms to do the query, but ~133 ms to construct the querydataset. Anyone experience anything like this? Thanks -- Sheldon Ross Software Development --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Thu Oct 22 05:07:07 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 63210 invoked from network); 22 Oct 2009 05:07:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 22 Oct 2009 05:07:07 -0000 Received: (qmail 20642 invoked by uid 500); 22 Oct 2009 05:07:07 -0000 Delivered-To: nrice@example.net Received: (qmail 20557 invoked by uid 500); 22 Oct 2009 05:07:06 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 20547 invoked by uid 99); 22 Oct 2009 05:07:06 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Oct 2009 05:07:06 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=AWL,BAYES_00,FB_WORD1_END_DOLLAR,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [83.161.120.155] (HELO email.internection.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Oct 2009 05:07:03 +0000 Received: from localhost (localhost [83.161.120.155]) by email.internection.com (Postfix) with ESMTP id 1F269B980E4 for <nrice@example.net>; Thu, 22 Oct 2009 00:03:14 -0500 (CDT) X-Virus-Scanned: Debian nrice@example.net Received: from email.internection.com ([83.161.120.155]) by localhost (email.internection.com [83.161.120.155]) (amavisd-new, port 10024) with ESMTP id KGocur+sG0fM for <nrice@example.net>; Thu, 22 Oct 2009 00:03:02 -0500 (CDT) Received: from [83.161.120.155] (c-68-48-87-28.hsd1.dc.comcast.net [83.161.120.155]) (Authenticated sender: nrice@example.net) by email.internection.com (Postfix) with ESMTPSA id 4886AB980E7 for <nrice@example.net>; Thu, 22 Oct 2009 00:02:54 -0500 (CDT) From: Jon August <nrice@example.net> Mime-Version: 1.0 (Apple Message framework v1076) Content-Type: multipart/alternative; boundary=Apple-Mail-38-855390741 Subject: Re: maven torque:insert-sql fails: org/apache/tools/ant/PropertyHelper Date: Thu, 22 Oct 2009 01:06:21 -0400 In-Reply-To: <nrice@example.net> To: "Apache Torque Users List" <nrice@example.net> References: <nrice@example.net> <nrice@example.net> <nrice@example.net> <nrice@example.net> <nrice@example.net> Message-Id: <nrice@example.net> X-Mailer: Apple Mail (2.1076) --Apple-Mail-38-855390741 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes I'm really stuck on this. Clearly from the NoClassDefFound error below in my last message, you would assume maven can't find ant... BUT, here it is in the local maven repository: Mac:jars jon$ ls -al total 2528 drwxr-xr-x 4 jon staff 136 Oct 20 04:09 . drwxr-xr-x 3 jon staff 102 Oct 20 04:09 .. -rw-r--r-- 1 jon staff 1289806 Oct 20 04:09 ant-1.7.0.jar -rw-r--r-- 1 jon staff 75 Oct 20 04:09 ant-1.7.0.jar.md5 Mac:jars jon$ pwd /Users/jon/.maven/repository/org.apache.ant/jars AND, here it is in the path: Mac:BizDirectory jon$ echo $PATH /usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin:/usr/local/ maven-1.0.2/bin:/usr/local/apache-ant-1.7.0/bin:/Applications/ Mkvtoolnix.app/Contents/MacOS/ AND, the library: Mac:BizDirectory jon$ cd /usr/local/apache-ant-1.7.0/lib Mac:lib jon$ ls -al ant.jar -rw-r--r--@ 1 jon staff 1289806 Dec 13 2006 ant.jar Mac:lib jon$ jar -tvf ant.jar |grep PropertyHelper 7526 Wed Dec 13 07:15:02 EST 2006 org/apache/tools/ant/ PropertyHelper.class It's in the repository IT created! Why wouldn't it be able to find that class? Any help is appreciated. I'm ready to jump ship and try something else. -Jon On Oct 20, 2009, at 4:33 PM, Jon August wrote: > Hmm - how do I make sure it has access to PropertyHelper? > > Thank you for your help. > > -Jon > > > jon$ maven -e torque:insert-sql > __ __ > | \/ |__ _Apache__ ___ > | |\/| / _` \ V / -_) ' \ ~ intelligent projects ~ > |_| |_\__,_|\_/\___|_||_| v. 1.0.2 > > Our new url -> jdbc:mysql://localhost/bizdirectory > Executing file: /Users/jon/Documents/workspace/BizDirectory/target/ > sql/id-table-schema.sql > > BUILD FAILED > java.lang.NoClassDefFoundError: org/apache/tools/ant/PropertyHelper > at org.apache.torque.task.TorqueSQLExec.runStatements > (TorqueSQLExec.java:657) > at org.apache.torque.task.TorqueSQLExec$Transaction.runTransaction > (TorqueSQLExec.java:928) > at org.apache.torque.task.TorqueSQLExec$Transaction.access$000 > (TorqueSQLExec.java:898) > at org.apache.torque.task.TorqueSQLExec.insertDatabaseSqlFiles > (TorqueSQLExec.java:573) > at org.apache.torque.task.TorqueSQLExec.execute(TorqueSQLExec.java: > 482) > at org.apache.tools.ant.Task.perform(Task.java:341) > at org.apache.commons.jelly.tags.ant.AntTag.doTag(AntTag.java:185) > at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279) > at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java: > 135) > at org.apache.maven.jelly.tags.werkz.MavenGoalTag.runBodyTag > (MavenGoalTag.java:79) > at org.apache.maven.jelly.tags.werkz.MavenGoalTag > $MavenGoalAction.performAction(MavenGoalTag.java:110) > at com.werken.werkz.Goal.fire(Goal.java:639) > at com.werken.werkz.Goal.attain(Goal.java:575) > at org.apache.maven.plugin.PluginManager.attainGoals > (PluginManager.java:671) > at org.apache.maven.MavenSession.attainGoals(MavenSession.java:263) > at org.apache.maven.cli.App.doMain(App.java:488) > at org.apache.maven.cli.App.main(App.java:1239) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke > (NativeMethodAccessorImpl.java:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke > (DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at com.werken.forehead.Forehead.run(Forehead.java:551) > at com.werken.forehead.Forehead.main(Forehead.java:581) > Caused by: java.lang.ClassNotFoundException: > org.apache.tools.ant.PropertyHelper > at org.apache.tools.ant.AntClassLoader.findClassInComponents > (AntClassLoader.java:1075) > at org.apache.tools.ant.AntClassLoader.findClass > (AntClassLoader.java:1036) > at org.apache.tools.ant.AntClassLoader.loadClass > (AntClassLoader.java:925) > at java.lang.ClassLoader.loadClass(ClassLoader.java:254) > at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:399) > ... 23 more > File...... /Users/jon/.maven/cache/maven-torque-plugin-3.3/ > plugin.jelly > Element... torque-sql-exec > Line...... 542 > Column.... 40 > org/apache/tools/ant/PropertyHelper > Total time: 1 seconds > Finished at: Tue Oct 20 16:30:40 EDT 2009 > > > > > On Oct 20, 2009, at 4:13 PM, Thomas Vandahl wrote: > >> Jon August wrote: >>> I don't remember setting the classpath before to use torque. >>> >>> My shell's classpath is empty. I use Eclipse to link libraries and >>> compile... >>> >>> The version of ant maven is calling is this: >>> >>> jon$ ant -v >>> Apache Ant version 1.7.0 compiled on July 20 2009 >> >> I dimly remember version conflicts when seeing this class reference. >> What does "maven -e ..." tell you? >> >> Bye, Thomas >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: nrice@example.net >> For additional commands, e-mail: nrice@example.net >> > --Apple-Mail-38-855390741-- From torquenrice@example.net Thu Oct 22 06:32:17 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 81591 invoked from network); 22 Oct 2009 06:32:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 22 Oct 2009 06:32:16 -0000 Received: (qmail 70471 invoked by uid 500); 22 Oct 2009 06:32:16 -0000 Delivered-To: nrice@example.net Received: (qmail 70416 invoked by uid 500); 22 Oct 2009 06:32:16 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 70406 invoked by uid 99); 22 Oct 2009 06:32:16 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Oct 2009 06:32:16 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [83.161.120.155] (HELO mail.seitenbau.net) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Oct 2009 06:32:08 +0000 Received: from [83.161.120.155] (helo=www.seitenbau.net) by router.seitenbau.net with esmtp (Exim 4.43) id 1N0rQh-0007ig-1S for nrice@example.net; Thu, 22 Oct 2009 08:45:48 +0200 In-Reply-To: <nrice@example.net> References: <nrice@example.net> Subject: RE: QueryDataSet constructing takes forever X-KeepSent: 5882AB91:CCCD41BA-C1257657:00235623; type=4; name=$KeepSent To: "Apache Torque Users List" <nrice@example.net> X-Mailer: Lotus Notes Release 8.5 December 05, 2008 Message-ID: <nrice@example.net> From: Thomas Fischer <nrice@example.net> Date: Thu, 22 Oct 2009 08:31:46 +0200 X-MIMETrack: Serialize by Router on www/seitenbau(Release 8.5HF467 | May 15, 2009) at 22.10.2009 08:31:46 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Spam-Score: -1.3 (-) X-Spam-Report: 0.2 SARE_SUB_FOREVER subject has likely spammer phrase or word -1.4 ALL_TRUSTED Passed through trusted hosts only via SMTP X-Virus-Checked: Checked by ClamAV on apache.org > The following code produces some interesting results in my system. > > connection = Torque.getConnection(Torque.getDefaultDB()); > PreparedStatement statement = > connection.prepareStatement(dynamicQuery); > ResultSet set = statement.executeQuery(); > long startTime = System.currentTimeMillis(); > QueryDataSet dataSet = new QueryDataSet(set); > log.debug("DDAElapsed time="+ (System.currentTimeMillis() - > startTime) + " ms"); > return BasePeer.getSelectResults(dataSet); > > The actual elapsed time of the query is very small, but it seems to take > a very long time to create the querydataset. > > 2009-10-21 15:37:06,969 [TP-Processor3] DEBUG > org.simmental.datamods.utils.DirectDataAccessor - DDAElapsed time=133 ms > 2009-10-21 15:37:06,970 [TP-Processor3] DEBUG > org.simmental.datamods.om.AnmId - Elapsed time=140 ms > > The last is the total elapsed time, so It appears to me like it is > taking ~ 7ms to do the query, but ~133 ms to construct the querydataset. I have no idea how large your result set is, nor how the database driver for your database handles this internally. The data is actually read by java while iterating over the result set, i.e. while constructing the QDS. No idea whether the db driver has the result set buffered or whether the data is fetched "live" from the db. In the latter case, a large data set plus a reasonably slow network can easily produce this result. You can check the QueryDataset code by iterating over the result set and reading the data manually, and then compare the execution times. Thomas --------------------------------------------------------------------- To unsubscribe, e-mail: nrice@example.net For additional commands, e-mail: nrice@example.net From torquenrice@example.net Thu Oct 22 07:37:02 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 15680 invoked from network); 22 Oct 2009 07:37:02 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 22 Oct 2009 07:37:02 -0000 Received: (qmail 38963 invoked by uid 500); 22 Oct 2009 07:37:02 -0000 Delivered-To: nrice@example.net Received: (qmail 38919 invoked by uid 500); 22 Oct 2009 07:37:01 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 38909 invoked by uid 99); 22 Oct 2009 07:37:01 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Oct 2009 07:37:01 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=AWL,BAYES_00,FB_WORD1_END_DOLLAR,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [83.161.120.155] (HELO email.internection.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Oct 2009 07:36:58 +0000 Received: from localhost (localhost [83.161.120.155]) by email.internection.com (Postfix) with ESMTP id 2FA03B98030 for <nrice@example.net>; Thu, 22 Oct 2009 02:33:09 -0500 (CDT) X-Virus-Scanned: Debian nrice@example.net Received: from email.internection.com ([83.161.120.155]) by localhost (email.internection.com [83.161.120.155]) (amavisd-new, port 10024) with ESMTP id 2XRk2EjXsKq0 for <nrice@example.net>; Thu, 22 Oct 2009 02:32:58 -0500 (CDT) Received: from [83.161.120.155] (c-68-48-87-28.hsd1.dc.comcast.net [83.161.120.155]) (Authenticated sender: nrice@example.net) by email.internection.com (Postfix) with ESMTPSA id 2E923B980E0 for <nrice@example.net>; Thu, 22 Oct 2009 02:32:57 -0500 (CDT) From: Jon August <nrice@example.net> Mime-Version: 1.0 (Apple Message framework v1076) Content-Type: multipart/alternative; boundary=Apple-Mail-39-864394020 Subject: Re: maven torque:insert-sql fails: org/apache/tools/ant/PropertyHelper Date: Thu, 22 Oct 2009 03:36:24 -0400 In-Reply-To: <nrice@example.net> To: "Apache Torque Users List" <nrice@example.net> References: <nrice@example.net> <nrice@example.net> <nrice@example.net> <nrice@example.net> <nrice@example.net> <nrice@example.net> Message-Id: <nrice@example.net> X-Mailer: Apple Mail (2.1076) --Apple-Mail-39-864394020 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes I had followed the directions for 3.3, but when I do this: maven plugin:download -DartifactId=maven-torque-plugin - DgroupId=torque -Dversion=3.2 everything works fine... Something wrong with 3.3? On Oct 22, 2009, at 1:06 AM, Jon August wrote: > I'm really stuck on this. Clearly from the NoClassDefFound error > below in my last message, you would assume maven can't find ant... > > BUT, here it is in the local maven repository: > Mac:jars jon$ ls -al > total 2528 > drwxr-xr-x 4 jon staff 136 Oct 20 04:09 . > drwxr-xr-x 3 jon staff 102 Oct 20 04:09 .. > -rw-r--r-- 1 jon staff 1289806 Oct 20 04:09 ant-1.7.0.jar > -rw-r--r-- 1 jon staff 75 Oct 20 04:09 ant-1.7.0.jar.md5 > > Mac:jars jon$ pwd > /Users/jon/.maven/repository/org.apache.ant/jars > > AND, here it is in the path: > Mac:BizDirectory jon$ echo $PATH > /usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin:/usr/local/ > maven-1.0.2/bin:/usr/local/apache-ant-1.7.0/bin:/Applications/ > Mkvtoolnix.app/Contents/MacOS/ > > AND, the library: > Mac:BizDirectory jon$ cd /usr/local/apache-ant-1.7.0/lib > > Mac:lib jon$ ls -al ant.jar > -rw-r--r--@ 1 jon staff 1289806 Dec 13 2006 ant.jar > > Mac:lib jon$ jar -tvf ant.jar |grep PropertyHelper > 7526 Wed Dec 13 07:15:02 EST 2006 org/apache/tools/ant/ > PropertyHelper.class > > It's in the repository IT created! Why wouldn't it be able to find > that class? > > Any help is appreciated. I'm ready to jump ship and try something > else. > > -Jon > > > > > > > > > > On Oct 20, 2009, at 4:33 PM, Jon August wrote: > >> Hmm - how do I make sure it has access to PropertyHelper? >> >> Thank you for your help. >> >> -Jon >> >> >> jon$ maven -e torque:insert-sql >> __ __ >> | \/ |__ _Apache__ ___ >> | |\/| / _` \ V / -_) ' \ ~ intelligent projects ~ >> |_| |_\__,_|\_/\___|_||_| v. 1.0.2 >> >> Our new url -> jdbc:mysql://localhost/bizdirectory >> Executing file: /Users/jon/Documents/workspace/BizDirectory/target/ >> sql/id-table-schema.sql >> >> BUILD FAILED >> java.lang.NoClassDefFoundError: org/apache/tools/ant/PropertyHelper >> at org.apache.torque.task.TorqueSQLExec.runStatements >> (TorqueSQLExec.java:657) >> at org.apache.torque.task.TorqueSQLExec$Transaction.runTransaction >> (TorqueSQLExec.java:928) >> at org.apache.torque.task.TorqueSQLExec$Transaction.access$000 >> (TorqueSQLExec.java:898) >> at org.apache.torque.task.TorqueSQLExec.insertDatabaseSqlFiles >> (TorqueSQLExec.java:573) >> at org.apache.torque.task.TorqueSQLExec.execute(TorqueSQLExec.java: >> 482) >> at org.apache.tools.ant.Task.perform(Task.java:341) >> at org.apache.commons.jelly.tags.ant.AntTag.doTag(AntTag.java:185) >> at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279) >> at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java: >> 135) >> at org.apache.maven.jelly.tags.werkz.MavenGoalTag.runBodyTag >> (MavenGoalTag.java:79) >> at org.apache.maven.jelly.tags.werkz.MavenGoalTag >> $MavenGoalAction.performAction(MavenGoalTag.java:110) >> at com.werken.werkz.Goal.fire(Goal.java:639) >> at com.werken.werkz.Goal.attain(Goal.java:575) >> at org.apache.maven.plugin.PluginManager.attainGoals >> (PluginManager.java:671) >> at org.apache.maven.MavenSession.attainGoals(MavenSession.java:263) >> at org.apache.maven.cli.App.doMain(App.java:488) >> at org.apache.maven.cli.App.main(App.java:1239) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at sun.reflect.NativeMethodAccessorImpl.invoke >> (NativeMethodAccessorImpl.java:39) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke >> (DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at com.werken.forehead.Forehead.run(Forehead.java:551) >> at com.werken.forehead.Forehead.main(Forehead.java:581) >> Caused by: java.lang.ClassNotFoundException: >> org.apache.tools.ant.PropertyHelper >> at org.apache.tools.ant.AntClassLoader.findClassInComponents >> (AntClassLoader.java:1075) >> at org.apache.tools.ant.AntClassLoader.findClass >> (AntClassLoader.java:1036) >> at org.apache.tools.ant.AntClassLoader.loadClass >> (AntClassLoader.java:925) >> at java.lang.ClassLoader.loadClass(ClassLoader.java:254) >> at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:399) >> ... 23 more >> File...... /Users/jon/.maven/cache/maven-torque-plugin-3.3/ >> plugin.jelly >> Element... torque-sql-exec >> Line...... 542 >> Column.... 40 >> org/apache/tools/ant/PropertyHelper >> Total time: 1 seconds >> Finished at: Tue Oct 20 16:30:40 EDT 2009 >> >> >> >> >> On Oct 20, 2009, at 4:13 PM, Thomas Vandahl wrote: >> >>> Jon August wrote: >>>> I don't remember setting the classpath before to use torque. >>>> >>>> My shell's classpath is empty. I use Eclipse to link libraries and >>>> compile... >>>> >>>> The version of ant maven is calling is this: >>>> >>>> jon$ ant -v >>>> Apache Ant version 1.7.0 compiled on July 20 2009 >>> >>> I dimly remember version conflicts when seeing this class reference. >>> What does "maven -e ..." tell you? >>> >>> Bye, Thomas >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: nrice@example.net >>> For additional commands, e-mail: nrice@example.net >>> >> > --Apple-Mail-39-864394020-- From torquenrice@example.net Thu Oct 22 12:00:51 2009 Return-Path: <torquenrice@example.net> Delivered-To: nrice@example.net Received: (qmail 81762 invoked from network); 22 Oct 2009 12:00:51 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 22 Oct 2009 12:00:51 -0000 Received: (qmail 50188 invoked by uid 500); 22 Oct 2009 12:00:51 -0000 Delivered-To: nrice@example.net Received: (qmail 50139 invoked by uid 500); 22 Oct 2009 12:00:50 -0000 Mailing-List: contact nrice@example.net; run by ezmlm Precedence: bulk List-Unsubscribe: <mailto:nrice@example.net> List-Help: <mailto:nrice@example.net> List-Post: <mailto:nrice@example.net> List-Id: "Apache Torque Users List" <torque-user.db.apache.org> Reply-To: "Apache Torque Users List" <nrice@example.net> Delivered-To: mailing list nrice@example.net Received: (qmail 50129 invoked by uid 99); 22 Oct 2009 12:00:50 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Oct 2009 12:00:50 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FB_WORD1_END_DOLLAR,HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [83.161.120.155] (HELO web50802.mail.re2.yahoo.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 22 Oct 2009 12:00:40 +0000 Received: (qmail 12272 invoked by uid 60001); 22 Oct 2009 12:00:17 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1256212812; bh=0WKOzTPOCyndDykpRWGw0a8T4kNdqy340UEdNBIfEgY=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=ldxbHXdw6zZnL9Q8HrPlps4QAxXuBHTisAIlvmQArtJijZ/pM82mAlRwFAZxzu1sMnDkWM0Uiz+ISJpXH+NarA86OSmNTJNw8gyI371sdJIbqZENHEWepWRZQnZnfltZxQUtm3N+ZzseLN0h7XKmT1h0Ft8bkvaokiosp3Cp2tM= DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=fVvG927P0CA+tnFd0wvqM2cG6oQWE6T9L2roCTtTm2fnxsY6fNWMkOJj25La8Utony2jD1TJ9RLYZCfe1x3CbbrclqDDFCVdZGyTla6xbXZkAi5Zcv526fDo8adH24yzJztiCShTiQ5zgPlHcPk7AECQP3x8spE8DflF3rByOL4=; Message-ID: <nrice@example.net> X-YMail-OSG: G7KMkkAVM1nDtw5Tr9oSDqb0dZS7WqaXyI6Y3gJBuEq.ErrhvKL4ERhh.q8iOzCoQ6.0X1DW70AWs_jGkIFI_1_Xl_okO1E4L64QyEnS12mlspJWZo5h4JeVpdw8eLUMJ.sa3Jjksaxq6WfIL0J6sZ3KXHu0oUtdrVg.7UgthMTNBD9_Jb.iSfR4S.4yRjedURO9JNRJn.UAgD.Exz_VGvKp4V0x_bZQEVh3xwkKdSw3n3UeLIOwpebwOgHvzUV__d.03aVU4gFhG9w1xlUtfLEOy3Y3qpuzP1IVhzDIoZqyZNkq.K88NBOmWpbSAEzNJw_bHoRKQqlmR5kss2G2GsEIBEgqhb8EOBWpWdWn3Z4HIGrQGLM9A60UxiAnngaNHDX7zJOF0AF9tCVy1A-- Received: from [83.161.120.155] by web50802.mail.re2.yahoo.com via HTTP; Thu, 22 Oct 2009 05:00:10 PDT X-Mailer: YahooMailRC/182.10 YahooMailWebService/0.7.361.3 References: <nrice@example.net> <nrice@example.net> <nrice@example.net> <nrice@example.net> <nrice@example.net> <nrice@example.net> <nrice@example.net> Date: Thu, 22 Oct 2009 05:00:10 -0700 (PDT) From: Alvaro Coronel <nrice@example.net> Subject: Re: maven torque:insert-sql fails: org/apache/tools/ant/PropertyHelper To: Apache Torque Users List <nrice@example.net> In-Reply-To: <nrice@example.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-21902703-1256212810=:10490" X-Virus-Checked: Checked by ClamAV on apache.org --0-21902703-1256212810=:10490 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I didn't follow this thread from the start, so forgive me if I am wrong.=0A= =0AI have seen many errors related to classes not found that were triggered= by a duplication of the class.=0A=0ASo not only do you have to check that = it is included in the classpath. You also have to check that it is not incl= uded twice or more in the classpath.=0A=0AHope this helps,=0A=C1lvaro=0A=0A= =0A=0A________________________________=0AFrom: Jon August <jon@internection= .com>=0ATo: Apache Torque Users List <nrice@example.net>=0ASent: Th= u, October 22, 2009 5:36:24 AM=0ASubject: Re: maven torque:insert-sql fails= : org/apache/tools/ant/PropertyHelper=0A=0AI had followed the directions
{'source': 'Apache Software Foundation Public Mail Archives'}