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" <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/
>
>
>
>
>
>
--
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.
|