ODBC and JDBC Guide

32 FileMaker ODBC and JDBC Guide
Specifying driver properties in the URL subname
Specify the user and password driver properties in the subname of the JDBC URL. These are the properties
that could be passed to the connection when calling the DriverManager.getConnection method via the
Properties parameter.
1 user: an account in the FileMaker database file that uses a privilege set with the extended privilege
Access via ODBC/JDBC
1 password: the password for the account in the FileMaker database file
JDBC URL connection with the database name specified in the URL
Format:
jdbc:filemaker://<filemaker host IP address>/<databasename>
Example:
jdbc:filemaker://192.168.1.1/publications
JDBC URL connection with the database name, user name, and password specified in the URL
Format:
jdbc:filemaker://<filemaker host IP address>/
<databasename>?user=<databaseusername>&password=<databasepassword>
Example:
jdbc:filemaker://192.168.1.1/customers?user=Collections&password=admin
Note Because of the use of the ampersand character (&) in this syntax, you cannot use an ampersand
character in the user name or the password.
Invalid user name example:
jdbc:filemaker://localhost/sales_db?user=ad&min&password=admin
Invalid password example:
jdbc:filemaker://localhost/sales_db?user=admin1&password=ad&min
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.