Squirrel

SQuirreL SQL is an open-source Java SQL Client program for any JDBC compliant database.

Installation of Squirrel 3.5.0

Goto http://sourceforge.net/projects/squirrel-sql/files/1-stable/3.5.0/squirrel-sql-3.5.0-install.jar/download and download the install JAR.

Run java -jar squirrel-sql-3.5.0-install.jar:

Next,
Next,
Installation path <home dir>/squirrel-sql-3.5.0
'The target directory will be created': ok
Select Base, Standard, Optinal PLugins for Microsoft SQL Server, PostgreSQL, MySQL, Oracle
Next
Next
Next
Done

JDBC for MS SQL Server

Microsoft JDBC Driver 4.0 for SQL Server in http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774 Language English.

wget [[http://download.microsoft.com/download/0/2/A/02AAE597-3865-456C-AE7F-613F99F850A8/sqljdbc_4.0.2206.100_enu.tar.gz]]
cp sqljdbc_4.0.2206.100_enu.tar.gz /tmp
cd /tmp
tar xvzf sqljdbc_4.0.2206.100_enu.tar.gz
cd /tmp/sqljdbc_4.0/enu
sqljdbc4.jar
cp /tmp/sqljdbc_4.0/enu/sqljdbc4.jar /home/vitor/squirrel-sql-3.5.0/lib

Restart Squirrel

Add connection URL to MSSQL Server

Menu Aliases
new Alias
Name for connection: MSSQLConn
Driver Microsoft MSSQL Server JDBC Driver
URL: jdbc:sqlserver://hostname:1433;databaseName=dbx
Username: userx
Password: passx
Click on test
Click on OK

JDBC for Postgresql

wget http://jdbc.postgresql.org/download/postgresql-9.2-1002.jdbc4.jar
cp postgresql-9.2-1002.jdbc4.jar <home dir>/squirrel-sql-3.5.0/lib
Restart Squirrel

Add connection URL to PostgreSQL

Menu Aliases
new Alias
Name for connection: PGConn
Driver PostgreSQL
URL: jdbc:postgresql://exampleserver.net:5432/databaseTest
Username: userx
Password: passx
Click on test
Click on OK

JDBC for Oracle

Get ojdbc6.jar
cp ojdbc6.jar <home dir>/squirrel-sql-3.5.0/lib
Restart Squirrel

Add connection URL to Oracle

Menu Aliases
new Alias
Name for connection: Oracle conn
Driver Oracle Thin driver
URL: jdbc:oracle:thin:@serverx:1521:dbx
Username: userx
Password: passx
Click on test
Click on OK

Squirrel 4.0

   1 java -jar squirrel-sql-4.0.0-standard.jar
   2 ./squirrel-sql-4.0.0/squirrel-sql.sh
   3 cp sqljdbc_6.0/enu/jre8/sqljdbc42.jar ~/squirrel-sql-4.0.0/lib/
   4 mv ~/Downloads/jaxb-api-2.3.0.jar ~/squirrel-sql-4.0.0/lib/

-  ⇤ ← Revision 5 as of 2020-04-21 09:10:27 → 
  Size: 2605
  Editor: localhost
  Comment:
+   ← Revision 10 as of 2026-02-21 15:36:19 → ⇥
  Size: 2843
  Editor: vitor
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 1:
+<<TableOfContents(2)>>
-Line 21:
+Line 23:
- * wget [[http://download.microsoft.com/download/0/2/A/02AAE597-3865-456C-AE7F-613F99F850A8/sqljdbc_4.0.2206.100_enu.tar.gz]]
 * cp sqljdbc_4.0.2206.100_enu.tar.gz /tmp
 * cd /tmp
 * tar xvzf sqljdbc_4.0.2206.100_enu.tar.gz
 * cd /tmp/sqljdbc_4.0/enu
 * sqljdbc4.jar
 * cp /tmp/sqljdbc_4.0/enu/sqljdbc4.jar /home/vitor/squirrel-sql-3.5.0/lib
+{{{
wget [[http://download.microsoft.com/download/0/2/A/02AAE597-3865-456C-AE7F-613F99F850A8/sqljdbc_4.0.2206.100_enu.tar.gz]]
cp sqljdbc_4.0.2206.100_enu.tar.gz /tmp
cd /tmp
tar xvzf sqljdbc_4.0.2206.100_enu.tar.gz
cd /tmp/sqljdbc_4.0/enu
sqljdbc4.jar
cp /tmp/sqljdbc_4.0/enu/sqljdbc4.jar /home/vitor/squirrel-sql-3.5.0/lib  }}}
-Line 75:
+Line 78:
- * https://netix.dl.sourceforge.net/project/squirrel-sql/1-stable/4.0.0/squirrel-sql-4.0.0-standard.jar
 * https://download.microsoft.com/download/0/2/A/02AAE597-3865-456C-AE7F-613F99F850A8/sqljdbc_6.0.8112.200_enu.tar.gz
 * java -jar squirrel-sql-4.0.0-standard.jar
 * ./squirrel-sql-4.0.0/squirrel-sql.sh
+ * [[ https://netix.dl.sourceforge.net/project/squirrel-sql/1-stable/4.0.0/squirrel-sql-4.0.0-standard.jar | squirrel-sql-4.0.0-standard.jar ]]
 * [[ https://download.microsoft.com/download/0/2/A/02AAE597-3865-456C-AE7F-613F99F850A8/sqljdbc_6.0.8112.200_enu.tar.gz | sqljdbc_6.0.8112.200_enu.tar.gz ]]
{{{#!highlight sh
java -jar squirrel-sql-4.0.0-standard.jar
./squirrel-sql-4.0.0/squirrel-sql.sh
cp sqljdbc_6.0/enu/jre8/sqljdbc42.jar ~/squirrel-sql-4.0.0/lib/
mv ~/Downloads/jaxb-api-2.3.0.jar ~/squirrel-sql-4.0.0/lib/
}}}