2005-07-12 problem

error.log says:

2005.07.13 02:00:56 org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnection Manager.java:342) Database upgrade failed. Please manually upgrade your database.

java.sql.SQLException: Column constraints are not acceptable in statement

at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)

at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)

at org.jivesoftware.database.DbConnectionManager.upgradeDatabase(DbConnectionManag er.java:745)

at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:339)

at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:89)

at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:269)

at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:67)

at org.jivesoftware.util.JiveProperties.(XMPPServer.java:117)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessor Impl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructor AccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:494)

at java.lang.Class.newInstance0(Class.java:350)

at java.lang.Class.newInstance(Class.java:303)

at org.jivesoftware.messenger.starter.ServerStarter.start(ServerStarter.java:82)

at org.jivesoftware.messenger.starter.ServerStarter.main(ServerStarter.java:46)

/code

Hey Alexander,

Thanks for the bug report. The problem was that HSQLDB does not set a default value to columns that are NOT NULL. In the next nightly build you will find a fix for this problem. You may need to restore the 2.1.5 database and try again doing the update.

Thanks,

– Gato