ODBC and JDBC Developer’s Guide
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Using ODBC to share FileMaker data
- Chapter 3 Using JDBC to share FileMaker data
- Chapter 4 Supported standards
- Appendix A Mapping FileMaker fields to ODBC data types
- Appendix B Mapping FileMaker fields to JDBC data types
- Appendix C ODBC and JDBC error messages
- Index
Using JDBC to share FileMaker data 21
DriverManager.getConnection("jdbc:sequelink://17.184.17.170:2399;
user=some user;password=some password",userName,password);
} catch(Exception e) {
system.out.println(e);
}
// get connection warnings
SQLWarning warning = null;
try {
warning = con.getWarnings();
if (warning == null) {
System.out.println("No warnings");
return;
}
while (warning != null) {
System.out.println("Warning: "+warning);
warning = warning.getNextWarning();
}
} catch (Exception e) {
Sysem.out.println(e);
}
}
}
Note This example is not meant to be compiled.
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