You might want to check out <http://jira.codehaus.org/browse/CONTINUUM-2520> while you're at it...
On 15/06/10 10:31 AM, "Brett Porter" <[email protected]> wrote: > 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.bindAndValidateDefaul >>> t( >>> 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.prepareInter >>> na >>> 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.j >>> av >>> a:614) >>> at >>> org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTab >>> le >>> .java:570) >>> at >>> org.jpox.store.rdbms.table.TableImpl.validateColumns(TableImpl.java:256) >>> at >>> org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSMa >>> na >>> ger.java:3076) >>> at >>> org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMS >>> Ma >>> 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.jav >>> a: >>> 2328) >>> at >>> org.apache.continuum.dao.BuildDefinitionTemplateDaoImpl.getContinuumBuildDef >>> in >>> itionTemplateWithType(BuildDefinitionTemplateDaoImpl.java:143) >>> at >>> org.apache.maven.continuum.builddefinition.DefaultBuildDefinitionService.get >>> Co >>> ntinuumDefaultWithType(DefaultBuildDefinitionService.java:262) >> > > -- > Brett Porter > [email protected] > http://brettporter.wordpress.com/ > > > >
