java.sql.SQLSyntaxErrorException: incompatible data types in combination

hsqldb | brianwhu | 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

    Prepared statement with placeholders: SQLSyntaxErrorException: incompatible data types in combination

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

    HSQL error when testing with JUnit

    Stack Overflow | 3 years ago | Michlis
    java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: MICOM_CHARACTERISTICS Error Code: -5501 Call: SELECT ID, NAME, RANGE_IDS, RANGE_NAMES, FUNCTIONALITY FROM MICOM_CHARACTERISTICS ORDER BY ID ASC Query: ReadAllQuery(name="Characteristic.findAll" referenceClass=Characteristic sql="SELECT ID, NAME, RANGE_IDS, RANGE_NAMES, FUNCTIONALITY FROM MICOM_CHARACTERISTICS ORDER BY ID ASC")

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      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
      JDBCConnection.prepareStatement
      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.ParserDML.resolveUpdateExpressions(Unknown Source)
      7. org.hsqldb.ParserDML.compileUpdateStatement(Unknown Source)
      8. org.hsqldb.ParserCommand.compilePart(Unknown Source)
      9. org.hsqldb.ParserCommand.compileStatement(Unknown Source)
      10. org.hsqldb.Session.compileStatement(Unknown Source)
      11. org.hsqldb.StatementManager.compile(Unknown Source)
      12. org.hsqldb.Session.execute(Unknown Source)
      13. org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
      14. org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
      14 frames