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