Administrator’s Guide

6-12 FileMaker Pro 5.5 Unlimited Administrator’s Guide
6. In the Available Java Libraries dialog box, select the Fmpjdbc12.jar
file. (If the FileMaker JDBC Driver does not appear in this dialog
box, click New to locate the file and add it to the list.) Then click OK.
7. Click OK to close the Properties dialog box.
Create the data module
1. In JBuilder, choose File menu > New.
2. In the New dialog box, select the Data Module icon and click OK.
3. In the New Data Module dialog box, make sure that inventory is in
the Package text box and that the checkbox for Invoke Data Modeler
is selected.
4. Click OK to open the Data Modeler.
Design the data module
1. In the Data Modeler, choose Database menu > Add Connection URL.
2. In the Driver text box, type com.fmi.jdbc.JdbcDriver.
3. In the URL text box, type jdbc:fmpro:http://localhost/
properties?escape=.%20.
Because JBuilder’s Application Generator doesn’t allow for periods
in table names or spaces in column names for certain operations, you
need to add escape properties for them in the subname of the URL.
4. Click OK to close the Add Connection URL dialog box.
5. In the Data Modeler, click the + symbol to expand the URL node
that you added.