You're using a _very_ old version of the MM.MySQL driver. This problem has
been fixed quite awhile ago. Please upgrade to the latest driver, which is
2.0.8 available from http://mmmysql.sourceforge.net/
-Mark
>
> Chris Stark wrote:
>
> >
>
> > Hi,
>
> >
>
> > I am having a problem with the configuration of the mysql server or
> client.
>
> > I have a very large query that I need to send to MySQL from Java. The
> query
>
> > has approximately 5000 individual items in the where clause. (i.e. WHERE
>
> > i!='AP' AND i != 'J3' AND...to 5000).
>
> >
>
> > When I try to execute the Query I get the error:
>
> >
>
> > "Packet is Larger than max_allowed_packet from server configuration of
> 65536
>
> > bytes"
>
> >
>
> > I read the MySQL documentation and increased my max_allowed_packet to
24M
> on
>
> > both the client and the Server in the my.cnf, but I still get the same
>
> > error....Is there another variable I need to increase, because no matter
>
> > what I change the value of max_allowed_packet to, I still get the 65535
>
> > bytes error?? Please help!!
>
> >
>
> > Thanks,
>
> > Chris
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
