com.mysql.jdbc.PacketTooBigException
Hi All,,,,
When i am configuring and saving 'New-Database Table Resource' from 'Resources' tab, i am facing following error.
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1082493 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
I came to know that i need to change the "max_allowed_packet" variable. Can any one give me clear idea?
Waiting for reply.......
[473 byte] By [
@Mahi] at [2007-11-26 8:54:22]
# 1
The failure you note above indicates that there is a server setting which only allows 1MEG of data to be sent from the server to client remotly - which is very unlikly in a true production environment.
To change this in mysql, try adding the following contents to a file called
$WINDIR/my.ini. Where $WINDIR is c:/winnt in my case.
[mysqld]
set-variable = max_allowed_packet=4M
# 2
Thanks for reply,,,, But, I didn't found the file my.ini in my entire system...So, still i have that problem........Looking for solution.................
@Mahi at 2007-7-6 22:50:09 >
