Thanks for the report - this is usually a pretty easy fix so we can include it in 1.4.1.
- Brett On 15/06/2010, at 10:18 AM, Stephen Coy wrote: > 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) > -- Brett Porter [email protected] http://brettporter.wordpress.com/
