Return-Path: Delivered-To: apmail-continuum-dev-archive@www.apache.org Received: (qmail 80865 invoked from network); 16 Jan 2010 06:26:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 16 Jan 2010 06:26:59 -0000 Received: (qmail 30899 invoked by uid 500); 16 Jan 2010 06:26:59 -0000 Delivered-To: apmail-continuum-dev-archive@continuum.apache.org Received: (qmail 30792 invoked by uid 500); 16 Jan 2010 06:26:59 -0000 Mailing-List: contact dev-help@continuum.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@continuum.apache.org Delivered-To: mailing list dev@continuum.apache.org Received: (qmail 30782 invoked by uid 99); 16 Jan 2010 06:26:58 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 16 Jan 2010 06:26:58 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of batkinson@usm.maine.edu designates 130.111.135.75 as permitted sender) Received: from [130.111.135.75] (HELO mail4.doit.usm.maine.edu) (130.111.135.75) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 16 Jan 2010 06:26:50 +0000 Received: from uct5.uct.usm.maine.edu (uct5.doit.usm.maine.edu [130.111.135.97]) by mail4.doit.usm.maine.edu (Postfix) with ESMTP id EEEE4B8BB4A for ; Sat, 16 Jan 2010 01:26:26 -0500 (EST) Received: from UCT5-MTA by uct5.uct.usm.maine.edu with Novell_GroupWise; Sat, 16 Jan 2010 01:26:26 -0500 Message-Id: <4B5115B80200009D0003878D@uct5.uct.usm.maine.edu> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Sat, 16 Jan 2010 01:26:15 -0500 From: "Brent Atkinson" To: Subject: Continuum 1.3.5 on Postgresql JDO boolean mapping Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__Part39132E17.0__=" --=__Part39132E17.0__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Hi, Can anyone explain why some boolean fields on SystemConfiguration are = encoded as booleans, while distributedBuildEnabled is encoded as Y/N = string?=20 The modello configuration for SystemConfiguration shows multiple boolean = fields: trunk/continuum-model/src/main/mdo/continuum.xml@899327 (lines 1280-1350) But for some reason distributedBuildEnabled is overridden to be of type = CHAR: trunk/continuum-model/src/main/resources/package-default.orm@899322 (lines = 6-12) It's causing the following error when attempting to upgrade a continuum = database from 1.2.3 to 1.3.5. Is there a good reason why distributedBuildEn= abled is explicity encoded as a CHAR? Thanks, Brent Exception in thread "main" javax.jdo.JDODataStoreException: Insert request = failed: INSERT INTO "SYSTEMCONFIGURATION" ("SYSTEMCONFIGURATION_ID","WORKIN= G_DIRECTORY","DEPLOYMENT_REPOSITORY_DIRECTORY","DEFAULT_SCHEDULE_DESCRIPTIO= N","NUMBER_OF_BUILDS_IN_PARALLEL","DEFAULT_SCHEDULE_CRON_EXPRESSION","RELEA= SE_OUTPUT_DIRECTORY","BUILD_OUTPUT_DIRECTORY","BASE_URL","GUEST_ACCOUNT_ENA= BLED","DISTRIBUTED_BUILD_ENABLED","INITIALIZED") VALUES (?,?,?,?,?,?,?,?,?,= ?,?,?) at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest= .java:455) at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:251= 9) at org.jpox.store.StoreManager.insert(StoreManager.java:920) at org.jpox.state.StateManagerImpl.internalMakePersistent(StateMana= gerImpl.java:3647) at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.= java:3626) at org.jpox.AbstractPersistenceManager.internalMakePersistent(Abstr= actPersistenceManager.java:1198) at org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersi= stenceManager.java:1261) at org.codehaus.plexus.jdo.PlexusJdoUtils.addObject(PlexusJdoUtils.= java:97) at org.codehaus.plexus.jdo.PlexusJdoUtils.addObject(PlexusJdoUtils.= java:78) at org.apache.maven.continuum.management.JdoDataManagementTool.rest= oreDatabase(JdoDataManagementTool.java:263) at org.apache.maven.continuum.management.DataManagementCli.processD= atabase(DataManagementCli.java:314) at org.apache.maven.continuum.management.DataManagementCli.main(Dat= aManagementCli.java:189) NestedThrowablesStackTrace: org.postgresql.util.PSQLException: ERROR: column "DISTRIBUTED_BUILD_ENABLED= " is of type character but expression is of type boolean at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(Qu= eryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExe= cutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorIm= pl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc= 2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abs= tractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(Abstra= ctJdbc2Statement.java:305) at org.jpox.store.rdbms.RDBMSManager.executeStatementUpdate(RDBMSMa= nager.java:572) at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest= .java:328) at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:251= 9) at org.jpox.store.StoreManager.insert(StoreManager.java:920) at org.jpox.state.StateManagerImpl.internalMakePersistent(StateMana= gerImpl.java:3647) at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.= java:3626) at org.jpox.AbstractPersistenceManager.internalMakePersistent(Abstr= actPersistenceManager.java:1198) at org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersi= stenceManager.java:1261) at org.codehaus.plexus.jdo.PlexusJdoUtils.addObject(PlexusJdoUtils.= java:97) at org.codehaus.plexus.jdo.PlexusJdoUtils.addObject(PlexusJdoUtils.= java:78) at org.apache.maven.continuum.management.JdoDataManagementTool.rest= oreDatabase(JdoDataManagementTool.java:263) at org.apache.maven.continuum.management.DataManagementCli.processD= atabase(DataManagementCli.java:314) --=__Part39132E17.0__=--