Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
From: "Ramesh Sabeti" <rs@reazon.com>
To: "'Apache Torque Users List'" <torque-user@db.apache.org>
Subject: RE: Help Plsssssssssssss
Date: Fri, 5 Dec 2003 17:45:26 -0800
Message-ID: <003301c3bb9a$9f628ee0$800101df@rsccd.org>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Importance: Normal
In-Reply-To: <20031206000215.17441.qmail@web13421.mail.yahoo.com>

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