|
| |
Managing ConnectionsSetting Up ConnectionsConnections hold the bulk of the information that the application uses to set up the JDBC driver as well as the database SQL grammar to use. Youshould be able to set up a connection to any data source that provides a JDBC driver. If there is no connection template already registered for thatdriver, follow the directions from the driver provider to set up a template.Once a template is set up, or if one already exists, you can either set upthe connection directly, or over SSH via local port forwarding. The applicationcomes with an SSH client installed, so it will take care of creating an SSHtunnel and connecting to the right local ports if you choose to connect viaSSH. Once you have entered the appropriate connection information and JDBC url (which should be autogenerated for you unless you override it), you can choosethe database SQL grammar to use for this connection. The connection templatewill provide a default value for this, or you can select another grammar. TheSQL grammar will determine what SQL syntax to use while interacting with the data source. You can also configure advanced settings provided by JDBC driver through the "Advanced Settings" button. This form will discover all available settings that the JDBC driver provides. Once the connection is set up, you can save it and attempt to open the connectionfrom the connection tree. If there is a configuration problem, a dialog will display an error message provided by the JDBC driver. Please reviewthe JDBC driver's documentation on particular error messages. Viewing Connection PropertiesYou can view the JDBC driver properties of an open connection using this form.You can browse the driver's version information, supported functions and capabilities, extra supported SQL keywords, SQL data types, and SQL functionssupported by the driver and data source. Managing Connection TemplatesConnection templates are used to set up JDBC connection information for eachdriver. They hold the JDBC URL format, the driver class name, and otherdescriptive information. The templates also hold a list of driver Jar filesthat are loaded dynamically. |
