1. Open Eclipse, either using the start menu or desktop shortcut.
  2. Make sure your in the DBeaver perspective
    1. Window → Perspective → Open Perspective → Other
    2. Pick DBeaver from the list and click open.
  3. Make sure you have a project in your workspace, these appear in the projects pane on the left hand side. Only if you don't already have a project, create one:
    1. File → New → Project
    2. Pick a type of 'Project' under 'General', click next
    3. Give it a name, and click next.
  4. Create a connection
    1. Expand your project using the arrow to the left of its name, right click on the connections heading and pick 'Create a new connection'

    2. Pick 'DB2 LUW' from the list of connection types and then click next.

      1.  
    3. Enter the host and database names, also enter your username and if you wish password. Click Finish.
      The host and database should be set to:
      Host: db2.database.ukserp.ac.uk
      Database: pr_sail


    4. Click 'Test Connection', Which indicates missing drivers click 'Download'.
    5. A successful test will provide the following:
  5. Run a query against the data
    1. Either open an existing SQL file from your existing project or create a new one by right clicking within your project and choosing 'Create SQL script'.
    2. Use the yellow arrow to the left hand side of the SQL editor to run your query. The results will show in the pane at the bottom of the screen.

Note

~You will have to repeat step 4 for every project in your workspace as the connections settings are stored within a projects settings.

~If after using Windows 10 SAIL and you have moved your Workspace between Windows 7 and Windows 10, you may need to reset your pr_sail connection.

~If you are being prompted to install a driver, you may need to update the drivers.xml file. Please ensure you are running Eclipse from the desktop shortcut, or if your workspace is not called 'workspace' as set by default but is 'Win10_Workspace' for example then you will need to navigate to R:\Templates\Eclipse\db2-driver and copy the drivers.xml file, to replace the one found in your workspace at: P:\USERNAME\workspacename\.metadata\.plugins\org.jkiss.dbeaver.core\

~Delete all Eclipse shortcuts on your desktop, run DEM User Environment Refresh to replace this. If when you run Eclipse you are using 2020-09, please restart your desktop and log back in. You will then be using 2020-03 as is with Windows 7 SAIL. If the pr_sail does not connect, follow the steps above ensuring 4.b/c settings are correct.

.

  • No labels