I'm developing a Java application that uses a pool of JDBC connections
to store and retrieve data in a MySQL database. I'm using the 3.23.38
Win32 version of MySQL, on Windows 2000 Professional, and the
mm.mysql-2.0.4 JDBC driver.
I'm using a table with a MEDIUMTEXT field, which the MySQL documentation
says can handle up to 16.7 Megs of data. However, I've run into
problems with this Exception being thrown (the [java] prefix is there
because I'm running this from inside of an ant script):
[java] java.sql.SQLException: Error during query: Unexpected
Exception: java.lang.IllegalArgumentException message given: Packet is
larger than max_allowed_packet from server configuration of 65536 bytes
[java] at
org.gjt.mm.mysql.Connection.execSQL(Connection.java:898)
[java] at
org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
[java] at
org.gjt.mm.mysql.Statement.executeUpdate(Statement.java:227)
[java] at
org.gjt.mm.mysql.jdbc2.Statement.executeUpdate(Statement.java:97)
[java] at
com.incellico.arrayex.data.MyClass.storeBigField(MyClass.java:xxx)
I'm running mysql as a service on my machine, using the mysqld-max-nt
executable. When I take a look at the variables, the output reports
that the max_allowed_packet size is set to 1 Meg. I've tried explicitly
setting max_allowed_packet in the C:\WINNT\my.ini file, by adding a
[mysqld] section, and I've tried bumping up the available memory by
adding a [safe_mysqld] section with "ulimit -d 256000", as was suggested
in the MySQL manual. Neither has worked.
Could this be a problem with the mm.mysql JDBC driver itself?
Peter Bailey
(work) [EMAIL PROTECTED]
(home) [EMAIL PROTECTED]
---------------------------------------------------------------------
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
