[jboss-user] [Installation, Configuration & DEPLOYMENT] - jboss 4.2.2 question

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#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...