powered by Jive Software

PubSub payload larger than 4000 characters won't publish

We have a need to publish items with payloads larger than 4000 characters. I think the same problem occurs in offline messages also. PUBSUBITEM and JIVEOFFLINE, respectively.

Whenever we try to publish an item larger than 4000 characters, we get the following in the error log and no item in PUBSUBITEM. This error repeats every few minutes until we recycle the server. Our DB is Oracle. Any advice would be much appreciated. Thanks.

2009.03.04 11:03:15 [org.jivesoftware.openfire.pubsub.PubSubPersistenceManager.createPublishedItem( PubSubPersistenceManager.java:1028)]
java.sql.SQLException: Data size bigger than max size for this type: 29982
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:147)
at oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2461)
at oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java :1155)
at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.ja va:1572)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at oracle.jdbc.internal.OracleStatement$$EnhancerByProxool$$a51445be.setString()
at org.jivesoftware.openfire.pubsub.PubSubPersistenceManager.createPublishedItem(P ubSubPersistenceManager.java:1022)
at org.jivesoftware.openfire.pubsub.PublishedItemTask.run(PublishedItemTask.java:7 1)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)