From users-return-8081-apmail-continuum-users-archive=continuum.apache.org@continuum.apache.org Mon Jun 14 15:05:19 2010 Return-Path: Delivered-To: apmail-continuum-users-archive@www.apache.org Received: (qmail 81975 invoked from network); 14 Jun 2010 15:05:19 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 14 Jun 2010 15:05:19 -0000 Received: (qmail 48257 invoked by uid 500); 14 Jun 2010 15:05:18 -0000 Delivered-To: apmail-continuum-users-archive@continuum.apache.org Received: (qmail 48160 invoked by uid 500); 14 Jun 2010 15:05:17 -0000 Mailing-List: contact users-help@continuum.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@continuum.apache.org Delivered-To: mailing list users@continuum.apache.org Received: (qmail 48152 invoked by uid 99); 14 Jun 2010 15:05:17 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Jun 2010 15:05:17 +0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FREEMAIL_FROM,SPF_HELO_PASS,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Jun 2010 15:05:11 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1OOBDX-0001r3-AW for users@continuum.apache.org; Mon, 14 Jun 2010 08:04:51 -0700 Message-ID: <28880702.post@talk.nabble.com> Date: Mon, 14 Jun 2010 08:04:51 -0700 (PDT) From: fherrerav To: users@continuum.apache.org Subject: Problems upgrading from 1.3.6 to 1.4 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: fherrerav@gmail.com 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.prepareInternalStatement(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.java: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(RDBMSManager.java:3076) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567) at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419) 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.getContinuumBuildDefinitionTemplateWithType(BuildDefinitionTemplateDaoImpl.java:143) at org.apache.maven.continuum.builddefinition.DefaultBuildDefinitionService.getContinuumDefaultWithType(DefaultBuildDefinitionService.java:262) -- View this message in context: http://old.nabble.com/Problems-upgrading-from-1.3.6-to-1.4-tp28880702p28880702.html Sent from the Continuum - Users mailing list archive at Nabble.com.