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