afaik, there is no parameter limit
your problem is probably related to the actual data value you're trying
to set as parameter values for your preparedstatement. just my guess.
find out whether your problem is always happening on specific
parameters or not... ie. the 24th or 25th parameter that breaks the
camel's back
--- 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]
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
