1 Reply Latest reply on Jul 1, 2009 10:18 AM by Peter Johnson

    jboss 4.2.2 question

    sun kum Newbie

      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