I am using Connector/J 3.0.6:
I am attempting to run the following prepared statement:
update mailbox set parent_mail_id = 0 where parent_mail_id in ?
And the string given as the input parameter is:
(0,4,2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28
29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53)
I get the following SQL Error:
java.sql.SQLException: Syntax erroror access violation: You have an error in
your SQL syntax
near''(0,4,2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,
27,28,29,' at line 1
However, when I run this as SQL in mysql to see if it will work, it runs
just fine.
Is there a limit to the string that can get passed in here? Or what else am
I missing in having this work?
Thanks,
Kim
