About Us
Contact us

Facebook profile


Introduction to Squirrel SQL Database Client
Bookmark and Share

Setting Up A Database Alias

Now that we have successfully added the JDBC driver to our classpath, we need to add an alias to a specific database. This will allow us to quickly connect to the database. To add a new database alias, click on the "plus sign" icon at the top of the aliases window.

Squirrel SQL add database alias

To add an alias for a database in our RDBMS, we need to select it from the drop down menu labeled as "Driver", the example URL is then pre-populated in the URL text box.

Squirrel SQL enter database alias information

Enter a name for the alias, replace the example URL with the actual URL of the database we need to connect to, and enter a databse user name and password, then click on "OK". A database alias has now been created.

We can now connect to the database by double clicking on the newly created alias.

Squirrel SQL connect to database


In this article, we covered how to set up Squirrel SQL to connect to any JDBC supported relational database system. Topics covered included adding a JDBC driver to Squirrel SQL's classpath and adding an alias to a database.

In part 2 of this article we will cover using Squirrel SQL to work with any RDBMS, including some unique features that makes Squirrel SQL a very powerful SQL client.

Java EE 6 Development With NetBeans 7
Java EE 6 Development With NetBeans 7

Java EE 6 with GlassFish 3 Application Server
Java EE 6 with GlassFish 3 Application Server

JasperReports 3.5 For Java Developers
JasperReports 3.5 For Java Developers