Name |
Change the name of the selected favourite connection here. |
Common Tab |
|
|
|
JDBC Driver |
Choose a driver class name from the combo box.
The entries contained in the box are the results of the
search for
JDBC drivers within the configured jars-files or folders in the
Classpath tab. |
Server URL |
The URL you type here is used to connect the
database. Common URLs are:
If you choose a driver class name from the combo box while the Server URL text field is empty, DbEdit gives you a hint how the URL for this driver could look. A number of templates to produce that hints are preconfigured but if you type a new URL that does not match any of the preconfigured templates, DbEdit tries to create a new hint from this URL and adds it to its url-template-base. For the next configuration with the same kind of driver that you add from scratch, the connection configuration dialog will present the added URL hint. |
User |
The user name. |
Schema |
The default schema used for this connection.
Please note that the default schema can differ from the schema that
the database server associates with the user used to connect. If that
is the case, unqualified table references that are are added to a
statement using the SQL content assistant may produce an SQL error. |
Password |
The password. |
Save Password |
If turned on, the password will
be persisted, else each attempt to establish a connection will prompt
an input dialog for the password. |
Classpath Tab |
|
|
|
Path |
This area lists the archives or
the folders containing the JDBC driver classes. You can use the buttons
to add, edit or remove entries. If the list content was changed and the
tab is leaved by choosing another tab or by closing the dialog, the
archives or folders are scanned for JDBC drivers and the results are
added to the driver class combo box in the Common tab. The no-archive icon ![]() |
Special Tab |
|
|
|
Auto-commit on |
If this is turned on, DbEdit sets the
connection auto-commit state to on directly after establishing a new
connection. Else it will set the state to auto-commit off. You must
then commit executed statements using the local connection menu from
the Tables View. |
Enable scrollable result sets |
If this option is turned on, each statement
executed will produce a result set which is scrollable. Else, if it
tuned off, DbEdit uses a non-scrollable result set mode. (This was
added because some drivers cause problems fetching large binary or
character values in scrollable mode). The difference between the two modes is: If you iterate a result in a result part like the Table Editor or the result area of the Instant SQL View using the scroll actions (Ctrl+Alt+Page Up/Ctrl+Alt+Page Down) , then the new pages of the result are only fetched if the option on, else each time you request a new page, the statement is executed again an the result is adjusted to display the current index. |
Use specified quote string |
By default DbEdit uses the quote string reported
by the JDBC driver. If that does not match your preferences, you can
specify your own quote string here. It will be used in all places where
identifiers are surrounded by quote strings. |
Additional Tab |
|
|
|
Name |
The name of an additional property. |
Value |
The corresponding value of the additional
property. Additional properties are driver specific. You should check the documentation of your JDBC driver for any connection properties that are supported. |
Note: Some of
the value
changes do not apply to established connections. To make them work you
may have to reconnect. |