Maximum Parameters for PreparedStatement
I don't remember the specifics, because I made a workaround -- but --
When using the PreparedStatement
, is there a way ofINcreasing the maximum number of parameters that can be passed in?
I'd gotten some error message on the 12th parameter saying that I'd gone over the maximum. The error went away when I made some of the parameters to be part of the query string itself (you know, sql +="and column = " + column
) instead of using the "?" place-marker.
Now, I can understand there being an upper limit -- but 12 seems like anAWFULLYlow limit -- unless I messed up somewhere else? Or there's a way to increase that limit that I couldn't find?
Thoughts anyone?
[752 byte] By [Unca_Albya] at [2007-11-27 5:38:01] 