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]
