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 Fri, 05 Dec 2003 17:51:50 GMT
Mike,
The p6spy.com website talks a lot abt using it on
various application servers. I don't have any any
application server. Have you used it for simple Java
Applications running from say the commandline.



--- mikendall@blueyonder.co.uk wrote:
> 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
> 	> >
> 	>
> 
=== message truncated ===


__________________________________
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