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:44:54 GMT
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" <brett@apache.org> 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" <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.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
> brett@apache.org
> http://brettporter.wordpress.com/
> 
> 
> 
> 


Mime
View raw message