2013-08-15 02:53:22,071 INFO [STDOUT] >>DAOFactory>getConnection:SQLException:
2013-08-15 02:53:22,071 INFO [STDOUT] Could not create connection; - nested throwable: (com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4739923 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4739923 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.))
2013-08-15 02:53:22,071 ERROR [org.jboss.ejb.plugins.LogInterceptor] EJBException in method: public abstract com.spokesoft.component.label.LabelModel com.spokesoft.component.label.ejb.LabelManager.findLabel(com.spokesoft.component.label.LabelModel) throws java.rmi.RemoteException, causedBy:
org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4739923 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4739923 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.))
jboss链接mysql老提示max_allowed_packet太小，但是在mysql里面查看配置文件显示 ：
max_allowed_packet 16 777 216
16m应该足够了吧。为何在jboss启动服务时总是显示最大1m呢？
添加评论
关注(0)
相关推荐
本文将深入探讨“com.mysql.jdbc.PacketTooBigException: Packet for query is too large (11087 > 102)”这一异常，分析其原因，并提供相应的解决方案。 `com.mysql.jdbc.PacketTooBigException` 是MySQL JDBC驱动...
想改变这个问题，需要注意几点： com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2054817 > 1048576). You can change this value on the server by setting the max_allowed_packet’ ...
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4232009 > 4194304). You can change this value on the server by setting the max_allowed_packet’ variable. 出现上面的错误是因为...
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1354 > 1024). You can change this value on the server by setting the max_allowed_packet’ variable MySQL根据配置...
今天在往mysql中插入数据时遇到的问题，翻译过来的意思是：查询数据包太大 建议修改max_allowed_packet参数值。 针对我执行的插入操作来说，意味着一次性执行的sql语句太大，超过了mysql默认设置的值（我用的是...
MySQL批量插入问题 ...nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (5677854 > 1048576). You can change this value on the server by setting the max_allowed_pac
nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1280 > 1024). You can change this value on the server by setting the max_allowed_packet' variable ``` - **...
如果设置得过小，则可能会遇到“packet for query is too large”的错误。默认情况下，`max_allowed_packet` 的值通常为1MB或更小，这对于大多数应用来说已经足够，但在处理大量数据时可能需要对其进行调整。 #### ...
当日志中出现了诸如：“Package for query is too large （xxxxxxxx > 4194304). You can change this value on the server by setting the max_allowed_package variable”的提示的时候，错误的本身就清楚的提示了...
is attempting to send too much over one link. We note, however, that since the IMP at the destination does not have enough capacity to handle all 32 links simultaneously, the links serve their ...
- Added support for VGA graphics mode with 400 lines (partial fix for SF bug #2948724) - NE2K: Fixed "send buffer" command issue on big endian hosts - USB - converted common USB code plus devices ...
* 0 译者序 * 1 MySQL的一般的信息 o 1.1 什么是MySQL？ o 1.2 关于本手册 + 1.2.1 本手册中使用的约定 o 1.3 MySQL的历史 o 1.4 MySQL的主要特征 o 1.5 MySQL稳定性？ o 1.6 顺应2000年 ...
18.2.3 Host '...' is blocked错误 18.2.4 Out of memory错误 18.2.5 Packet too large错误 18.2.6 The table is full错误 18.2.7 Commands out of sync in client错误 18.2.8 Ignoring ...
MySQL中文参考手册.chm 449kb <br/>0 译者序 1 MySQL的一般的信息 1.1 什么是MySQL？ 1.2 关于本手册 1.2.1 本手册中使用的约定 1.3 MySQL的历史 1.4 MySQL的主要特征 1.5...