= 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 ==
 * 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
 * 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/