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.
- depends on
-
NXP-21350 Use specific template and JDBC driver for MariaDB
- Resolved