ODBC and JDBC Guide

Chapter 6 | Using JDBC to share FileMaker data 29
Example
Solutions with multiple FileMaker Pro database files
If your FileMaker Pro database solution uses many FileMaker Pro database files, create an
additional database file that contains all the necessary external data source references, table
occurrences, and relationships for your solution. Then define this additional database file as your
data source in the JDBC URL. All of the FileMaker Pro database files must be on the same
computer.
Verifying access via JDBC
Note The sample file FMServer_Sample cannot be used to test JDBC connections. To test
JDBC connections, upload your own database.
When verifying access to a FileMaker Pro database file via JDBC, make sure:
1 the FileMaker Pro database file is hosted and available
1 your FileMaker file account uses a privilege set with the fmxdbc extended privilege for access
via ODBC/JDBC
1 The FileMaker Server, FileMaker Pro, or FileMaker Cloud for AWS host application has been
set up for sharing via ODBC/JDBC
To share a FileMaker Pro database file as a data source, use FileMaker Pro to define accounts
that need access to the database file. Then, control access to the database file by assigning
privilege sets to the accounts, including the fmxdbc extended privilege for access via
ODBC/JDBC. Finally, enable the host application to share data via ODBC/JDBC. Visit the
Product Documentation Center
for the details in FileMaker Pro Help, FileMaker Server Help, or
FileMaker Cloud for AWS Help.
1 The JDBC client driver registration and the JDBC URL are correct (the driver can be included
inside the Java Application or located on the client machine)
Connection conn = DriverManager.getConnection (
"jdbc:filemaker://192.168.1.1/customers?SocketTimeout=100", "admin",
"admin" );