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.




Pituluik Media Blogger | Freelancer |Operations Manager | Marketing and Sales Manager | Lancer Evo 4 Community. Indonesian Bloggers Who Become Bloggers Because of Hobby. Feel free to connect with me on Social Media Instagram @alberandesko

0 Response to "Accessing toolkit Apache derby database using Squirrel SQL"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel