I am querying an Intersystems Cache database.
v1.VisitTypeSubTypeID -> Name LIKE 'KRCC%'
I have a query that runs fine when using DBeaver and Eclipse Neon. I use JDBC connections for these tools as well. The query I am running uses an implicit join. When I try to run the query in JasperReports Studio 6.3 it complains about the implicit join syntax of -> (see example above).
As I mentioned, this query runs fine in other tools that use the same JDBC drivers. The error message that JasperStudio provides is as follows:
[SQLCODE: <-25>:<Input encountered after end of query>][Location: <Prepare>]