java.sql.SQLSyntaxErrorException: incompatible data types in combination

hsqldb | pa38140 | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Unable to use decode function in order to transform datatype

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

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

    hsqldb | 2 years 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 )))")
  3. 0

    HyperSQL Database Engine (HSQLDB) / Discussion / Help:org.hsqldb.HsqlException: bad TEXT table sour

    sourceforge.net | 1 year ago
    org.hsqldb.HsqlException: data exception: invalid datetime format
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 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

  1. WoodenDoors 67 times, last 10 months ago
  2. jpvee 4 times, last 2 months ago
  3. kjhdofjosvs 1 times, last 3 months ago
  4. andyglick 2 times, last 3 months ago
  5. marcbouvierdav 1 times, last 4 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.NumberType.getAggregateType(Unknown Source)
    2. org.hsqldb.types.Type.getAggregateType(Unknown Source)
    3. org.hsqldb.ExpressionOp.resolveTypesForCaseWhen(Unknown Source)
    4. org.hsqldb.ExpressionOp.resolveTypes(Unknown Source)
    5. org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    6. org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    7. org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    8. org.hsqldb.QuerySpecification.resolveExpressionTypes(Unknown Source)
    9. org.hsqldb.QuerySpecification.resolveTypesPartOne(Unknown Source)
    10. org.hsqldb.QueryExpression.resolve(Unknown Source)
    11. org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
    12. org.hsqldb.ParserCommand.compilePart(Unknown Source)
    13. org.hsqldb.ParserCommand.compileStatements(Unknown Source)
    14. org.hsqldb.Session.executeDirectStatement(Unknown Source)
    15. org.hsqldb.Session.execute(Unknown Source)
    15 frames