db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ramesh Sabeti" ...@reazon.com>
Subject RE: Help Plsssssssssssss
Date Sat, 06 Dec 2003 01:45:26 GMT
Vijay,

http://www.mail-archive.com/turbine-user@jakarta.apache.org/msg03411.htm
l may provide some pointers.

And please use a meaningful email subject :)

Ramesh


> -----Original Message-----
> From: Sonu Vijay [mailto:sonupv@yahoo.com]
> 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: 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


Mime
View raw message