Tulsi, I haven't ever used Log4J.
Could u guide how to configure that from my main program if its not too much of a hassle. Don't want to leave Torque and start leaning Log4J now. Thanks Vikas --- Tulsi Das <[EMAIL PROTECTED]> wrote: > 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] > __________________________________ 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]
