java.sql.SQLSyntaxErrorException: incompatible data types in combination Error Code: -5562 Call: SELECT ID, RELEASE_DOMAIN, RELEASE_DATE, RELEASE_VERSION, MOD_DATE, MOD_USER_ID, REC_DATE, REC_USER_ID, DESCRIPTION, NAME FROM LC_RELEASED_VERSION WHERE ((((RELEASE_DOMAIN = ?) AND (RELEASE_VERSION = COALESCE(?,RELEASE_VERSION ))) AND (NAME = COALESCE(?,NAME ))) AND (RELEASE_DATE = COALESCE(?,RELEASE_DATE ))) bind => [4 parameters bound] Query: ReadAllQuery(name="ReleasedVersion.findByFilter" referenceClass=ReleasedVersion sql="SELECT ID, RELEASE_DOMAIN, RELEASE_DATE, RELEASE_VERSION, MOD_DATE, MOD_USER_ID, REC_DATE, REC_USER_ID, DESCRIPTION, NAME FROM LC_RELEASED_VERSION WHERE ((((RELEASE_DOMAIN = ?) AND (RELEASE_VERSION = COALESCE(?,RELEASE_VERSION ))) AND (NAME = COALESCE(?,NAME ))) AND (RELEASE_DATE = COALESCE(?,RELEASE_DATE )))")

hsqldb | kingpin0028 | 1 year ago
  1. 0

    incompatible data types in combination when using COALESCE in case of DATE type

    hsqldb | 1 year ago | kingpin0028
    java.sql.SQLSyntaxErrorException: incompatible data types in combination Error Code: -5562 Call: SELECT ID, RELEASE_DOMAIN, RELEASE_DATE, RELEASE_VERSION, MOD_DATE, MOD_USER_ID, REC_DATE, REC_USER_ID, DESCRIPTION, NAME FROM LC_RELEASED_VERSION WHERE ((((RELEASE_DOMAIN = ?) AND (RELEASE_VERSION = COALESCE(?,RELEASE_VERSION ))) AND (NAME = COALESCE(?,NAME ))) AND (RELEASE_DATE = COALESCE(?,RELEASE_DATE ))) bind => [4 parameters bound] Query: ReadAllQuery(name="ReleasedVersion.findByFilter" referenceClass=ReleasedVersion sql="SELECT ID, RELEASE_DOMAIN, RELEASE_DATE, RELEASE_VERSION, MOD_DATE, MOD_USER_ID, REC_DATE, REC_USER_ID, DESCRIPTION, NAME FROM LC_RELEASED_VERSION WHERE ((((RELEASE_DOMAIN = ?) AND (RELEASE_VERSION = COALESCE(?,RELEASE_VERSION ))) AND (NAME = COALESCE(?,NAME ))) AND (RELEASE_DATE = COALESCE(?,RELEASE_DATE )))")
  2. 0

    Unable to use decode function in order to transform datatype

    hsqldb | 2 years ago | pa38140
    java.sql.SQLSyntaxErrorException: incompatible data types in combination
  3. 0

    Hibernate one-to-many mapping integrity constraint violation

    Stack Overflow | 2 years ago | maskapsiz
    org.hsqldb.HsqlException: integrity constraint violation: NOT NULL check constraint; SYS_CT_10115 table: ACCOMMODATION_CATEGORY column: ACC_ID
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error while inserting/selecting in database , using hsqldb (hsqldb-20130206.203335-33) with hibernate3.1.3

    Stack Overflow | 3 years ago | Priyanka
    org.hsqldb.HsqlException: user lacks privilege or object not found: USERREGISTRATIONBEAN
  6. 0

    DbUnit + HSQLDB + JPA Entity: integrity constraint violation: unique constraint or index violation; UK_25T4P9GXGVRCC8R3VL93JKAJE table: NEW_TAB

    Stack Overflow | 2 years ago | user613114
    org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; UK_25T4P9GXGVRCC8R3VL93JKAJE table: NEW_TAB

  1. WoodenDoors 67 times, last 8 months ago
  2. kjhdofjosvs 1 times, last 1 week ago
  3. andyglick 2 times, last 3 weeks ago
  4. marcbouvierdav 1 times, last 2 months ago
87 unregistered visitors
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. org.hsqldb.HsqlException

    incompatible data types in combination

    at org.hsqldb.error.Error.error()
  2. HyperSQL Database
    Error.error
    1. org.hsqldb.error.Error.error(Unknown Source)
    2. org.hsqldb.error.Error.error(Unknown Source)
    2 frames
  3. HSQLDB
    Session.execute
    1. org.hsqldb.types.CharacterType.getAggregateType(Unknown Source)
    2. org.hsqldb.types.NumberType.getAggregateType(Unknown Source)
    3. org.hsqldb.types.Type.getAggregateType(Unknown Source)
    4. org.hsqldb.ExpressionOp.resolveTypesForCaseWhen(Unknown Source)
    5. org.hsqldb.ExpressionOp.resolveTypes(Unknown Source)
    6. org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    7. org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    8. org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    9. org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    10. org.hsqldb.QuerySpecification.resolveExpressionTypes(Unknown Source)
    11. org.hsqldb.QuerySpecification.resolveTypesPartOne(Unknown Source)
    12. org.hsqldb.QueryExpression.resolve(Unknown Source)
    13. org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
    14. org.hsqldb.ParserCommand.compilePart(Unknown Source)
    15. org.hsqldb.ParserCommand.compileStatement(Unknown Source)
    16. org.hsqldb.Session.compileStatement(Unknown Source)
    17. org.hsqldb.StatementManager.compile(Unknown Source)
    18. org.hsqldb.Session.execute(Unknown Source)
    18 frames