AnsweredAssumed Answered

JDBC - SELECT SQL statement with date in WHERE as criteria will raise exception

Question asked by RicardoGamero on Jun 8, 2012
Latest reply on Jun 8, 2012 by RicardoGamero

Summary

JDBC - SELECT SQL statement with date in WHERE as criteria will raise exception

Product

FileMaker Server

Version

11

Operating system version

MAC OS LION

Description of the issue

Select statements with more than 1 date field as criteria will raise exception

Steps to reproduce the problem

Using this statement will work as expected:

SELECT Table12."_ReportIDFK" FROM Table12 WHERE ( Table12."_Date" >= {06/24/2012} )

This similar statement will fail:

SELECT Table12."_ReportIDFK" FROM Table12 WHERE ( Table12."_Date" >= {06/24/2012} and Table12."_Date" <= {06/24/2014} )

Expected result

successful execution

Actual result

error:

[FileMaker][FileMaker JDBC] FQL0001/(1:411): There is an error in the syntax of the query.

Exact text of any error message(s) that appear

com.filemaker.jdbc.FM_API.prepare(Unknown Source) com.filemaker.jdbc.FM_API.prepare(Unknown Source) com.filemaker.jdbc1.CommonJ1Statement.(Unknown Source) com.filemaker.jdbc2.CommonJ2Statement.(Unknown Source) com.filemaker.jdbc3.CommonJ3Statement.(Unknown Source) com.filemaker.jdbc3.J3PreparedStatement.(Unknown Source) com.filemaker.jdbc3.J3Connection.prepareStatement(Unknown Source) com.filemaker.jdbc2.CommonJ2Connection.prepareStatement(Unknown Source) controller.login.processRequest(login.java:65) controller.login.doPost(login.java:135) javax.servlet.http.HttpServlet.service(HttpServlet.java:641) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) java.lang.Thread.run(Thread.java:680)

Workaround

no work around.

Outcomes