db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sonu Vijay <son...@yahoo.com>
Subject Re: Printing SQL
Date Thu, 04 Dec 2003 22:45:15 GMT
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 <quixote_arg@yahoo.com> 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 <jrasmussen@lnxi.com> 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:
> 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
> >  
> 
> ------------
> 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:
> torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail:
> torque-user-help@db.apache.org
> 


__________________________________
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


Mime
View raw message