java.sql.SQLSyntaxErrorException: incompatible data types in combination

hsqldb | brianwhu | 3 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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