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.



--- [EMAIL PROTECTED] 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:[EMAIL PROTECTED] 
>       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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]
>       > > > 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 <[EMAIL PROTECTED]>
>       > 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 <[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
>       > > > > >>>
>       > > > > >>>
>       > > > >
>       > > > >
>       > > > >
>       > > > >
>       > > > >
>       > > >
>       > >
>       >
> 
>
---------------------------------------------------------------------
>       > > > > 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]
>       > >
>       > >
>       > >
>       > >
>       >
> 
>
---------------------------------------------------------------------
>       > > To unsubscribe, e-mail:
>       > > [EMAIL PROTECTED]
>       > > For additional commands, e-mail:
>       > > [EMAIL PROTECTED]
>       > >
>       >
> 
=== message truncated ===


__________________________________
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]

Reply via email to