Author: jparrai
Date: 28-03-2003
Subject: Making a Quantumdb connexion
To connect to a database (create a bookmark in quantum) you use the New Bookmark menu item that appears
when right-clicking on the blank space in the Database Bookmarks view.
The data that the form asks of you is:
- Bookmark name: Is your private name of the bookmark you
are creating. It will appear in the view after is created. For example Test.
- Username: The username for accessing the database. For
example SCOTT for the classical Oracle
examples.
- Password: The password for that username. For example
TIGER for the SCOTT user. If you leave the
password blank, it'll ask you for it when connection is attempted.This behaviour
can be customized.
- Schema: (optional): The schema of the user. We can leave
it blank.
- Connect: Connect string, the format is (for Oracle) jdbc:[database]:[type]:@[host]:[port]:[database],
for example, for an Oracle database called DEV based on the same computer
you could put jdbc:oracle:thin:@localhost:1521:DEV.
- Driver: The driver name, it should be in the documentation
of the JDBC driver. For Oracle, is usually oracle.jdbc.OracleDriver or oracle.jdbc.driver.OracleDriver (Oracle before
version 9)
- Type: The type of the database. It will be used by Quantum
to adapt the SQL queries to the particular incompatibilites of each. The generic
should work for most of the features, so if you don't find your database on
the drop-down, use the Generic SQL.
- Driver Filename: You can select the .jar or .zip file where the driver is located. For
example in Oracle is usually at C:\Oracle\jdbc\lib\classes12.jar, being C:\Oracle
the installation directory of oracle.
Other examples (only as orientation, your particular data may be
different)
For MySql (in Windows):
Connect: jdbc:mysql://localhost/test
Driver: com.mysql.jdbc.Driver
Driver Filename: C:\mysql\jdbc\mysql-connector-java-2.0.4-bin.jar
For PostgreSql (in Linux):
Connect: jdbc:postgresql://localhost/emsdevel
Driver: org.postgresql.Driver
driver filename: /opt/postgresql/share/java/postgresql.jar