较简单问题:写不进大于20M的数据到longblob列中,请指救配置,再加分

littlecpu 2003-09-30 02:15:40
java.sql.SQLException: Communication link failure: com.mysql.jdbc.PacketTooBigEx
ception
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:885)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1874)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1351)

at org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepo
sitory.java:584)
at org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRe
pository.java:190)
at org.apache.james.James.sendMail(James.java:444)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.avalon.phoenix.components.application.BlockInvocationHandl
er.invoke(BlockInvocationHandler.java:92)
at $Proxy9.sendMail(Unknown Source)
at org.apache.james.smtpserver.SMTPHandler.processMail(SMTPHandler.java:
1353)
at org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:1200)

at org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java
:560)
at org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.
java:337)
at org.apache.james.util.connection.ServerConnection$ClientConnectionRun
ner.run(ServerConnection.java:404)
at org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
ecutableRunnable.java:47)
at org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
.java:80)
java.sql.SQLException: No operations allowed after connection closed
at com.mysql.jdbc.Connection.checkClosed(Connection.java:2497)
at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:559)
at org.apache.james.util.mordred.PoolConnEntry.setAutoCommit(PoolConnEnt
ry.java:254)
at org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepo
sitory.java:438)
at org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRe
pository.java:190)
at org.apache.james.James.sendMail(James.java:444)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.avalon.phoenix.components.application.BlockInvocationHandl
er.invoke(BlockInvocationHandler.java:92)
at $Proxy9.sendMail(Unknown Source)
at org.apache.james.smtpserver.SMTPHandler.processMail(SMTPHandler.java:
1353)
at org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:1200)

at org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java
:560)
at org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.
java:337)
at org.apache.james.util.connection.ServerConnection$ClientConnectionRun
ner.run(ServerConnection.java:404)
at org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
ecutableRunnable.java:47)
at org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
.java:80)
...全文
55 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
ezhou 2003-09-30
  • 打赏
  • 举报
回复
楼主,从你提供的信息来看,我觉得不像是mysal的问题,好像是你的记录在写的过程中连接断开了!
ezhou 2003-09-30
  • 打赏
  • 举报
回复
楼主,你的数据也真够大的!压缩一下再写数据库吧。
犬犬:blob4.0版本以上最多不是可以支持到4G么?
littlecpu 2003-09-30
  • 打赏
  • 举报
回复
楼上的早,此参数我已设为1000m,期待新解。
shuixin13 2003-09-30
  • 打赏
  • 举报
回复
blob类型最大可存储64k的图象,超过时可用longblob类型

要注意在你的 my.cnf/my.ini 中要加入下面的设置项

[mysqld]
set-variable = max_allowed_packet = 25M

56,675

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧