• Home
• Download
• Installation
• Opening Connection
  • Configuring Connection
  • List of JDBC Drivers
• Running Query
• Prepared Statements
• Open And Save SQL
• Database Navigator
• Query Builder
• Other Features
• Plugins
• Javadoc

Configuring A Connection

When running SuperQuaiL for the first time the New Database Connection Dialog should open. The other way to get to the Connection Dialog is to go the menu and choose File->Edit->New Connection. The Open Database Connection Dialog shouldl look like the image below.

There are eight fields you will need to fill.

• Name - The name you call the connection configuration. This can be anything you want it to be called. A good practice is to give the configuration a name that tells you what you are using the configuration for. For example, you might have two configurations where one of them is to a development server and the other is to the production server. Then a good name would be "SuperQuaiL Development DB" and "SuperQuaiL Production DB".
• Jar Location - Clicking on the box will open a dialog in which you show SuperQuaiL the location of the jdbc driver.
• Driver - The fully quailified driver class for the jdbc driver.
• Database - This is also known as the JDBC URL. There are usually three parts: jdbc protocal which is jdbc, the name of the driver, and the url of the database. Fore more info about jdbc properties check out http://java.sun.com/docs/books/tutorial/jdbc/basics/connecting.html
• UserName - The user name used for logging into the database
• Password - The password used for logging into the database
• Background - The background color for the SQL editor. This is usefull for giving a visual cue which configuration you are using. A good practice is to use RED for configurations that point to Production databases and a happy color for the development database.
• Other Configuration Properties - Most JDBC drivers come with other properties you might want to use. For example, MYSQL has an option to limit the number of rows fetched in a query. To see other MYSQL configuration properties go to connector-j-reference-configuration-properties.html

There are four buttons that aid in creating and editing configurations.

• Remove - deletes the current configuration from SuperQuaiL
• Copy - creates a new configuration based on the current configuration. Then you can change the name and other properties as well.
• Test - uses the configuration and attempt to connect to the database. A connection successfull message will appear if test succeeds.
• Save - saves the configuration.