1 message in com.mysql.lists.javamm.mysql 2.0 selfconfiguring for max_...| From | Sent On | Attachments |
|---|---|---|
| Donal Lynch | 29 Aug 2000 11:20 |
| Subject: | mm.mysql 2.0 selfconfiguring for max_allowed_packet? |
|---|---|
| From: | Donal Lynch (don...@local.ie) |
| Date: | 08/29/2000 11:20:48 AM |
| List: | com.mysql.lists.java |
Hi,
I'm having a similar problem to the one mentioned in the mail below, but I
haven't
found a solution in the archive of this list.
I've got a max_allowed_packet of 1048576, and I've got a test program that
inserts a
100K string into a longblob then selects it back out again.
I tried the test with three versions of mm.mysql:
1.1i: passes the test, which I didn't expect... it seems to read a packet and configure a buffer length based on that?
1.2b: throws ArrayIndexOutOfBoundsException on the INSERT, as expected.
2.0.2: Exception: "Packet is larger than max_allowed_packet from server
configuration of 65536 bytes."... thrown on the SELECT.
In the code I can see Connection configuring itself according to the
max_allowed_packet value extracted from "show variables", but there's an
instance of
Buffer that's been set to 64K and that's what seems to be causing the Exception.
All I want to do is to get the 100K in and out of the database. Is there some
mistake
I'm making for the test to fail with the 2.0.2 driver? Is it safe for me to use
1.1i,
which seems to pass the test? I'd be grateful for any help.
-- Donal
FROM: Thanush Thamban DATE: 01/28/1999 23:00:42 SUBJECT: RE: setBinaryStream limit?
Hi Mark, This message is not part of the above Thread......
Though you have said that the 2.0pre2 version has a fix for storing data values greater than 65K but.... im not able to save values greater than 65K.... I am using the latest driver. "mm.mysql.jdbc-2.0pre2"
I keep getting the following exception : "Excep java.lang.IllegalArgumentException: Packet is larger than max_allowed_packet from server configuration of 1048576 bytes "