English

Bug: The executed query is not executing correctly against the database. Verify the query syntax for your underlying database system.

Description

Trying to find jobs by date or filter by date in a query against an Oracle JTX repository causes the following error message:

"The executed query is not executing correctly against the database. Verify the query syntax for your underlying database system."

Cause

The query generated by JTX is not a valid Oracle query.

Workaround

To format the date being searched, use the JTX SQL query functionality and the Oracle to_date or to_char function.