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.
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.
Indicates whether or not to display all schemas.
The Query page contains the options for how to load data.
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.
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.
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.
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.
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.
Indicates an example of the URL format used by the driver. This does not need to be a working URL.
Specifies a tool that is invoked to help define the URL.
Click Add to add a driver.
Select an existing driver and click Edit to modify the driver's class name.
Select an existing driver and click Remove to remove it.
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.
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.