JDBC Explorer options

This is a feature of JBuilder Professional and Enterprise.

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

Login page

The Login page contains a checkbox for determining whether or not the password used to log in to a URL should be remembered. The password is only remembered for the current JBuilder session.

Query page

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

Load Options

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

Request Live Queries

If Request Live 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 checkbox is selected, JBuilder will automatically generate a catalog for queries. When a table is selected in the JDBC Explorer, 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 checkbox.

Drivers page

Use the Drivers page to specify the class name, location, and sample URL format for each JDBC driver that is installed on your system. You must ensure separately that the drivers are on the classpath when attempting to use the drivers.

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 JDBC Explorer will use this setting to help you construct Oracle OCI database URLs.

Display order

Display and sort by Schema

Tables in the JDBC Explorer's tree are always displayed in <schema>.<table> form, (eg. USERNAME.CUSTOMER), and the table nodes are sorted by schema and table.