powered by Jive Software

Dynamic SQL Error PubSubPersistenceManager ofPubsubItem: FreeBSD 9.1 + DB FireBird 2.5.2 + jdbc Jaybird-2.2.2 + OpenFire 3.8.1

There are errors, describe them more low.

Would like to receive recommendations about their correction.

The additional information (a configuration, scripts and other) - I will give.

My native language - Russian.

I will use therefore electronic transfer.

In advance I apologise for inconveniences.


Has established OpenFire.

FreeBSD 9.1-RELEASE i386

DB FireBird 2.5.2

java openjdk-7.17.02_2

jdbc driver Jaybird-2.2.2

OpenFire 3.8.1

Has created a DB.

Has edited openfire.xml


Has disconnected not the plug-ins necessary to me.

Has left the following:


Client Control

Content Filter

DB Access

Hazelcast Clustering Plugin

Just married

Load Statistic

Monitoring Service

Packet Filter

Presence Service



User Import Export

Has created two users.

Has got them in one group.

Has cleared broad gulls.

In the specified configuration has faced not clear problem.

For 12 hours per a file error.log has got 107.5 K messages

About problems with the table ofPubsubItem.


at org.firebirdsql.gds.impl.wire. AbstractJavaGDSImpl.readStatusVector (AbstractJavaGDSImpl.java:2214)

at org.firebirdsql.gds.impl.wire. AbstractJavaGDSImpl.receiveResponse (AbstractJavaGDSImpl.java:2164)

at org.firebirdsql.gds.impl.wire. AbstractJavaGDSImpl.iscDsqlPrepare (AbstractJavaGDSImpl.java:1551)

at org.firebirdsql.gds.impl. GDSHelper.prepareStatement (GDSHelper.java:190)

at org.firebirdsql.jdbc. AbstractStatement.prepareFixedStatement (AbstractStatement.java:1440)

at org.firebirdsql.jdbc. AbstractPreparedStatement.prepareFixedStatement (AbstractPreparedStatement.java:1281)

at org.firebirdsql.jdbc. AbstractPreparedStatement. (AbstractPreparedStatement.java:137)

… 20 more

2013.04.09 20:45:56 org.jivesoftware.openfire.pubsub. PubSubPersistenceManager - GDS Exception. 335544569. Dynamic SQL Error

SQL error code =-104

Token unknown - line 1, column 8


org.firebirdsql.jdbc. FBSQLException: GDS Exception. 335544569. Dynamic SQL Error

SQL error code =-104

Token unknown - line 1, column 8

I am incidentally connected by the client.

It “Miranda IM” or “Miranda NG”.

Last “stable”.

Other errors I do not observe.