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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via hsqldb by kingpin0028
, 1 year ago
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 sourceforge.net by Unknown author, 2 years ago
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 3537744, 4 months ago
= ?) AND (PASSWORD = ?)) AND (STATUS = ?)) bind => [xxxx @yyyy.com , weblogic, APPROVED] Query: ReadAllQuery(referenceClass=Patient sql="SELECT ID, DOB, EMAIL, GENDER, PASSWORD, PHONE, SSN, STATUS, USERNAME, VERSION, CITY, COUNTRY, STATE, STREET1, STREET2, ZIP, FIRSTNAME, LASTNAME, MIDDLENAME FROM patients WHERE (((USERNAME = ?) AND (PASSWORD = ?)) AND (STATUS = ?))")
via Stack Overflow by IneedYOURhelp
, 8 months ago
Tabela/widok 'APP.KSIĘGARNIA' nie istnieje. Error Code: 30000 Call: SELECT ID FROM APP.KSIĘGARNIA Query: ReadAllQuery(referenceClass=Księgarnia sql="SELECT ID FROM APP.KSIĘGARNIA")
via Stack Overflow by yamciayamcia
, 2 months ago
Błąd składniowy: Encountered "USER" at line 1, column 52. Error Code: 30000 Call: SELECT ID, EMAIL, IMIE, NAZWISKO, UPRAWNIENIA FROM USER Query: ReadAllQuery(referenceClass=User sql="SELECT ID, EMAIL, IMIE, NAZWISKO, UPRAWNIENIA FROM USER")
via Stack Overflow by Grizzly
, 1 month ago
ORA-00904: "PHONE": invalid identifier Error Code: 904 Call: SELECT CID, address, age, email, firstname, lastname, phone FROM Client Query: ReadAllQuery(referenceClass=Client sql="SELECT CID, address, age, email, firstname, lastname, phone FROM Client")
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)

Users with the same issue

Once, 2 months ago
5 times, 3 months ago
2 times, 6 months ago
2 times, 7 months ago
24 times, 8 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.