Disclaimer : All the postings on this site are my own and don’t necessarily represent IBM’s positions, strategies or opinions.
This blog details steps to “Configure SQuirrel SQL Client to connect to SolidDB database” running on a remote machine/server.
SQuirrel SQL is a “Universal SQL Client”.
Visit http://squirrel-sql.sourceforge.net/ to get more details about this software. I like SQuirrel SQL for its good interface and ability to connect to multiple Database software. The ability of SQuirrel SQL to generate the graph of tables and their relationship would be very useful for understanding the design of relationships among tables in a database.
This link http://squirrel-sql.sourceforge.net/index.php?page=screenshots provides a detailed description of the various features of SQuirrel SQL.
I recently configured it for SolidDB database. I’ll list down some of the important things to be taken care of while doing this setup. In my case the SolidDB database was running on a AIX Power Server and SQuirrel SQL client was installed on my Ubuntu Linux Desktop. The steps would be same/similar even if your client is Red Hat, SUSE or even Windows.
1. Install SQuirrel SQL client on your Desktop / Laptop.
2. For connecting with the SolidDB database server, you need SolidDB JDBC Driver. Though SQuirrel SQL comes with many other JDBC drivers, SolidDB JDBC driver is not part of the package. JDBC driver for SolidDB is part of the installation setup of SolidDB. In my Ubuntu, I installed SolidDB in this path : /opt/solidDB/soliddb-6.5.
3. After installation of SolidDB, the JDBC driver was placed in this path : /opt/solidDB/soliddb-6.5/jdbc/SolidDriver2.0.jar.
4. I copied the SolidDB JDBC driver to the SQuirrel SQL client library path, where other DB drivers were placed. i.e. /opt/squirrel-sql-3.5.0/lib.
5. Now start the SQuirrel SQL client and follow the steps mentioned in the SolidDB documentation : Configuring SQuirrel SQL for use with solidDB .
6. The important step from the link mentioned in step 5. is to add the SolidDB JDBC driver to ‘SQuirrel SQL client’. This can be done by selecting “Drivers -> New Driver…” from the SQuirrel SQL UI and the providing these values in these fields :
Name : solidDB JDBC Driver
Example URL : jdbc:solid://<hostname>:<port>
Class Name : solid.jdbc.SolidDriver
7. After the Driver is added, next step is to “Add Alias” for the SolidDB server running on AIX. Select “solidDB JDBC Driver” from the list of Drivers and provide proper values for URL i.e. hostname and TCP/IP port where the SolidDB server is listening to. Also provide the ‘User Name‘ and ‘Password‘ of the SolidDB running on AIX.
8. Connect to the newly connected ‘Alias‘ and use the well known features of SQuirrel SQL connected to SolidDB.
C program (5)
Device Drivers (5)
Flash Caching (1)
Kernel Extension (3)
Subscribe to Blog via Email
Google Analytics Statsgenerated by GADWP
- pretty print symbols in AIX with kdb, KDBSYM, pr August 13, 2016
- Configure SAS controller/disk for use in AIX/VIOS partition May 15, 2016
- Enhanced num_cmd_elems attribute for virtual FC ( NPIV ) AIX March 19, 2016
- Shared Storage Pool v5 enhancements December 7, 2015
- Disk level validation for LPM of NPIV LPAR December 4, 2015