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.
- All: Load all data in a single fetch.
- As Needed: An initial number of rows is loaded. Then, whenever a navigation beyond the last loaded row is attempted, another set of rows are loaded.
- Uncached: Initially, one row is loaded. Whenever a navigation beyond the loaded row is attempted,
another row is loaded that replaces the previously loaded row.
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.