errors with IM Gateway, OpenFire3.4.1, Oracle9i, ojdbc14.jar
no buddy icons of the msn friends.
errors copy from error.log:
2007.11.14 16:54:52 org.jivesoftware.openfire.gateway.util.Log4JToOpenfireAppender.append(Log4JToOpe nfireAppender.java:49) Avatar: SQL exception while inserting avatar:
java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.jav a:952)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:11 60)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatem ent.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatemen t.java:3368)
at org.jivesoftware.openfire.gateway.avatars.Avatar.insertIntoDb(Avatar.java:227)
at org.jivesoftware.openfire.gateway.avatars.Avatar.<init>(Avatar.java:109)
at org.jivesoftware.openfire.gateway.protocols.msn.MSNListener$1.notifyMsnObjectRe trieval(MSNListener.java:240)
at net.sf.jml.message.p2p.DisplayPictureRetrieveWorker.notifyFinalization(DisplayP ictureRetrieveWorker.java:172)
at net.sf.jml.message.p2p.DisplayPictureRetrieveWorker.p2pMessageReceived(DisplayP ictureRetrieveWorker.java:680)
at net.sf.jml.impl.AbstractMessenger.fireP2PMessageReceived(AbstractMessenger.java :374)
at net.sf.jml.message.p2p.MsnP2PMessage.messageReceived(MsnP2PMessage.java:131)
at net.sf.jml.message.IncomingMimeMessage.messageReceived(IncomingMimeMessage.java :56)
at net.sf.jml.protocol.MsnSession$1.messageReceived(MsnSession.java:105)
at net.sf.cindy.impl.AbstractSession$6.doRun(AbstractSession.java:341)
at net.sf.cindy.impl.AbstractSession$DispatchObject.run(AbstractSession.java:395)
at net.sf.cindy.impl.SimpleDispatcher.dispatch(SimpleDispatcher.java:35)
at net.sf.cindy.impl.AbstractSession.dispatch(AbstractSession.java:249)
at net.sf.cindy.impl.AbstractSession.dispatchMessageReceived(AbstractSession.java: 335)
at net.sf.cindy.impl.StreamChannelSession.recognizeMessageAndDispatch(StreamChanne lSession.java:77)
at net.sf.cindy.impl.StreamChannelSession.readFromChannel(StreamChannelSession.jav a:53)
at net.sf.cindy.impl.ChannelSession.onReadable(ChannelSession.java:212)
at net.sf.cindy.impl.ChannelSession.onEvent(ChannelSession.java:134)
at net.sf.cindy.impl.SocketSession.onEvent(SocketSession.java:119)
at net.sf.cindy.impl.SimpleEventGenerator.processKey(SimpleEventGenerator.java:212 )
at net.sf.cindy.impl.SimpleEventGenerator.run(SimpleEventGenerator.java:192)
at net.sf.cindy.impl.SimpleEventGenerator.access$000(SimpleEventGenerator.java:54)
at net.sf.cindy.impl.SimpleEventGenerator$1.run(SimpleEventGenerator.java:115)
thanks.