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]
