continuum-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brent Atkinson" <batkin...@usm.maine.edu>
Subject Continuum 1.3.5 on Postgresql JDO boolean mapping
Date Sat, 16 Jan 2010 06:26:15 GMT
Hi,

Can anyone explain why some boolean fields on SystemConfiguration are encoded as booleans,
while distributedBuildEnabled is encoded as Y/N string? 

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 distributedBuildEnabled is explicity encoded as a CHAR?

Thanks,

Brent

Exception in thread "main" javax.jdo.JDODataStoreException: Insert request failed: INSERT
INTO "SYSTEMCONFIGURATION" ("SYSTEMCONFIGURATION_ID","WORKING_DIRECTORY","DEPLOYMENT_REPOSITORY_DIRECTORY","DEFAULT_SCHEDULE_DESCRIPTION","NUMBER_OF_BUILDS_IN_PARALLEL","DEFAULT_SCHEDULE_CRON_EXPRESSION","RELEASE_OUTPUT_DIRECTORY","BUILD_OUTPUT_DIRECTORY","BASE_URL","GUEST_ACCOUNT_ENABLED","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:2519)
        at org.jpox.store.StoreManager.insert(StoreManager.java:920)
        at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3647)
        at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3626)
        at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1198)
        at org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.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.restoreDatabase(JdoDataManagementTool.java:263)
        at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:314)
        at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.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(QueryExecutorImpl.java:1548)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305)
        at org.jpox.store.rdbms.RDBMSManager.executeStatementUpdate(RDBMSManager.java:572)
        at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:328)
        at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2519)
        at org.jpox.store.StoreManager.insert(StoreManager.java:920)
        at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3647)
        at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3626)
        at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1198)
        at org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.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.restoreDatabase(JdoDataManagementTool.java:263)
        at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:314)


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message