And it would seem this may be the ptf:

http://www-912.ibm.com/j_dir/JTOpen.nsf/8178b1c14b1e9b6b8525624f0062fe9f/a81403b611a0583686256bab006d7543?OpenDocument


JC


                                                                                
                                              
                      "Woodchuck"                                               
                                              
                      <[EMAIL PROTECTED]        To:       "Struts Users Mailing 
List" <user@struts.apache.org>, "sudip         
                      o.com>                    shrestha" <[EMAIL PROTECTED]>   
                                               
                                               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 <[EMAIL PROTECTED]> 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 <[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!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





**********
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to