ODBC and JDBC Guide

Chapter 6 | Using JDBC to share FileMaker data 29
Example
Solutions with multiple FileMaker database files
If your FileMaker database solution uses many FileMaker 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 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 database file via JDBC, make sure:
1 the FileMaker database file is hosted and available
1 your FileMaker account uses a privilege set with the fmxdbc extended privilege for access via
ODBC/JDBC
1 The FileMaker Server, FileMaker Pro Advanced, or FileMaker Cloud host application has been
set up for sharing via ODBC/JDBC
To share a FileMaker database file as a data source, use FileMaker Pro Advanced 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 Advanced Help,
FileMaker Server Help, or FileMaker Cloud Getting Started Guide.
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" );