JDataStore Explorer: Import Tables dialog box

This is a feature of JBuilder Professional and Enterprise.

The Import Tables dialog box is used to import data from another database into the current JDataStore. The connection and SQL statement used for importing are saved, so that you can refresh the data when desired. You can also edit the data in the JDataStore Explorer, and resolve those changes back to the original database. To get to the Import tables dialog box, select Tools|Import|Tables in the JDataStore Explorer.

Page 1

Connection

Use the Connection list to connect to a database by selecting an existing connection.

New

The New button is used to create a new connection to a database. This button brings up the New JDBC Connection dialog box.

Tables

The Tables lists show all the available tables in the database in one list and all the selected tables in another list. Use the mover buttons to select the tables to import.

Available

This list shows the tables that are available in the database.

Selected

This list shows the tables that you've selected to import.

Options

Uppercase Tables

This check box indicates whether table names should be forced to upper case when they are imported.

Uppercase Columns

This check box indicates whether column names should be forced to upper case when they are imported.

Uppercase Indexes

This check box indicates whether index names should be forced to upper case when they are imported.

Page 2

Page 2 of the Import Tables dialog box consists of a toolbar and a table listing the names of the table to import and their attributes. Each row in the table describes a table to be imported. Use the table to refine your imports by editing the values for any of the columns. When you have refined the imports, click Finish to import the data, or Back to go back to the first page and choose different tables or a different connection.

Toolbar buttons

Toolbar buttons allow you to navigate within the table and post or cancel changes to the table. Move the mouse pointer over a button to view a tool tip about that button. The toolbar consists of the following buttons.

Table

This column of the table lists the name of the table in the original data source.

Store Name

The Store Name to use for the imported data; that is, what the name of the table will be inside the JDataStore. You may include JDataStore paths with the / symbol.

SQL

The SQL statement that describes the data. Clicking the cell opens a simple text edit dialog box.

Create Indexes

This boolean column indicates whether to create indexes for the imported table. The existing indexes for the table in the source database will be recreated in the JDataStore.

Enable Refresh

This boolean column indicates whether to enable Refresh for the table from the Tools menu.

Enable Save

This boolean column indicates whether to enable Save for the table from the Tools menu.