java.sql.SQLDataException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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].
    via by Julien Hoarau,
  • 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].
    via by Julien Hoarau,
  • oracle 9i problems
    via symmetricds by wuliwei
    ,
    • 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)
    No Bugmate found.