user manual

Chapter 4
|
Using JDBC to share FileMaker data 25
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=<pa
ssword>
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.
Note Secure Socket Layer (SSL) encryption is not supported. To create a more secure JDBC solution, set
up an environment such as .ASP or .JSP, where the web server is hosting via https and communicating with
the FileMaker database file behind a firewall.
Verifying access via JDBC
When you install the JDBC client driver, you have the option of installing JDBCTest to help verify your
connections. When installing the JDBC client driver, select Install Developer’s Tools to get JDBCTest. See
“JDBC client driver installation (Windows and Mac OS)” on page 13 for more information.
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 extended privilege of Access via ODBC/JDBC.
1 The FileMaker Pro or FileMaker Server Advanced host application has been set up for sharing via
ODBC/JDBC.
To share a FileMaker database file as a data source, use FileMaker Pro 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 extended privilege of access via ODBC/JDBC. Finally, enable the
FileMaker
Server Advanced or FileMaker Pro host application to share data via ODBC/JDBC. For
details, see FileMaker Pro Help.
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).
For additional information on using JDBC to share FileMaker data, see www.filemaker.com/support/technologies.