1 Reply Latest reply on Jun 8, 2012 5:00 PM by RicardoGamero

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

    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.