Return-Path: 
 <torque-user-return-3631-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 59683 invoked from network); 4 Dec 2003 22:25:50 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 4 Dec 2003 22:25:50 -0000
Received: (qmail 85544 invoked by uid 500); 4 Dec 2003 22:25:34 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 85523 invoked by uid 500); 4 Dec 2003 22:25:34 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Subscribe: <mailto:torque-user-subscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 85510 invoked from network); 4 Dec 2003 22:25:34 -0000
Received: from unknown (HELO ash.lnxi.com) (208.177.141.226)
  by daedalus.apache.org with SMTP; 4 Dec 2003 22:25:34 -0000
Received: (qmail 22811 invoked from network); 4 Dec 2003 22:34:13 -0000
Received: from spark.lnxi.com (192.168.35.112)
  by ash.lnxi.com with SMTP; 4 Dec 2003 22:34:13 -0000
Subject: Re: Printing SQL
From: Jeff Rasmussen <jrasmussen@lnxi.com>
Reply-To: jrasmussen@lnxi.com
To: Apache Torque Users List <torque-user@db.apache.org>
In-Reply-To: <20031204221359.29851.qmail@web13423.mail.yahoo.com>
References: <20031204221359.29851.qmail@web13423.mail.yahoo.com>
Content-Type: text/plain
Organization: Linux Networx
Message-Id: <1070576740.15174.16.camel@spark.default.domain>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.3 
Date: 04 Dec 2003 15:25:40 -0700
Content-Transfer-Encoding: 7bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

This should work. I've been using it.

Criteria crit = new Criteria();
....
....
....
System.out.println(crit.toString());

Jeff Rasmussen

On Thu, 2003-12-04 at 15:13, Sonu Vijay wrote:
> Hi,
> Can we print the actual SQL that is made out of the
> Criteria.
> My selects work but inserts don't, I need to see the
> SQL as the following stack trace indicated syntax
> errors.
> 
> Thanks
> 
> Vijay
> 
> -----------------------
> java.sql.SQLException: [SQL0104] Token ) was not
> valid. Valid tokens: DAY PATH YEAR LABEL MONTH OPTION
> RESULT CONNECTION TRANSACTION.
> 	at
> com.ibm.as400.access.JDError.throwSQLException(JDError.java:388)
> 	at
> com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1088)
> 	at
> com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStatement.java:208)
> 	at
> com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1419)
> 	at
> com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1371)
> 	at
> org.apache.commons.dbcp.cpdsadapter.PooledConnectionImpl.prepareStatement(PooledConnectionImpl.java:271)
> 	at
> org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.prepareStatement(ConnectionImpl.java:372)
> 	at
> com.workingdogs.village.Record.saveWithInsert(Unknown
> Source)
> 	at com.workingdogs.village.Record.save(Unknown
> Source)
> 	at com.workingdogs.village.Record.save(Unknown
> Source)
> 	at
> org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:891)
> 	at
> org.apache.torque.util.BasePeer.doInsert(BasePeer.java:725)
> 	at
> com.suz.torque.pitchers.BaseTeamPeer.doInsert(BaseTeamPeer.java:218)
> 	at
> com.suz.torque.pitchers.BaseTeamPeer.doInsert(BaseTeamPeer.java:565)
> 	at com.suz.torque.pitchers.BaseTeam.save(BaseTeam.java:1081)
> 
> __________________________________
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> http://companion.yahoo.com/
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org