Accessing toolkit Apache derby database using Squirrel SQL

Posted by Hariharan Vadivelu on
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.





2 comments:

  1. Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on SAP MM.SAP MM

    ReplyDelete
  2. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in TECHNOLOGY , kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on TECHNOLOGY. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Saurabh Srivastava
    MaxMunus
    E-mail: saurabh@maxmunus.com
    Skype id: saurabhmaxmunus
    Ph:+91 8553576305 / 080 - 41103383
    http://www.maxmunus.com/


    ReplyDelete