【搞定】即时通讯传送文件问题**

beidou

即时通讯传送文件总是不能成功？是怎么回事？有特定设置吗？
我们传一个文本文件里面就几个字母，都不能传送成功

jiahaiminghr

看看错误提示，包括服务器端和客户端的

beidou

服务器报如下错误：
java.sql.DataTruncation: Data truncation
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j
ava:379)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
        at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.
java:525)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java
:487)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedS
tatement.java:475)
        at com.justep.wildfire.JustepDeliverManager.AddToDeliverList(JustepDeliv
erManager.java:415)
        at com.justep.wildfire.JustepDeliverManager.AddToDeliverList(JustepDeliv
erManager.java:338)
        at org.jivesoftware.wildfire.ClientSession.process(ClientSession.java:83
6)
        at org.jivesoftware.wildfire.muc.spi.MUCRoleImpl.send(MUCRoleImpl.java:2
48)
        at org.jivesoftware.wildfire.muc.spi.MUCRoomImpl.broadcast(MUCRoomImpl.j
ava:1031)
        at org.jivesoftware.wildfire.muc.spi.MUCRoomImpl.send(MUCRoomImpl.java:9
42)
        at org.jivesoftware.wildfire.muc.spi.MUCRoomImpl.sendPublicMessage(MUCRo
omImpl.java:924)
        at org.jivesoftware.wildfire.muc.spi.MUCUserImpl.process(MUCUserImpl.jav
a:218)
        at org.jivesoftware.wildfire.muc.spi.MUCUserImpl.process(MUCUserImpl.jav
a:124)
        at org.jivesoftware.wildfire.muc.spi.MultiUserChatServerImpl.processPack
et(MultiUserChatServerImpl.java:200)
        at org.jivesoftware.wildfire.muc.spi.MultiUserChatServerImpl.process(Mul
tiUserChatServerImpl.java:184)
        at org.jivesoftware.wildfire.MessageRouter.route(MessageRouter.java:119)

        at org.jivesoftware.wildfire.PacketRouter.route(PacketRouter.java:69)
        at org.jivesoftware.wildfire.net.SocketReader.processMessage(SocketReade
r.java:495)
        at org.jivesoftware.wildfire.net.ClientSocketReader.processMessage(Clien
tSocketReader.java:66)
        at org.jivesoftware.wildfire.net.SocketReader.readStream(SocketReader.ja
va:200)
        at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:119)

        at java.lang.Thread.run(Thread.java:595)
java.sql.DataTruncation: Data truncation
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j
ava:379)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
        at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.
java:525)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java
:487)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedS
tatement.java:475)
        at com.justep.wildfire.JustepDeliverManager.AddToDeliverList(JustepDeliv
erManager.java:415)
        at com.justep.wildfire.JustepDeliverManager.AddToDeliverList(JustepDeliv
erManager.java:338)
        at org.jivesoftware.wildfire.ClientSession.process(ClientSession.java:83
6)
        at org.jivesoftware.wildfire.muc.spi.MUCRoleImpl.send(MUCRoleImpl.java:2
48)
        at org.jivesoftware.wildfire.muc.spi.MUCRoomImpl.broadcast(MUCRoomImpl.j
ava:1031)
        at org.jivesoftware.wildfire.muc.spi.MUCRoomImpl.send(MUCRoomImpl.java:9
42)
        at org.jivesoftware.wildfire.muc.spi.MUCRoomImpl.sendPublicMessage(MUCRo
omImpl.java:924)
        at org.jivesoftware.wildfire.muc.spi.MUCUserImpl.process(MUCUserImpl.jav
a:218)
        at org.jivesoftware.wildfire.muc.spi.MUCUserImpl.process(MUCUserImpl.jav
a:124)
        at org.jivesoftware.wildfire.muc.spi.MultiUserChatServerImpl.processPack
et(MultiUserChatServerImpl.java:200)
        at org.jivesoftware.wildfire.muc.spi.MultiUserChatServerImpl.process(Mul
tiUserChatServerImpl.java:184)
        at org.jivesoftware.wildfire.MessageRouter.route(MessageRouter.java:119)

        at org.jivesoftware.wildfire.PacketRouter.route(PacketRouter.java:69)
        at org.jivesoftware.wildfire.net.SocketReader.processMessage(SocketReade
r.java:495)
        at org.jivesoftware.wildfire.net.ClientSocketReader.processMessage(Clien
tSocketReader.java:66)
        at org.jivesoftware.wildfire.net.SocketReader.readStream(SocketReader.ja
va:200)
        at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:119)

        at java.lang.Thread.run(Thread.java:595)
客户端报如下错误：
传输文件()错误，在做操作“transferCommit”时出错

beidou

ding

Akon

楼主,是不是一个服务端连接过好几个数据库？
如果是，解决方法：将x3 server\tomcat\bin目录下的aff_data文件名改成aff_data_1 重启一下服务试试

beidou

那到没有，但是，有个接口程序服务（tomcat）器也连接了同一个数据库，应该没问题吧，重新启动服务，还需要重新启动协同得tomcat吗？因为现在客户用着呢，
应该是：alf_data文件夹吧？没有aff_data文件

jiahaiminghr

需要重新启动加载了文档服务器的tomcat

beidou

那只能晚上重新启动了，行，先结贴吧，不行，明天再发新帖子；再确认一下，是改alf_data文件夹吧？

jiahaiminghr

是的。

beidou

顶
按找上述方法还是不能发送文件
贾工帮忙看看