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

Fix MariaDB driver compatibility issues

    XMLWordPrintable

    Details

      Description

      When using MariaDB and the MariaDB Connector/J JDBC driver a few issues are identified and must be fixed.

      org.nuxeo.ecm.core.TestSQLRepositoryQuery.testBatching
      org.nuxeo.ecm.core.api.NuxeoException: Invalid query: SELECT * FROM Document ORDER BY ecm:name
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.query(JDBCMapper.java:849)
      	...
      	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingMapper.query(SoftRefCachingMapper.java:104)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.query(SessionImpl.java:1240)
      	at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.query(ConnectionImpl.java:335)
      	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.query(SQLSession.java:383)
      	at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1145)
      	at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1091)
      	at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1075)
      	at org.nuxeo.ecm.core.TestSQLRepositoryQuery.doBatching(TestSQLRepositoryQuery.java:794)
      	at org.nuxeo.ecm.core.TestSQLRepositoryQuery.testBatching(TestSQLRepositoryQuery.java:732)
      Caused by: java.sql.SQLDataException: (conn:162438) Current position is before the first row
      	at org.tranql.connector.jdbc.ResultSetHandle.getString(ResultSetHandle.java:586)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.dialect.Dialect.getFromResultSetString(Dialect.java:419)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.dialect.DialectMySQL.getFromResultSet(DialectMySQL.java:196)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.db.Column.getFromResultSet(Column.java:263)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.query(JDBCMapper.java:819)
      	... 67 more
      

      org.nuxeo.ecm.core.TestSQLRepositoryQuery.testQueryLimits has a similar error stack trace.

      org.nuxeo.ecm.core.storage.sql.TestSQLBackend.testDeadlockDetection also has a failure.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 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