continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brett Porter <br...@apache.org>
Subject Re: Problems upgrading from 1.3.6 to 1.4
Date Tue, 15 Jun 2010 00:31:37 GMT
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" <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)
> 

--
Brett Porter
brett@apache.org
http://brettporter.wordpress.com/





Mime
View raw message