Hi, we need to insert queries dynamically thru war application in mysql db 5.1 (around 54000 rows)
whenever we start upload the same from application we get 2009-07-01 09:07:34,440 ERROR [STDERR] com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1741081 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. 2009-07-01 09:07:34,442 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2635) 2009-07-01 09:07:34,442 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621) 2009-07-01 09:07:34,442 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552) 2009-07-01 09:07:34,442 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) 2009-07-01 09:07:34,442 ERROR [STDERR] at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) 2009-07-01 09:07:34,442 ERROR [STDERR] at com.mysql.jdbc.Connection.execSQL(Connection.java:2917) 2009-07-01 09:07:34,442 ERROR [STDERR] at com.mysql.jdbc.Statement.execute(Statement.java:529) Pls. share any input on above View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4241065#4241065 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4241065 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
