Trouble connecting to remote mysql Linux server

KNIME Analytics Platform
#1

Just started using this software yesterday so I’m still setting it up and learning…

I have tried using the Database Connector node but get this error:
– WARN
– Database Connector
– java.sql.SQLException: com.mysql.jdbc.PacketTooBigException:
– Packet for query is too large (4739923 > 1048576).
– You can change this value on the server by setting the max_allowed_packet’ variable.

Even if I add a SQL statement that should only return one value I get this error.

Here are my node configuration settings.
Database driver
– com.mysql.jdbc.Driver

Database URL
– jdbc:mysql://www.example.com:1234/db_name

This is the driver I added to my Knime install through the Preferences window
– mysql-connector-java-5.1.11-bin.jar

I am running Knime version 2.2.1

Any help would be greatly appreciated!

#2

Hi! Does this happen with all tables in your mySQL database? Can you please try to read a smaller table, just to see if it is really a package-size problem. I am not sure, but changing the database fetchsize parameter might also help… Thanks, Thomas

#3

Just tried a table that only has 2 rows of data (~2kb) and got the same error.

Did I maybe download and install the wrong driver? I saw another post here that listed a mysql driver that wasn’t an option from the one I installed.

I installed this:
mysql-connector-java-5.1.11-bin.jar
and have these options:
com.mysql.jdbc.Driver
com.mysql.jdbc.NonRegisteringDriver
com.mysql.jdbc.ReplicationDriver
com.mysql.jdbc.NonRegisteringReplicationDriver
org.gjt.mm.mysql.Driver