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

Configuring the SQuirrel JDBC client for use with MySQL

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.

Home / Tutorials / Configuring the SQuirrel JDBC client for use with MySQL / 1

Applet Index
(sorted alphabetically)
A B C D E F G H I J K
L M N O P Q R S T U
V W X Y Z #s

The Java Source
(applets w/source code)
A B C D E F G H I J K
L M N O P Q R S T U
V W X Y Z

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.