Error when loading wildfire_sybase.sql


We are using a sybase database and we wanted to upgrade Wildfire from version 2.6.2 to 3.0.1, but Wildfire was not able to upgrade the database due to the following error:

com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near ‘’;’’. (The same error occurs also if we start from scratch and try to recreate the database schema)

I saw that indeed, there is a special treatment for oracle database to remove the ‘’;’’ at the end of each instruction, and this is not be done for sybase database. Do you think it would be possible to do the same thing for sybase so I don’'t have to upgrade my database manually ?

Please note also that sybase does not support NVARCHAR with a size upper 255, so the table jiveSASLAuthorized, pubsubNode, pubsubAffiliation, pubsubItem and pubsubSubscription trigger an error. I have reduce the size of the column concerned, do you think it can trigger errors?

Please note my configuration details:



Hi Mélanie,

I did create JM-856 to get this fixed.

Do you also need “Go” statements after the CREATE and the INSERT statements?


Thanks for looking into this issue. Yes, you will need to add go at the end of the statement.

I noticed another error also, which is relatd to the sybase database. On logon I got the following error:

com.sybase.jdbc3.jdbc.SybSQLException: Implicit conversion from datatype ‘‘TEXT’’ to ‘‘VARCHAR’’ is not allowed. Use the CONVERT function

to run this query.

at com.sybase.jdbc3.tds.Tds.processEed(

at com.sybase.jdbc3.tds.Tds.nextResult(

at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(

at com.sybase.jdbc3.jdbc.SybStatement.nextResult(

at com.sybase.jdbc3.jdbc.SybStatement.nextResult(

at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(

at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(

at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.ja va:97)


at 231)

at org.jivesoftware.wildfire.roster.RosterManager.getSharedGroups(RosterManager.ja va:169)

at org.jivesoftware.wildfire.roster.Roster.(

at org.jivesoftware.wildfire.roster.RosterManager.getRoster(

at org.jivesoftware.wildfire.user.User.getRoster(

at org.jivesoftware.wildfire.handler.IQRosterHandler.manageRoster(IQRosterHandler. java:187)

at org.jivesoftware.wildfire.handler.IQRosterHandler.handleIQ( :104)

at org.jivesoftware.wildfire.handler.IQHandler.process(

at org.jivesoftware.wildfire.IQRouter.handle(

at org.jivesoftware.wildfire.IQRouter.route(

at org.jivesoftware.wildfire.PacketRouter.route(


at ava:50)



at Source)

Could you fix also this query issue in the meantime ? We want to upgarde our wildfire server in production, but I would like to wait for this bug fixes to do so. In which version do you think this will be available ?

Thank you,


Just one correction, there is no need to add go at the end of each statement. Just remove the “;”. I believe the ‘‘go’’ is implicitly done when executing the satement with the sybase driver.