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 )))")

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web566

  • 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
  • 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
  • via Oracle Community by sdoca, 11 months ago
    ", "STATE" FROM "EJB__TIMER__TBL" WHERE (("OWNERID" = ?) AND ("STATE" = ?)) bind => [2 parameters bound] Query: ReadAllQuery(name="findTimersByOwnerAndState" referenceClass=TimerState sql="SELECT "TIMERID", "APPLICATIONID", "BLOB", "CONTAINERID
  • Stack trace

    • 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 )))") at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2740) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2693) at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:541) at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1173) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904) at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1132) at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:442) at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1220) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804) at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258) Caused by: java.sql.SQLSyntaxErrorException: incompatible data types in combination at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1565) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1514) at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:778) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:621) ... 22 more Caused by: org.hsqldb.HsqlException: incompatible data types in combination at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.types.CharacterType.getAggregateType(Unknown Source) at org.hsqldb.types.NumberType.getAggregateType(Unknown Source) at org.hsqldb.types.Type.getAggregateType(Unknown Source) at org.hsqldb.ExpressionOp.resolveTypesForCaseWhen(Unknown Source) at org.hsqldb.ExpressionOp.resolveTypes(Unknown Source) at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source) at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source) at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source) at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source) at org.hsqldb.QuerySpecification.resolveExpressionTypes(Unknown Source) at org.hsqldb.QuerySpecification.resolveTypesPartOne(Unknown Source) at org.hsqldb.QueryExpression.resolve(Unknown Source) at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatement(Unknown Source) at org.hsqldb.Session.compileStatement(Unknown Source) at org.hsqldb.StatementManager.compile(Unknown Source) at org.hsqldb.Session.execute(Unknown Source)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    67 times, 1 year ago
    Unknown user
    Once, 1 year ago
    92 more bugmates