Java + mysql (windows 2000) :

When i use base64 to encode string , and then insert into database then show error 
message 

SQLException caught: Error during query: Unexpected Exception: 
java.lang.IllegalArgumentException message given: Packet is larger than 
max_allowed_packet from server configuration of 65536 bytes 

If i doesn't use base64 to encode string , it will be not error . I  can't find what's 
 wrong ?

I have been try below method but fail ...

20.4.6 Packet too large error

When a MySQL client or the mysqld server gets a packet bigger than max_allowed_packet 
bytes, it issues a Packet too large error and closes the connection. 

If you are using the mysql client, you may specify a bigger buffer by starting the 
client with mysql --set-variable=max_allowed_packet=8M. 

If you are using other clients that do not allow you to specify the maximum packet 
size (such as DBI), you need to set the packet size when you start the server. You cau 
use a command-line option to mysqld to set max_allowed_packet to a larger size. For 
example, if you are expecting to store the full length of a BLOB into a table, you'll 
need to start the server with the --set-variable=max_allowed_packet=24M option. 

<(h™âŽªQÜm§ÿðÃ
\†‰žr‰­Àð¡¢gŽžX§y¬@ÅhÉ

Reply via email to