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 23:38:22 GMT
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


Mime
View raw message