Database Pilot Options dialog box

This is a feature of JBuilder Professional and Enterprise.

Select View|Options from the Database Pilot to enable this dialog box. The Options dialog box enables you to set up variables about queries prior to execution.

Login page

Remember Passwords

Use this check box to indicate whether the password used to log in to a URL should be remembered. The password is only remembered for the current JBuilder session.

Display All Schemas

Indicates whether or not to display all schemas.

Query page

The Query page contains the options for how to load data.

Load Option

The following load options are available. For more information on these options, see the load variables in the Load interface in the DataExpress Library Reference.

Request Updatable Queries

If Request Updatable Queries is checked, an attempt is made to display editable data. Live data will be displayed on the Data page and in the area below the SQL text area on the Enter SQL page, depending on the user's rights, the type of query, etc. If unchecked, changes cannot be made to the data.

Save Changes Using Transactions

If selected, transactions will be used when saving changes. Uncheck this option if you are connected to a database set up without transactions and an error is occurring when you attempt to save changes.

Automatically Generate Catalog In Queries

If this check box is selected, JBuilder will automatically generate a catalog for queries. When a table is selected in the Database Pilot, and you click on the Data tab, a SQL query is internally generated to view the table's data. If selected, the table in the internal query will be qualified with the catalog and schema; if not selected, the table in the query will only be qualified with the schema. Some JDBC drivers seem to have problems when the catalog is specified in a query. If clicking on the Data tab when a table is selected causes an error, try toggling this check box.

Drivers page

Drivers

Lists JDBC drivers that may be available on your system. The fact that a driver is listed here does not necessarily mean the driver is set up properly. You must ensure separately that the drivers are on the classpath when attempting to use the drivers.

Sample URL

Indicates an example of the URL format used by the driver. This does not need to be a working URL.

Tool

Specifies a tool that is invoked to help define the URL.

Add

Click Add to add a driver.

Edit

Select an existing driver and click Edit to modify the driver's class name.

Remove

Select an existing driver and click Remove to remove it.

Oracle Setup page

Use the Oracle Setup page to specify the location of the tnsnames.ora file. Click the ellipsis button to open a file browser and navigate to the location. The Database Pilot will use this setting to help you construct Oracle OCI database URLs.

Create Table page

Display All Schemas' User Defined Types

This check box controls whether user defined types from all schemas are displayed in the Create Table dialog box. If the check box is unchecked, only user defined types from the current schema are displayed.