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

Cannot disable ACL optimizations on Oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.4
    • Fix Version/s: 5.4.1
    • Component/s: Core VCS

      Description

      When disabling ACL optimizations with an oracle server, an exception is thrown during the database setup :

      Caused by: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
      at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
      at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
      at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1890)
      at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1855)
      at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304)
      at org.nuxeo.ecm.core.storage.sql.jdbc.dialect.SQLStatement.execute(SQLStatement.java:279)
      at org.nuxeo.ecm.core.storage.sql.jdbc.SQLInfo.executeSQLStatements(SQLInfo.java:1200)
      at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createTables(JDBCMapper.java:333)
      at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createDatabase(JDBCMapper.java:141)
      ... 74 more

      The corresponding executed sql statement is

      ALTER TRIGGER nx_trig_acls_modified DISABLE;

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: