org.postgresql.util.PSQLException

ERROR: column "DISTRIBUTED_BUILD_ENABLED" is of type character but expression is of type boolean

Samebug tips1

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web3422

  • via continuum-dev by Brent Atkinson, 9 months ago
    ERROR: column "DISTRIBUTED_BUILD_ENABLED" is of type character but expression is of type boolean
  • via Google Groups by j.random.programmer, 1 day ago
    ERROR: column "bit_val" is of type bit but expression is of type character varying
  • via Google Groups by posztos, 4 weeks ago
    ERROR: column "valid" is of type character but expression is of type boolean Hint: You will need to rewrite or cast the expression. Position: 43
  • Stack trace

    • 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Once, 6 hours ago
    2 times, 1 month ago
    25 times, 7 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    93 more bugmates