or, better yet, you can setup Log4J to DEBUG level, and all queries get printed out to wherever you've configured it.
tulsi --- Jeff Rasmussen <[EMAIL PROTECTED]> escribi�: > 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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > ------------ Los mejores usados y las m�s tentadoras ofertas de 0km est�n en Yahoo! Autos. Compr� o vend� tu auto en http://autos.yahoo.com.ar --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
