[Installation, Configuration & DEPLOYMENT] - jboss 4.2.2 question
by sunlinux
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
16 years, 4 months