Ok, I'll wait for the fix
Thanks brettporter 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.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/ > > > > > > -- View this message in context: http://old.nabble.com/Problems-upgrading-from-1.3.6-to-1.4-tp28880702p28891294.html Sent from the Continuum - Users mailing list archive at Nabble.com.
