Administrator’s Guide

Using Java and JDBC to deliver your data 6-13
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.
2. Click the Java Client Layout tab.
Because JBuilder requires a unique row identifier for updating and
deleting rows, it automatically adds the RecordID pseudo column to
the list of output columns, which you probably don’t want displayed
in your application.
3. Deselect the Layout check mark for the RecordID identifier.
4. Choose File menu > Generate.