Accessing toolkit Apache derby database using Squirrel SQL
There are two ways to access the embedded Apache Derby database which is bundled with the toolkit, when the toolkit is not running you can use following command line utility to access database WCDE_ENT70\bin\ij.bat and while toolkit test server is running you can use http://localhost/webapp/wcs/admin/servlet/db.jsp from a browser
Following option is an alternative to using ij.bat file, instead you can use Squirrel SQL editor to access the embedded Apache Derby database
Step 1
Download Squirrel SQL editor from http://www.squirrelsql.org/#installation, I have tested this with version 3.3.0
Step 2
Configure the embedded Apache Derby driver, follow the steps as shown in the screenshot below.
Step 3
From the aliases section configure new alias for the embedded database, follow the steps as shown in the screenshot below.
The default username/password for embedded database is
Username: APP
Password: system
Step 4
Click on "test" button to test connectivity and click ok, this should connect to the derby database and you should be able to perform SQL operation against the embedded database.
NOTE: Since embedded mode supports only one client connection at a given point of time, ensure that you disconnect database from Squirrel SQL editor before starting toolkit.
0 Response to "Accessing toolkit Apache derby database using Squirrel SQL"
Post a Comment