The following is a bit old. For installation at least you might be interested by http://www.vogella.de/articles/EclipseDataToolsPlatform/article.html
You might also consider using SQuirreL SQL Client as recommended by the Apache Derby team... I also believe it's the best choice.
Pre Gradle version
This page document the usage with Gradle, the pre-Gradle documentation is here: Browsing Derby Database in Eclipse
Connecting the database
The Eclipse DTP (Data Tools Project) is quite helpful to inspect database content from within the IDE. As long as you are using the embedded Derby database in OFBiz, you can create a DTP connection as described here. Everything you need comes with OFBiz. Just make sure you have the Data Tools Platform features installed in your Eclipse IDE.
- In the Data Source Explorer View, right-click on Databases and choose New ... .
- Select Derby Embedded Database and click on Next.
- Enter a name and description. (Note: Both are for your reference only!) Click Finish.
- Most likely, you will not yet have a Driver Definition for the Derby database available, so the Select a driver dropdown will be empty. Click on the ... button next to it to start creating a driver definition.
- Choose 10.2 under Derby and click the Add... button.
- Make sure you choose the Derby Embedded JDBC driver and click OK.
- The template expects the driver to be in a file called derby.jar. Select that line in the Driver File(s) listbox and click on Edit Jar/Zip to specify the actual location of the JAR file.
- Derby is dynamically loaded once by Gradle and used at runtime only, see in build.gradle line
- So the Derby driver is located in the Gradle cache, see https://docs.gradle.org/current/userguide/directory_layout.html to find your own Gradle cache location.
- Locate the driver and select it
- When done, click OK.
- You should be back in the Driver and Connection Details. Fill in the parameters as you can see them here. Note: For Database location, adapt to your workspace location. There is no way to use a variable in this path, unfortunately. Username and password are ofbiz/ofbiz by default. For convenience, in a development environment, it should be acceptable to save the password with the connection. Make sure that Create database (if required) is unchecked, as this does not make sense in this context.
Important: This is not the place to decide that you'd like your Derby DB in a different location for OFBiz as OFBiz itself does not use these settings. If you would like to have your database outside of the workspace, take a look at the entityengine.xml config file and read the Entity Engine Configuration Guide to learn how to switch databases.
Click on Test Connection to make sure your settings allow you to successfully connect to the database.
- You should now be able to browse the database content of OFBiz inside Eclipse.