Hi Friends,
SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.
Prerequisites
The SQuirreL SQL Client is a Java application, and as such, it requires a Java 6 runtime environment (JRE) which can be downloaded from Oracle.
Once the Java 6 runtime environment is installed, the install jar for the SQuirreL SQL Client can be found here: http://www.squirrelsql.org/#installation.
Double-click on it to launch the default application i.e JAVA “jar” file; the installer will display a welcome dialog as shown in Figure 1.
Click the “Next” button again, and the dialog prompts for a path to the location where the application should be installed.
Click the “Next” button to continue the installation. The dialog now presents a list of “packs” that can be installed, which include required software as well as optional plug-ins.
A plug-in is usually a piece of software that can be added (or plugged in) to the application to extend its capabilities. The SQuirreL SQL Client installer ships database-specific plug-ins for each of the major databases which allow the application to work optimally with the corresponding database.
The “Base” pack is the only one required for installation. However, the “Standard” pack is a group of plug-ins that is optional, but highly recommended and pre-selected.
Now that the SQuirreL SQL Client application is installed, we will launch it and configure it to connect to a LPC DB2 DEV database.
Now we can configure the DB2 HIT driver in the SQuirreL SQL Client. In the main window, there are two buttons on the far left-side of the application entitled “Aliases” and “Drivers”. Click on the “Drivers” button and the drivers panel will appear. This panel contains templates for each of the database product that is known to have a JDBC driver that can be loaded into the SQuirreL SQL Client .
Click on driver tab and below screen will pop up. Select the squirrel-sql.jar file as Java access class path. Select the driver from drop down of Class path as shown below.
Click on Extra Class Path tab and below screen will pop up as shown below.
Select the hitjdbcdb2-3.59.jar file from HIT Driver folder as Extra class path. Select the driver from drop down of Class path as shown below
Here I have used the URL as
jdbc:db2://10.5.5.11:4002;rdbname=GBLDB2D;package_collection_id=NULLID;catalog_qualifier = ODBAD
Please note this URL is same we used for CDP(Class Data Pump) for accessing mainframe DB2 table through IMR/CAS. And my LPC user Id and password to connect to dev db2 table through thin layer using HIT Driver.
Click on Test Button to test the connection of Squirrel SQL client with Db2 database.
Now that we have connected to the database, click on the SQL tab to access the SQL script editor. The following SQL statements should be typed into the script editor, ensuring that there is one line of white space between each statement and the next. Here, I have used to query the fetch first 100 rows from claim detail table from Dev Environment and was able to retrieve it.
This has been a short introduction to installing the SQuirreL SQL Client and connecting to a DB2 database. If anybody has questions or any specific problems on using the above Squirrel SQL client please let me know. Also if anybody has used this free tool before in a different way to connect to some other database, please share your understandings.
Questions/Suggestions/Comments are always welcome.
Thanks
Som
James Gosling, generally credited as the inventor of the Java programming language in 1994. He created the original design of Java and implemented its original compiler and virtual machine. For this achievement he was elected to the United States National Academy of Engineering.
Gavin King, is the founder of the Hibernate project, a popular object/relational persistence solution for Java, and the creator of Seam, an application framework for Java EE 5. Furthermore, he contributed heavily to the design of EJB 3.0 and JPA.
Rod Johnson, is the founder of the Spring Framework, an open source application framework for Java, Creator of Spring, CEO at SpringSource. Furthermore, Rod’s best-selling Expert One-on-One J2EE Design and Development (2002) was one of the most influential books ever published on J2EE
Craig Mcclanahan, creator of Struts, a popular open source MVC framework for building Java-based web applications, which is arguably that every Java developer know how to code Struts. With the huge success of Struts in early day, it’s widely implemented in every single of the old Java web application project.
Marc Fleury, who founded JBoss in 2001, an open-source Java application server, arguably the de facto standard for deploying Java-based Web applications. Later he sold the JBoss to RedHat, and joined RedHat to continue support on the JBoss development.
Joshua Bloch, led the design and implementation of numerous Java platform features, including JDK 5.0 language enhancements and the award-winning Java Collections Framework.
Kent Beck, creator of the Extreme Programming and Test Driven Development software development methodologies. Furthermore, he and Erich Gamma created JUnit, a simple testing framework, which turn into the de facto standard for testing Java-based Web applications.
James Duncan Davidson, while he was software engineer at Sun Microsystems (1997–2001), created Tomcat Java-based web server, still widely use in most of the Java web projects, and also Ant build tool, which uses XML to describe the build process and its dependencies, which is still the de facto standard for building Java-based Web applications.
Hi friends I am using this anti-virus from last 3 years and believe me i never got anything in mind to change this software and to use other. What i like most in ESET’s Nod32 is:
Visitor Rating: 5 Stars