...
You might also consider using SQuirreL SQL Client as recommended by the Apache Derby team... I also believe it's the best choice.
| Info | ||
|---|---|---|
| ||
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.
...
- 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. You will find this in your workspace as framework/entity/lib/jdbc/derby-10.2.2.0.jar.
- Derby is dynamically loaded once by Gradle and used at runtime only, see in build.gradle line
<<runtimeOnly 'org.apache.derby:derby:10.14.2.0'>> - 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.
...