Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-17623

Fix h2 error at startup when defining a field named "check"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 7.4-SNAPSHOT
    • Fix Version/s: Postponed
    • Component/s: Core

      Description

      Steps to reproduce:

      • in Studio, create a document, and add a custom field named "check"
      • install the Studio package (hot reload) -> no issue
      • restart the server
        => error at startup (see attached server log)
      2015-07-31 17:49:58,468 ERROR [persistence-init-NXUIDSequencer] [org.apache.geronimo.connector.outbound.MCFConnectionInterceptor] Error occurred creating ManagedConnection for handle: nullManagedConnectionInfo: org.apache.geronimo.connector.outbound.ManagedConnectionInfo@20617f5. mc: null]
      javax.resource.spi.ResourceAllocationException: Unable to obtain physical connection to jdbc:h2:/opt/nuxeo-cap-7.4-SNAPSHOT-tomcat/nxserver/data/h2/nuxeo;DB_CLOSE_ON_EXIT=false
      	at org.tranql.connector.jdbc.JDBCDriverMCF.getPhysicalConnection(JDBCDriverMCF.java:105)
      	at org.tranql.connector.jdbc.JDBCDriverMCF.createManagedConnection(JDBCDriverMCF.java:80)
      	at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:49)
      	at org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterceptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)
      	at org.apache.geronimo.connector.outbound.SinglePoolMatchAllConnectionInterceptor.internalGetConnection
      
      [...]
      
      2015-07-31 17:49:58,470 WARN  [persistence-init-NXUIDSequencer] [org.hibernate.cfg.SettingsFactory] Could not obtain connection to query metadata
      org.h2.jdbc.JdbcSQLException: Column "BOOLEAN" not found; SQL statement:
      CREATE CACHED TABLE PUBLIC.TCRR(
          ID VARCHAR(36) NOT NULL,
          SUB VARCHAR,
          CHECK BOOLEAN
      ) [42122-177]
      

        Attachments

        1. server.log
          84 kB
          Anahide Tchertchian

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: