Exploring your databases

Contents

    		•

    What

    x Use the DB Tree View to explore your databases in the Database Explorer plug-in. (If you have not already switched to the Database perspective, you can do so by clicking the Database button Image:iconDatabasePerspective.png in the upper right corner of your workbench.)

    How

    x

    Adding a database

    x To add a database to your view:

    Step 1

    x

    Add Database Step 1
    Add Database Step 1
    On the DB Tree View, click the Add button Image:IconAdd.png to open the Add Database wizard.

    Step 2

    x

    Database Connection Name
    Database Connection Name
    On the first screen enter a name for your database connection and click the next button.

    Step 3

    x

    Select JDBC Driver
    Select JDBC Driver
    Select or add the JDBC driver (see Configuring your JDBC drivers if you have not yet added one for your database.)

    Enter the connection details including host, username, password, and database name. You can click the test connection button. If the connection is successful a message will appear in the top of the window. If there is an error, an error message will show details of the error. When you are ready, click the next button.

    Step 4

    x

    Access Options
    Access Options
    On the final screen you can select connection access options. You can filter by string or regular expression. You can check and uncheck which databases are available.

    If you would like your queries to auto-commit, check the "SQL Auto Commit" box.

    When you are ready, click finish. You should now have a connection to your database and should be able to browse your database from the DB Tree View.

    Displaying the DB Tree View

    x

    Database Tree View
    Database Tree View
    The DB Tree View should be displayed by default in the Database perspective. If you do not see this view, go to Window > Show View > DB Tree View to display the view (shown below).