continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Coy <steve....@axegroup.com.au>
Subject Re: Problems upgrading from 1.3.6 to 1.4
Date Tue, 15 Jun 2010 00:18:47 GMT
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" <fherrerav@gmail.com> 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)


Mime
View raw message