Vijay, http://www.mail-archive.com/[EMAIL PROTECTED]/msg03411.htm l may provide some pointers.
And please use a meaningful email subject :) Ramesh > -----Original Message----- > From: Sonu Vijay [mailto:[EMAIL PROTECTED] > Sent: Friday, December 05, 2003 4:02 PM > To: Apache Torque Users List > Subject: Help Plsssssssssssss > > Guys, > I"m about to go mad on this on, so pls give me ur > ideas. As some of you might know since yesterday I've > been trying to make the Torque generated Java Classes > to work with DB2400 and I can do selects and deletes > but can't do Inserts and I'm getting the following > exception every time I try an Insert: > > java.sql.SQLException: [SQL0104] Token ) was not > valid. Valid tokens: DAY PATH YEAR LABEL MONTH OPTION > RESULT CONNECTION TRANSACTION. > > Now I tried my level best to print the Insert queries > without getting into Torque code but it didn't work. I > also tried the spy programs suggested by some guys in > the list but still got nothing. > > Maybe that was too much to handle for an Entry level > programmer. > > So I downloaded the Torque code and messed around with > it. Then I downloaded all the village code and tried > to put debugging statements in it. > > So here is what I have found. The actual queries are > being executed in the village code and I could get the > Insert query also. In the village code they check if a > column in read only ( resultSetMetaData.isReadOnly() ) > and my columns come as readOnly, so that's where the > trouble is. > > Now I can't see a damn reason why they are read only. > I can run SQL Inserts from my AS400 operations > navigator with the same USERID/PASSWORD that I'm > supplying to the Torque java classes. > > So I would really really appreciate any ideas you > might have abt the situation. If you need any more > information I'll be happy to provide that. > > Thanks > > Vijay > > > > > > > > __________________________________ > 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]
