Creating a QuantumDB Bookmark

Author: jparrai
Date: 28-03-2003

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.

Once this menu item is selected, you will see the "New Bookmark" wizard:

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.
• Prompt for Password: Check this box if you want to be prompted for a password every time you try to connect to the database.
• 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