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