MoinMoin Logo
  • Comments
  • Immutable Page
  • Menu
    • Navigation
    • RecentChanges
    • FindPage
    • Local Site Map
    • Help
    • HelpContents
    • HelpOnMoinWikiSyntax
    • Display
    • Attachments
    • Info
    • Raw Text
    • Print View
    • Edit
    • Load
    • Save
  • Login

Navigation

  • Start
  • Sitemap
Revision 4 as of 2020-04-21 09:09:21
  • Squirrel

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
  • MoinMoin Powered
  • Python Powered
  • GPL licensed
  • Valid HTML 4.01