AnsweredAssumed Answered

FileMaker 16 JDBC Exceptions

Question asked by waechter on Dec 19, 2017
Latest reply on Dec 20, 2017 by waechter

Hi,

 

we use FileMaker JDBC to Synchronize some Data with a FileMaker Server 16.0.3. At the moment we use the JDBC Driver from FileMaker 14 (FileMaker 14.0.10 JDBC3) but since we have an FileMaker Server 16 and since we have some problems with container fields every now and than, we would like to Upgrade to the JDBC Driver from FileMaker 16 (FileMaker 16.0.19 JDBC3).

 

We tried to find a changelog of the JDBC Driver or some compatibility notes or some migration information but we couldn't find some. So first question: Does anybody know if there are some information on how to migration from the FileMaker JDBC Driver 14 to JDBC Driver 16?

 

Our second attempt was to just replace the JDBC Driver 14 with the one from FileMaker 16 but now we get lot's of Exceptions. So second question: Is there any serious documentation of the FileMaker JDBC Driver? We found a "small" SQL Reference: https://fmhelp.filemaker.com/docs/16/en/fm16_sql_reference.pdf and a small overview of the ODBC / JDBC Driver: https://fmhelp.filemaker.com/docs/16/en/fm16_odbc_jdbc_guide.pdf but there is only a really short paragraph regarding JDBC error messages.

 

So now to the Problem, at the moment we get the following Exceptions:

 

- com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] Unexpected listener response type (1) 115

  at com.filemaker.jdbc.FM_API.getColumnDefinitions(Unknown Source)

  at com.filemaker.jdbc.FM_API.execDirect(Unknown Source)

  at com.filemaker.jdbc.FM_API.execDirect(Unknown Source)

  at com.filemaker.jdbc1.CommonJ1Statement.execDirect(Unknown Source)

  at com.filemaker.jdbc1.CommonJ1Statement.executeQuery(Unknown Source)

  at com.filemaker.jdbc1.CommonJ1Statement.executeQuery(Unknown Source)

Querry: SELECT ID, server_host, server_port, user_name, smtp_user from Account WHERE active='x'

 

- com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] Unexpected listener response type (1) 0

  at com.filemaker.jdbc.FM_API.getColumnDefinitions(Unknown Source)

  at com.filemaker.jdbc.FM_API.execDirect(Unknown Source)

  at com.filemaker.jdbc.FM_API.execDirect(Unknown Source)

  at com.filemaker.jdbc1.CommonJ1Statement.execDirect(Unknown Source)

  at com.filemaker.jdbc1.CommonJ1Statement.executeUpdate(Unknown Source)

  at com.filemaker.jdbc1.CommonJ1Statement.executeUpdate(Unknown Source)

UpdateUPDATE Account SET STATUS='' WHERE ID = '1.1 Account 15'

 

 

- com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] Unexpected listener response type (3) 0

  at com.filemaker.jdbc.FM_API.next(Unknown Source)

  at com.filemaker.jdbc1.CommonJ1ResultSet.next(Unknown Source)

 

- com.filemaker.jdbc.FMSQLException: 3

  at com.filemaker.jdbc.FM_API.getColumnDefinitions(Unknown Source)

  at com.filemaker.jdbc.FM_API.execDirect(Unknown Source)

  at com.filemaker.jdbc.FM_API.execDirect(Unknown Source)

  at com.filemaker.jdbc1.CommonJ1Statement.execDirect(Unknown Source)

  at com.filemaker.jdbc1.CommonJ1Statement.executeQuery(Unknown Source)

  at com.filemaker.jdbc1.CommonJ1Statement.executeQuery(Unknown Source)

Querry: SELECT ID, server_host, server_port, user_name, smtp_user from Account WHERE active='x'

 

 

AGAIN: If i change the JDBC Driver back to FileMaker 14.0.10 JDBC3 all this runs without any Problems with the FileMaker Server 16.0.3! But i think, it somehow makes sense to use the JDBC Driver 16 for FileMaker 16. And i somehow hope that all this problems are caused just thru some missing adjustments.

 

So i would be happy if someone has some informations or tipps, or ideas.

 

Thanks,

Julian

 

 

 

System:

Server: FileMaker Server 16.0.3 on Mac OS X 10.11.6

Java Verison: Java 1.8.0_151

 

JDBC Driver from: https://support.filemaker.com/s/answerview?language=en_US&anum=12921

JDBC Driver Version: FileMaker 16.0.19 JDBC3

Outcomes