ODBC and JDBC Guide
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Accessing external SQL data sources
- Chapter 3 Installing FileMaker ODBC client drivers
- Chapter 4 Using ODBC to share FileMaker data
- Chapter 5 Installing FileMaker JDBC client drivers
- Chapter 6 Using JDBC to share FileMaker data
- Chapter 7 Supported standards
- Chapter 8 Reference Information
- Index
Chapter 8 | Reference Information 59
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.
Data types in 64-bit applications
In the 32-bit version of the ODBC API, some functions used parameters that could pass integer
values or pointer values, depending on context. But in 64-bit Windows operating systems, integers
and pointers are not the same size. The 64-bit version of the ODBC API uses abstract data types
that are not defined as a specific size.
Applications that use 32-bit values may crash when they are ported to a 64-bit operating system.
Applications that use abstract data types work correctly on both 32- and 64-bit operating systems.
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
timestamp java.sql.Types.TIMESTAMP
container java.sql.Types.BLOB
calculation specified by the data type of the calculation’s result
FileMaker field type Converts to JDBC SQL type