How to reduce Mysql query packet size created by Talend jobs.

One Star

How to reduce Mysql query packet size created by Talend jobs.

I'm getting the following error.
Is there a standard practice for reducing the packet size of these connections?
Exception in component tMysqlConnection_1
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.
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:605)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1078)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2412)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2445)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2230)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
Seventeen Stars

Re: How to reduce Mysql query packet size created by Talend jobs.

Check this article.
http://stackoverflow.com/questions/11320236/com-mysql-jdbc-packettoobigexception
It is a bit miracle why the connection it self causes this error. Could you post a picture of your job, especially the connection parameters?
By The way, wrong forum. You should post this under Usage, Operation