You have encountered <http://jira.codehaus.org/browse/CONTINUUM-2519>.
We use Postgresql, so I was able to make the table update manually. I don't know how to do this with Derby, however. Steve C On 15/06/10 1:04 AM, "fherrerav" <[email protected]> wrote: > > I installed 1.4 and copied the old database from 1.3.6 but when I start > continuum I get this error. Is there an utility to migrate db from 1.3.6 to > 1.4? > > 2010-06-14 10:45:52,241 [WrapperSimpleAppMain] ERROR JPOX.RDBMS - Error > thrown executing ALTER TABLE BUILDDEFINITION ADD UPDATE_POLICY INTEGER NOT > NULL : In an ALTER TABLE statement, the column 'UPDATE_POLICY' has been > specified as NOT NULL and either the DEFAULT clause was not specified or was > specified as DEFAULT NULL. > ERROR 42601: In an ALTER TABLE statement, the column 'UPDATE_POLICY' has > been specified as NOT NULL and either the DEFAULT clause was not specified > or was specified as DEFAULT NULL. > at > org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > at > org.apache.derby.impl.sql.compile.ColumnDefinitionNode.bindAndValidateDefault( > Unknown > Source) > at > org.apache.derby.impl.sql.compile.TableElementList.validate(Unknown Source) > at org.apache.derby.impl.sql.compile.AlterTableNode.bind(Unknown > Source) > at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown > Source) > at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown > Source) > at > org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInterna > lStatement(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at > org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.jav > a:614) > at > org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable > .java:570) > at > org.jpox.store.rdbms.table.TableImpl.validateColumns(TableImpl.java:256) > at > org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSMana > ger.java:3076) > at > org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSMa > nager.java:3326) > at > org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567) > at > org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:24 > 19) > at > org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824) > at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838) > at > org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1218) > at > org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1357) > at > org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java: > 2328) > at > org.apache.continuum.dao.BuildDefinitionTemplateDaoImpl.getContinuumBuildDefin > itionTemplateWithType(BuildDefinitionTemplateDaoImpl.java:143) > at > org.apache.maven.continuum.builddefinition.DefaultBuildDefinitionService.getCo > ntinuumDefaultWithType(DefaultBuildDefinitionService.java:262)
