It seems that it is a bug with OS/400 R 5.1. It has been documented before: http://www-124.ibm.com/developerworks/bugs/?func=detailbug&bug_id=3160&group_id=29
On Mon, 31 Jan 2005 12:48:55 -0600, sudip shrestha <[EMAIL PROTECTED]> wrote: > Using JDBC- JTOpen 4.6 for AS/400 DB2 > I have a PreparedStatement that inserts 25 values into a table with 25 > attributes... > When I supply 23 or less attributes with values, the insert operation > works normally. > However, if I supply 24 or 25 attributes it throws an exception: > java.sql.SQLException: [SQL0804] SQLDA not valid. > > There seems to be nothing wrong the the database/table/metadata, I can > run insert/update/delete operations normally with direct sql. It is > the PreparedStatements with JDBC that I am having problems with. > I was wondering if there was limitation on number of parameters that > you can supply with PreparedStatements?? > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]