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)
1 REPLY
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