You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by sudip shrestha <su...@gmail.com> on 2005/01/31 19:48:55 UTC
PreparedStatements
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: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: PreparedStatements
Posted by Je...@bcbstx.com.
And it would seem this may be the ptf:
http://www-912.ibm.com/j_dir/JTOpen.nsf/8178b1c14b1e9b6b8525624f0062fe9f/a81403b611a0583686256bab006d7543?OpenDocument
JC
"Woodchuck"
<woodchuck_5@yaho To: "Struts Users Mailing List" <us...@struts.apache.org>, "sudip
o.com> shrestha" <su...@gmail.com>
cc:
01/31/2005 03:25 Subject: Re: PreparedStatements
PM
Please respond to
"Struts Users
Mailing List"
wow.. i guess there is a parameter limit with your specific
configuration :p
--- sudip shrestha <su...@gmail.com> wrote:
> 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 <su...@gmail.com>
> 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: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
**********
The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312)653-6000 in Illinois; (972)766-6900 in Texas; or (800)835-8699 in New Mexico.
**********
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: PreparedStatements
Posted by Woodchuck <wo...@yahoo.com>.
wow.. i guess there is a parameter limit with your specific
configuration :p
--- sudip shrestha <su...@gmail.com> wrote:
> 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 <su...@gmail.com>
> 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: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: PreparedStatements
Posted by sudip shrestha <su...@gmail.com>.
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 <su...@gmail.com> 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: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org
Re: PreparedStatements
Posted by Woodchuck <wo...@yahoo.com>.
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 <su...@gmail.com> 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: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org