Developer’s Guide

Using Java and JDBC to deliver your data 8-3
jdbc:fmpro:http://1.184.21.234:80
If you need a secure connection, you might want to use the
FileMaker Pro Unlimited software, which includes the Web Server
Connector that allows you to encrypt and decrypt your data via
HTTPS.
jdbc:fmpro:https://www.filemaker.com:80
For information on FileMaker Pro Unlimited, see the product pages
at www.filemaker.com.
Here is an example of registering the FileMaker JDBC Driver with
the JDBC driver manager and connecting to FileMaker Pro via the
Web Companion —where the open FileMaker Pro database is
named Employees.fp5 and the JDBC URL is
jdbc:fmpro:http://localhost:
import java.sql.*;
class FMPJDBCTest
{
public static void main(String[ ] args)
{
try
{
// register the FMPJDBC driver
Class.forName("com.fmi.jdbc.JdbcDriver");
// establish a connection to FileMaker Pro at a given IP
// address
Connection fmpConnection =
DriverManager.getConnection("jdbc:fmpro:
http://localhost", "some_user", "some_password");
Statement fmpStatement =
fmpConnection.createStatement();
// return a maximum of 50 records
fmpStatement.setMaxRows(50);
ResultSet resultSet = fmpStatement.execute("select \"last
name\", \"first name\" from \"employees.fp5\" where
department='engineering' order by \"last name\"");
System.out.println("Engineering Department");
while (resultSet.next())
System.out.println(resultSet.getString("last name") +
", " + resultSet.getString("first name"));
}
catch(ClassNotFoundException classNotFoundException)
{
System.out.printIn(“Could not load driver”);
}
catch(SQLException sqlException)
{
System.out.printIn(“JDBC Error:” +
sqlException.getMessage());
}
}
}
Specifying driver properties in the URL subname
You can specify the escape, fetchsize, user, and password driver
properties in the subname of the JDBC URL. This is useful when
you’re using a RAD tool that doesn’t support spaces, periods, or
other non-letter characters.
jdbc:fmpro:http://17.184.21.234/properties?escape=%20.&
fetchsize=100&user=fred&password=test
Note These are the same properties that could be passed to the
connection when calling the DriverManager.getConnection method
via the Properties parameter.