ODBC and JDBC Developer’s Guide

22 FileMaker ODBC and JDBC Developer’s 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
Basic JDBC URL connection
Format: jdbc:sequelink://<sequelink host IP address>:<port>
This is the URL to connect to the FileMaker database file with no passwords. The port number will always
be 2399 (you can’t change the JDBC sharing to a different port).
If you are executing the JDBC URL connection on the same machine where the file is located, you can use
jdbc:sequelink://localhost:2399
Example: jdbc:sequelink://17.184.17.170:2399
JDBC URL connection with user name and password defined in the URL
Format:
jdbc:sequelink://<sequelink host IP
address>:<port>;user=<userName>;password=<password>
Example: jdbc:sequelink://17.184.17.170:2399;user=phil;password=jsp
JDBC URL connection with the database name specified in the URL
Format:
jdbc:sequelink://<sequelink host IP address>:<port>;
serverDataSource=<databasename>
Example: jdbc:sequelink://17.184.17.170:2399;serverDataSource=publications
If your database name contains spaces, replace them with the escape characters %20.
Example: jdbc:sequelink://17.184.17.170:2399;serverDataSource=MY%20DATABASE
JDBC URL connection with the database name, user name, and password specified in the URL
Format 1 (using the data store user name and password): jdbc:sequelink://<sequelink host IP
address>:<port>;serverDataSource=<databasename>;DBUser=<databaseusername>;
DBPassword=<databasepassword>
Format 2 (using the host user name and password): jdbc:sequelink://<sequelink host IP
address>:<port>;serverDataSource=<databasename>;HUser=<username>;HPassword=<p
assword>
Note If your FileMaker database solution uses many FileMaker database files, create an additional database
file that contains all the necessary external file 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.