java.sql.SQLSyntaxErrorException: incompatible data types in combination

hsqldb | brianwhu | 2 years ago
  1. 0

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

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

    [OpenEJB-users] websphere MQ - Grokbase

    grokbase.com | 11 months ago
    java.sql.SQLSyntaxErrorException: incompatible data type in conversion: from SQL type OTHER to [B, value: instance of org.hsqldb.types.JavaObjectData at org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:33) at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getLastMessageBrokerSequenceId(JDBCPersistenceAdapter.java:263) at org.apache.activemq.broker.region.DestinationFactoryImpl.getLastMessageBrokerSequenceId(DestinationFactoryImpl.java:145) at org.apache.activemq.broker.region.RegionBroker.(BrokerService.java:1999) at org.apache.activemq.broker.BrokerService.createRegionBroker(BrokerService.java:1990) at org.apache.activemq.broker.BrokerService.createBroker(BrokerService.java:1947) at org.apache.activemq.broker.BrokerService.getBroker(BrokerService.java:802) at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.start(JDBCPersistenceAdapter.java:314)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Zipkin server does not work with MySQL 5.7

    GitHub | 1 month ago | ajacques
    java.sql.SQLSyntaxErrorException: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Zipkin.a.endpoint_service_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 11/3/2016 10:00:03 PMQuery is : SELECT * FROM (select distinct s.trace_id, s.parent_id, s.id, a.a_key, a.endpoint_service_name from zipkin_spans s left outer join zipkin_annotations a on (s.trace_id = a.trace_id and s.id = a.span_id and a.a_key in ('ca', 'cs', 'sr', 'sa')) where s.start_ts between 1478217600000000 and 1478303999999999 group by s.trace_id, s.id, a.a_key) as link_spans WHERE 1=0
  6. 0

    HyperSQL Database Engine (HSQLDB) / Mailing Lists

    sourceforge.net | 4 months ago
    java.sql.SQLSyntaxErrorException: data type of expression is not boolean

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