ODBC and JDBC Guide

60 FileMaker ODBC and JDBC Guide
The JDBC client driver converts the FileMaker calculation data type to the JDBC SQL type matching the
calculation’s result. For example, the JDBC client driver converts a FileMaker calculation that results in a
timestamp data type to java.sql.Types.TIMESTAMP.
ODBC and JDBC error messages
Here are the basic formats of error messages you receive when working with FileMaker and ODBC/JDBC.
ODBC error messages
Error messages can come from:
1 ODBC driver errors
1 FileMaker and FileMaker xDBC Listener errors
FileMaker ODBC error messages
An error that occurs in the FileMaker listener or data source includes the data source name, in the following format:
[FileMaker] [FileMaker ODBC] message
For example, you might get the following message from your FileMaker data source:
[FileMaker] [FileMaker ODBC] Invalid Username/Password
If you get this type of error, you did something incorrectly with the database system. Check your FileMaker
documentation for more information or consult your database administrator.
Consecutive messages for errors in different columns can sometimes display an incorrect column name.
JDBC error messages
The FileMaker JDBC driver reports errors to the calling application by returning SQLExceptions. Error
messages can come from:
1 JDBC driver errors
1 FileMaker and FileMaker xDBC Listener errors
FileMaker JDBC error messages
An error that occurs in the FileMaker listener or data source includes the data source name, in the following format:
[FileMaker] [FileMaker JDBC] message
For example, you might get the following message from your FileMaker data source:
[FileMaker] [FileMaker JDBC] Invalid Username/Password
If you get this type of error, you did something incorrectly with the database system. Check your FileMaker
documentation for more information or consult your database administrator.
container java.sql.Types.BLOB
calculation specified by the data type of the calculation’s result
FileMaker field type Converts to JDBC SQL type