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

PostgreSQL JDBC driver upgrade required for running PostgreSQL version 9.6

    XMLWordPrintable

    Details

      Description

      Running previous of JDBC driver on postgresql 9.6 will produce errors while initializing indexes

      Caused by: org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist
      Position: 407
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
      at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getIndexInfo(AbstractJdbc2DatabaseMetaData.java:4202)
      at org.tranql.connector.jdbc.DatabaseMetaDataHandle.getIndexInfo(DatabaseMetaDataHandle.java:119)
      at org.hibernate.tool.hbm2ddl.TableMetadata.initIndexes(TableMetadata.java:167)
      at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:61)
      at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:113)

      Using that version of the drive https://jdbc.postgresql.org/download/postgresql-42.1.1.jar solve the errors.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours
                  2h