Setup DBeaver

In this Lesson

You will learn how to install the DBeaver Eclipse plugin and use it to access the database tables provided for these lessons.

If you already have a preferred database access tool you may use it whenever we ask you to use DBeaver. You will need to configure your tool to connect to the demo database. Those settings are provided in this lesson.

Concepts

DBeaver is a tool that allows you to access tables hosted in a variety of different database management systems.

You will be using DBeaver to send SQL commands to the Derby database server in order to view information in the lesson’s tables.

If you don’t know SQL, no worries, because we will guide you every step of the way as you use this tool.

Install the DBeaver Plugin

This product is available on DBeaver download page. The following instructions will use the Eclipse Marketplace to install Beaver as an Eclipse plugin.

  • In Eclipse, select Help…Eclipse Marketplace



  • Search for DBeaver



  • Select the Install button for Beaver



  • Select the Confirm button



  • Accept the license agreement and complete the installation



  • If you receive a security warning select Ok



  • When asked, select Yes to restart Eclipse



  • After Eclipse restarts you need to start the Derby database server



  • Open the Eclipse perspective selection window



  • Select DBeaver



  • In the DBeaver perspective select the New Connection button



  • Select Derby Server and press Next



  • Select Download / Update if prompted.



  • Enter the connection properties as shown here (case is important)



  • Test the connection. If the connection fails then make sure Derby was started successfully and recheck the connection parameters.



  • After you have a successful connection
    Click the Next button twice to advance to the end of the wizard.






  • Click the Finish button to create the connection.



  • Open a new SQL editor window by right clicking the Derby – demo database and then selecting SQL Editor.



  • Enter the following SQL query statement into the editor window
    select * from party
  • Right click inside the SQL editor window and select Execute SQL Script. Notice the keyboard shortcut on the menu which tells you how to execute the command using the keyboard.



  • The results of the SQL query are displayed underneath the editor. The results contain all of the columns from the party table but there is no data because the table is empty.



Congratulations! You now have way to inspect the tables in the demo database.