ODBC and JDBC Guide

Chapter 6 | Using JDBC to share FileMaker data 27
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 fmxdbc
extended privilege for 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 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
Note Because the ampersand character (&) is reserved for use in this syntax, you cannot use an
ampersand character in the user name or the password.
Examples
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.
jdbc:filemaker://192.168.1.1/publications
jdbc:filemaker://192.168.1.1/customers?user=Collections&password=admin
Invalid user name:
jdbc:filemaker://localhost/sales_db?user=ad&min&password=admin
Invalid password:
jdbc:filemaker://localhost/sales_db?user=admin1&password=ad&min