java.sql.SQLDataException: ORA-01424: missing or illegal character following the escape character

Atlassian JIRA | Julien Hoarau | 2 years ago
  1. 0

    DatabaseNameHelper will fail in Oracle with error {{ORA-01424: missing or illegal character following the escape character}} when there is some table with special characters in their name. {noformat} Caused by: org.springframework.dao.DataIntegrityViolationException: ConnectionCallback; SQL []; ORA-01424: missing or illegal character following the escape character ; nested exception is java.sql.SQLDataException: ORA-01424: missing or illegal character following the escape character at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:78) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:349) at com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl$1.get(DatabaseNameHelperImpl.java:103) at com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl$1.get(DatabaseNameHelperImpl.java:96) at com.google.common.base.Suppliers$MemoizingSupplier.get(Suppliers.java:109) at com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl.getCaseSensitiveName(DatabaseNameHelperImpl.java:85) at com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl.getCaseSensitiveTableName(DatabaseNameHelperImpl.java:64) at com.atlassian.confluence.plugins.questions.repository.querydsl.AbstractRelationalPathBase.<init>(AbstractRelationalPathBase.java:14) at com.atlassian.confluence.plugins.questions.repository.querydsl.ContentTable.<init>(ContentTable.java:28) at com.atlassian.confluence.plugins.questions.repository.querydsl.QueryDSLMapper$7.apply(QueryDSLMapper.java:69) at com.atlassian.confluence.plugins.questions.repository.querydsl.QueryDSLMapper$7.apply(QueryDSLMapper.java:65) at com.atlassian.confluence.plugins.questions.repository.querydsl.QueryDSLMapper.getMapping(QueryDSLMapper.java:50) at com.atlassian.confluence.plugins.questions.internal.upgrade.DuplicatedAcceptedAnswersRemover.deleteDuplicatedAcceptedAnswers(DuplicatedAcceptedAnswersRemover.java:40) at com.atlassian.confluence.plugins.questions.internal.upgrade.AnswerAcceptanceMigrationToAoUpgradeTask.upgrade(AnswerAcceptanceMigrationToAoUpgradeTask.java:66) {noformat} *Workaround:* Uninstall version 1.0.618 and then install version 1.0.469, [available here|https://marketplace.atlassian.com/plugins/com.atlassian.confluence.plugins.confluence-questions/versions].

    Atlassian JIRA | 2 years ago | Julien Hoarau
    java.sql.SQLDataException: ORA-01424: missing or illegal character following the escape character
  2. 0

    DatabaseNameHelper will fail in Oracle with error {{ORA-01424: missing or illegal character following the escape character}} when there is some table with special characters in their name. {noformat} Caused by: org.springframework.dao.DataIntegrityViolationException: ConnectionCallback; SQL []; ORA-01424: missing or illegal character following the escape character ; nested exception is java.sql.SQLDataException: ORA-01424: missing or illegal character following the escape character at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:78) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:349) at com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl$1.get(DatabaseNameHelperImpl.java:103) at com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl$1.get(DatabaseNameHelperImpl.java:96) at com.google.common.base.Suppliers$MemoizingSupplier.get(Suppliers.java:109) at com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl.getCaseSensitiveName(DatabaseNameHelperImpl.java:85) at com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl.getCaseSensitiveTableName(DatabaseNameHelperImpl.java:64) at com.atlassian.confluence.plugins.questions.repository.querydsl.AbstractRelationalPathBase.<init>(AbstractRelationalPathBase.java:14) at com.atlassian.confluence.plugins.questions.repository.querydsl.ContentTable.<init>(ContentTable.java:28) at com.atlassian.confluence.plugins.questions.repository.querydsl.QueryDSLMapper$7.apply(QueryDSLMapper.java:69) at com.atlassian.confluence.plugins.questions.repository.querydsl.QueryDSLMapper$7.apply(QueryDSLMapper.java:65) at com.atlassian.confluence.plugins.questions.repository.querydsl.QueryDSLMapper.getMapping(QueryDSLMapper.java:50) at com.atlassian.confluence.plugins.questions.internal.upgrade.DuplicatedAcceptedAnswersRemover.deleteDuplicatedAcceptedAnswers(DuplicatedAcceptedAnswersRemover.java:40) at com.atlassian.confluence.plugins.questions.internal.upgrade.AnswerAcceptanceMigrationToAoUpgradeTask.upgrade(AnswerAcceptanceMigrationToAoUpgradeTask.java:66) {noformat} *Workaround:* Uninstall version 1.0.618 and then install version 1.0.469, [available here|https://marketplace.atlassian.com/plugins/com.atlassian.confluence.plugins.confluence-questions/versions].

    Atlassian JIRA | 2 years ago | Julien Hoarau
    java.sql.SQLDataException: ORA-01424: missing or illegal character following the escape character
  3. 0

    D2RQException: Database exception (E43)

    Google Groups | 3 years ago | R Wiethorn
    de.fuberlin.wiwiss.d2rq.D2RQException: Database exception (E43)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Exception when tried running the connector in standalone

    Google Groups | 6 months ago | Cherupally Bhargav
    java.sql.SQLDataException: ORA-01424: missing or illegal character following the escape character*
  6. 0

    java.sql.SQLDataException: ORA-01424: missing or illegal character following the escape character

    Stack Overflow | 5 months ago | user1723583
    java.sql.SQLDataException: ORA-01424: missing or illegal character following the escape character

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLDataException

      ORA-01424: missing or illegal character following the escape character

      at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate()
    2. Spring Framework
      JdbcTemplate.execute
      1. org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:78)
      2. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
      3. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      4. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:349)
      4 frames
    3. com.atlassian.confluence
      DatabaseNameHelperImpl$1.get
      1. com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl$1.get(DatabaseNameHelperImpl.java:103)
      2. com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl$1.get(DatabaseNameHelperImpl.java:96)
      2 frames
    4. Guava
      Suppliers$MemoizingSupplier.get
      1. com.google.common.base.Suppliers$MemoizingSupplier.get(Suppliers.java:109)
      1 frame
    5. com.atlassian.confluence
      AnswerAcceptanceMigrationToAoUpgradeTask.upgrade
      1. com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl.getCaseSensitiveName(DatabaseNameHelperImpl.java:85)
      2. com.atlassian.confluence.plugins.questions.util.DatabaseNameHelperImpl.getCaseSensitiveTableName(DatabaseNameHelperImpl.java:64)
      3. com.atlassian.confluence.plugins.questions.repository.querydsl.AbstractRelationalPathBase.<init>(AbstractRelationalPathBase.java:14)
      4. com.atlassian.confluence.plugins.questions.repository.querydsl.ContentTable.<init>(ContentTable.java:28)
      5. com.atlassian.confluence.plugins.questions.repository.querydsl.QueryDSLMapper$7.apply(QueryDSLMapper.java:69)
      6. com.atlassian.confluence.plugins.questions.repository.querydsl.QueryDSLMapper$7.apply(QueryDSLMapper.java:65)
      7. com.atlassian.confluence.plugins.questions.repository.querydsl.QueryDSLMapper.getMapping(QueryDSLMapper.java:50)
      8. com.atlassian.confluence.plugins.questions.internal.upgrade.DuplicatedAcceptedAnswersRemover.deleteDuplicatedAcceptedAnswers(DuplicatedAcceptedAnswersRemover.java:40)
      9. com.atlassian.confluence.plugins.questions.internal.upgrade.AnswerAcceptanceMigrationToAoUpgradeTask.upgrade(AnswerAcceptanceMigrationToAoUpgradeTask.java:66)
      9 frames