net.ucanaccess.jdbc.UcanaccessSQLException: unknown token:

[Daniele Renda]

I'm doing this query:

SELECT app.ID_APPUNTAMENTO as id_appuntamento, app.DESCRIZIONE as descrizione, app.DATA as data, app.DALLE as oraInizio, app.ALLE as oraFine, app.DESC_TIPOAPP as tipologia,app.FORECOLOR as colore,app.BACKCOLOR as sfondo,app.NOTE as nota,app.ID_PAZIENTE as id_paziente, paz.NOME as nome, paz.COGNOME as cognome, paz.TELEFONOABITAZIONE as tel, paz.TELEFONOUFFICIO as uff, paz.FAX as cell, paz.E_MAIL as email,paz.TITOLO as titolo, paz.SESSO as sesso, app.ID_POLTRONA as studio FROM AGENDA as app LEFT JOIN PAZIENTI as paz ON app.ID_PAZIENTE=paz.ID_PAZIENTE WHERE 1 AND ( app.DATA=#07-03-2015#) AND ( app.FORECOLOR = 1 OR app.FORECOLOR = 2 OR app.FORECOLOR = 3 OR app.FORECOLOR = 4 OR app.FORECOLOR = 5 OR app.FORECOLOR = 6 OR app.FORECOLOR = 7 OR app.FORECOLOR = 8 OR app.FORECOLOR = 9 OR app.FORECOLOR = 10 OR app.FORECOLOR = 11 OR app.FORECOLOR = 12 OR app.FORECOLOR = 13 OR app.FORECOLOR = 14 OR app.FORECOLOR = 15 OR app.FORECOLOR = 16 OR app.FORECOLOR = 17 OR app.FORECOLOR = 18 OR app.FORECOLOR = 0) ORDER BY app.DATA,app.DALLE

But I've this exception:

Caused by: net.ucanaccess.jdbc.UcanaccessSQLException: unknown token:
at net.ucanaccess.jdbc.UcanaccessStatement.executeQuery(UcanaccessStatement.java:202) ~[?:?]
at it.pianetatecno.ecall.plugins.orisdentmdb.OrisdentMdb.getAppuntamenti(OrisdentMdb.java:194) ~[?:?]
... 25 more
Caused by: java.sql.SQLSyntaxErrorException: unknown token:
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[?:?]
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[?:?]
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) ~[?:?]
at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source) ~[?:?]
at net.ucanaccess.jdbc.UcanaccessStatement.executeQuery(UcanaccessStatement.java:199) ~[?:?]
at it.pianetatecno.ecall.plugins.orisdentmdb.OrisdentMdb.getAppuntamenti(OrisdentMdb.java:194) ~[?:?]
... 25 more
Caused by: org.hsqldb.HsqlException: unknown token:
at org.hsqldb.error.Error.error(Unknown Source) ~[?:?]
at org.hsqldb.error.Error.error(Unknown Source) ~[?:?]
at org.hsqldb.ParserBase.read(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadPredicateRightPart(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadAllTypesPrimary(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadAllTypesFactor(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadValueExpression(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadRowElementList(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadAllTypesPrimary(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadAllTypesFactor(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadBooleanPrimaryOrNull(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadBooleanTestOrNull(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadBooleanFactorOrNull(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadBooleanTermOrNull(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadBooleanValueExpression(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.readWhereGroupHaving(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source) ~[?:?]
at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source) ~[?:?]
at org.hsqldb.ParserCommand.compilePart(Unknown Source) ~[?:?]
at org.hsqldb.ParserCommand.compileStatements(Unknown Source) ~[?:?]
at org.hsqldb.Session.executeDirectStatement(Unknown Source) ~[?:?]
at org.hsqldb.Session.execute(Unknown Source) ~[?:?]
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) ~[?:?]
at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source) ~[?:?]
at net.ucanaccess.jdbc.UcanaccessStatement.executeQuery(UcanaccessStatement.java:199) ~[?:?]
at it.pianetatecno.ecall.plugins.orisdentmdb.OrisdentMdb.getAppuntamenti(OrisdentMdb.java:194) ~[?:?]
... 25 more

The query can be executed without problem inside msAccess.

Any suggestion?

Thanks

[Daniele Renda]

I solve,
the problem was WHERE 1. It should be "WHERE 1=1".

Thanks