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

[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