Sunday, July 12, 2015

Squirrel SQL

Squirrel SQL:

The SQuirreL SQL Client is a graphical program written in the Java programming language that will allow you to view the structure of a JDBC-compliant database, browse the data in tables, issue SQL commands and much more.

Configuration of Squirrel SQL to connect to Derby Database:

Step 1: Launch the Squirrel SQL.

Step 2: Click Add button and would be presented with the below dialog. Provide the Name, Example URL, Website URL and in the external Class Path, add the Jars derby.jar and derbyclient.jar that comes along with the Installation of Derby Database. Click OK button

Step 3: Select Alias Tab. Feed in the below details: Sample Name, Driver that we created in Step 2, URL, Username and password being APP, Select Auto Logon and click Ok Button.

Step 4: Now we would be able to view the Contents of Derby Database.

No comments:

Post a Comment