ODBC and JDBC Guide

Chapter 6 | Using JDBC to share FileMaker data 28
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
Specifying a socket timeout value
To prevent the JDBC driver from maintaining the connection indefinitely, include the
SocketTimeout parameter when you specify the JDBC connection string, specifying a socket
timeout value in milliseconds.
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