Hey Bill, Could you try sending the attachment directly to me, it seems it didn't come thru the torque list.
And is it a version of village latest than 1.5.3. That's the latest one I could get from their site althought torque uses another one which is 2.0 or something. thanks vikas --- Bill Leng <[EMAIL PROTECTED]> wrote: > try the attached village.jar. > > Sonu Vijay wrote: > > >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] __________________________________ 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]
