Developer’s Guide

Using Java and JDBC to deliver your data 8-13
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.
6. In the User Authentication dialog box, leave the User Name and
Password text boxes blank (the database is not password protected)
and click OK.
JBuilder connects to FileMaker Pro.
7. In the Data Modeler, click the + symbol to expand Tables.
8. Click the + symbol to expand the Inventory$2efp5 table (now
encoded with the period escaped).
9. Click the + symbol to expand Columns.
10. Select each of the following columns and copy it to the right side
of the Data Modeler.
Item
Category
Location
Cost
Date Purchased
Picture
Serial Number
Information
Test the data module
1. In the Data Modeler, click the Test tab and click Execute Query.
The data and all of the images from the Inventory.fp5 database are
downloaded into the data module.
2. Choose File menu > Save.
JBuilder saves the data module and automatically adds it to your
project.
3. Choose File menu > Exit.
4. Click Yes to invoke the Application Generator.
Generate the application
1. In the Application Generator, click Restore Defaults and make sure
that 2-tier data model client is selected.