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.

At the end, the configuration should look like this.

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.

List of JDBC Drivers

Name Database Driver
IBM DB2 jdbc:db2://<HOST>:<PORT>/<DB>
JDBC-ODBC Bridge jdbc:odbc:<DB> sun.jdbc.odbc.JdbcOdbcDriver
Microsoft SQL Server jdbc:weblogic:mssqlserver4:<DB>@<HOST>:<PORT> weblogic.jdbc.mssqlserver4.Driver
Oracle Thin jdbc:oracle:thin:@<HOST>:<PORT>: oracle.jdbc.driver.OracleDriver
PointBase Embedded Server jdbc:pointbase://embedded[:<PORT>]/<DB> com.pointbase.jdbc.jdbcUniversalDriver
Cloudscape jdbc:cloudscape:<DB> COM.cloudscape.core.JDBCDriver
Cloudscape RMI jdbc:rmi://<HOST>:<PORT>/jdbc:cloudscape:<DB> RmiJdbc.RJDriver
Firebird (JCA/JDBC Driver) jdbc:firebirdsql:[//<HOST>[:<PORT>]/]<DB> org.firebirdsql.jdbc.FBDriver
IDS Server jdbc:ids://<HOST>:<PORT>/conn?dsn='' ids.sql.IDSDriver
Informix Dynamic Server jdbc:informix-sqli://<HOST>:<PORT>/<DB>:INFORMIXSERVER= com.informix.jdbc.IfxDriver
InstantDB (v3.13 and earlier) jdbc:idb:<DB> jdbc.idbDriver
InstantDB (v3.14 and later) jdbc:idb:<DB> org.enhydra.instantdb.jdbc.idbDriver
Interbase (InterClient Driver) jdbc:interbase://<HOST>/<DB> interbase.interclient.Driver
Hypersonic SQL (v1.2 and earlier) jdbc:HypersonicSQL:<DB> hSql.hDriver
Hypersonic SQL (v1.3 and later) jdbc:HypersonicSQL:<DB> org.hsql.jdbcDriver
Microsoft SQL Server (JTurbo Driver) jdbc:JTurbo://<HOST>:<PORT>/<DB> com.ashna.jturbo.driver.Driver
Microsoft SQL Server (Sprinta Driver) jdbc:inetdae:<HOST>:<PORT>?database=<DB> com.inet.tds.TdsDriver
Microsoft SQL Server 2000 (Microsoft Driver) jdbc:microsoft:sqlserver://<HOST>:<PORT>[;DatabaseName=<DB>]
MySQL (MM.MySQL Driver) jdbc:mysql://<HOST>:<PORT>/<DB>
Oracle OCI 8i jdbc:oracle:oci8:@ oracle.jdbc.driver.OracleDriver
Oracle OCI 9i jdbc:oracle:oci:@ oracle.jdbc.driver.OracleDriver
PostgreSQL (v6.5 and earlier) jdbc:postgresql://<HOST>:<PORT>/<DB> postgresql.Driver
PostgreSQL (v7.0 and later) jdbc:postgresql://<HOST>:<PORT>/<DB> org.postgresql.Driver
Sybase (jConnect 4.2 and earlier) jdbc:sybase:Tds:<HOST>:<PORT> com.sybase.jdbc.SybDriver
Sybase (jConnect 5.2) jdbc:sybase:Tds:<HOST>:<PORT> com.sybase.jdbc2.jdbc.SybDriver Logo