db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <mikend...@blueyonder.co.uk>
Subject RE: Printing SQL
Date Fri, 05 Dec 2003 07:14:00 GMT
Hi Sonu,
Instead of patching printlns into Torque you an user a JDBC tracer like P6SPY. (www.p6spy.com)
It also has profiling etc. and seems quite active,
Regards,
Malcolm Kendall

	-----Original Message----- 
	From: Sonu Vijay [mailto:sonupv@yahoo.com] 
	Sent: Thu 04/12/2003 23:41 
	To: Apache Torque Users List 
	Cc: 
	Subject: RE: Printing SQL
	
	

	Ok guys where can I get the source for
	com.workingdogs.village.Record
	
	Thanks
	
	--- Sonu Vijay <sonupv@yahoo.com> wrote:
	> Well,
	> You may be right, but this DB2400 is a damn picky
	> monster.
	> I have just added some debugging statements to
	> BasePeer.
	> There would be some point where an Insert statement
	> is
	> generated. Anyone knows where ??
	>
	> I have all the code in my IDE now and now that I
	> have
	> started on this path would like to see the Insert
	> statement if I can before starting to look into
	> other
	> places.
	>
	> Thanks
	>
	>
	>
	> --- Ramesh Sabeti <rs@reazon.com> wrote:
	> > Criteria doesn't know about the operations such as
	> > INSERT or SELECT.
	> > When you print the criteria, you're only printing
	> > the WHERE clause.
	> > Criteria.toString() will tell you how it would
	> look
	> > like if you were
	> > doing a SELECT statement.
	> >
	> > Debug your Java classes created by torque.  We
	> found
	> > out our Inserts
	> > didn't work because how id's were generated.  That
	> > usually gets you
	> > moving from one database to another.
	> >
	> > Ramesh.
	> >
	> > > -----Original Message-----
	> > > From: Sonu Vijay [mailto:sonupv@yahoo.com]
	> > > Sent: Thursday, December 04, 2003 2:53 PM
	> > > To: Apache Torque Users List
	> > > Subject: Re: Printing SQL
	> > >
	> > > Yeah, I am having problems with Inserts. And it
	> > the
	> > > damn DB2400. Everything works perfectly when I
	> > tried
	> > > on MySQL. But there also I Criteria prints only
	> > > Selects, no Inserts get printed.
	> > >
	> > > I don't understand when a Select is done
	> > > Criteria.toString() prints a SELECT SQL and when
	> > an
	> > > Insert is being done then also its give a SELECT
	> > only.
	> > >
	> > > What's going on here.
	> > >
	> > >
	> > > --- Scott Eade <seade@backstagetech.com.au>
	> wrote:
	> > > > This will log selects, but not inserts and
	> > updates.
	> > > >
	> > > > Scott
	> > > >
	> > > > --
	> > > > Scott Eade
	> > > > Backstage Technologies Pty. Ltd.
	> > > > http://www.backstagetech.com.au
	> > > >
	> > > >
	> > > > Tulsi Das 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
	> > > > >>>
	> > > > >>>
	> > > >
	> > > >
	> > > >
	> > > >
	> > > >
	> > >
	> >
	>
	---------------------------------------------------------------------
	> > > > 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
	> >
	> >
	> >
	> >
	>
	---------------------------------------------------------------------
	> > 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
	>
	
	
	__________________________________
	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