Developer’s Guide

Using Java and JDBC to deliver your data 9-3
jdbc:fmpro:https://www.filemaker.com:80
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());
}
}
}
Note This example is not meant to be compiled.
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.