From: Michael Dykman Date: February 24 2012 5:58pm Subject: Re: two 5.1 servers, different behaviour List-Archive: http://lists.mysql.com/mysql/226855 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I see your point. Configuration files aside, what do you get when you query the servers themselves with: show variables like 'max_allowed_packet' There *might* be something in your start-up scripts overriding that config setting. - md On Fri, Feb 24, 2012 at 11:57 AM, William Bulley wrote: > According to Michael Dykman on Fri, 02/24/12 at 11:42= : >> >> That error is coming from neither the MySQL server nor from >> DBVisualizer. =A0That is coming from your JDBC driver. =A0Check the >> version of that and research the effect of configuration options. >> >> http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configurati= on-properties.html > > Thanks for the reply. > > I understood that the error came from the JBDC driver because of the > Java class path given in the exception text: > > =A0 com.mysql.jdbc.PacketTooBigException > > But that isn't the issue. =A0The same DbVisualizer instance works just > fine when connecting to the MySQL 5.1.60 server on system A, but fails > with the "query too large" exception when trying to connect to the > MySQL 5.1.58 server on system B. =A0It strains credulity to think that > the same DbVisualizer instance would use two different JBDC drivers > when the DbVisualizer connect string begins with "jdbc:mysql://..." > in both cases. > > I found this file in my DbVisualizer installation directory: > > =A0 unix% cat /usr/local/share/dbvis/jdbc/mysql/README > =A0 MySQL-AB JDBC Driver > =A0 -------------------- > =A0 Version: =A0 =A05.1.16 > =A0 Files: =A0 =A0 =A0mysql.jar > =A0 Reference: =A0http://www.mysql.com > > =A0 DbVis Software AB is a "MySQL Network Certified Partner" > =A0 and have the right to distribute the Connector/J driver. > > So what I can't explain is why it works for one and not the other. > > Regards, > > web... > > -- > William Bulley =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Email: web@stripped= du > > 72 characters width template ----------------------------------------->| --=20 =A0- michael dykman =A0- mdykman@stripped =A0May the Source be with you.