Tutorials : Configuring the SQuirrel JDBC client for use with MySQL :

Configuring the SQuirrel JDBC client for use with MySQL

by Preeti Iyer

SQuirrel is an SQL client written in Java that can greatly ease development efforts by permitting the developer to glance at a database’s contents without explicitly issuing query statements, and also view the contents of tables. Additionally, SQuirrel’s friendly GUI provides a SQL area within which to execute and test out SQL commands. This article describes step by step, the process of setting-up and using SQuirrel with another very popular open source offering we should all be familiar with MySQL.

1. Download and install any of the squirrel-sql-XXXfinal1- install.jar files from http://sourceforge.net/project/showfiles.php?group_id=28383

2. Double-click the jar file and extract/install (this process is easy and intuitive).

3. Download the MySQL driver from http://www.mysql.com/downloads/api-jdbc-stable.html. Extract it to the directory of your choice. (In this article, the directory C:\jars\ will contain the .jar files)

Note: MySQL must be installed and running before configuring Squirrel. So fire-up MySQL now if you haven’t already.

4. Open the squirrel client. You will encounter the following screen

Figure 1.

How to Add Java Applets to Your Site

New on the Java Boutique:

New Review:

Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling API boasts simplicity, ease-of-integration, a well-rounded feature set, and it's free!

New Applet:

Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA sequences into three useful formats.

Elsewhere on internet.com:

WebDeveloper Java
Lots of Java information on webdeveloper.com

WDVL Java
Thorough Java resource at the Web Developer's Virtual Library.

ScriptSearch Java
Hundreds of free Java code files to download.

jGuru: Your View of the Java Universe
Customizable portal with online training, FAQs, regular news updates, and tutorials.