Configure Connections


To open a connection to a database you first have to configure the connection properties. You'll need at least the JDBC drivers class name and the URL the connection will be established to.
The properties can be edited in a dialog that can be opened either from the Tables Views context menu using the action Connection/Configure or from the toolbar button Configure Connections which is shown if the DbEdit Action Set is enabled (Window/Customize Perspective.../Other/DbEdit).
The dialog shows a  list on the left hand side with the connections you may have already configured and an area to change an entry on the right.

The right area  consists of several edit fields:

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:
  • jdbc:mysql://hostname:port/database
  • jdbc:postgresql://hostname:port/database
  • jdbc:db2:database or jdbc:db2://hostname:port/database for the net-driver
  • jdbc:oracle:thin:@//hostname:port/systemid
  • jdbc:sybase:Tds:hostname:port/database
URL templates
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 Non-existing archive or folder indicates that a previously added classpath entry no longer exists and must be changed. If leaved unchanged, the driver will not be found when trying to establish a connection.


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.



Legal Notice