Stack Overflow
Stack Overflow

Questions tagged [squirrel-sql]

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

Summary

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

Website

  • Project Homepage
  • Download squirrel-sql-x.x.x-optional if you want all of the plugins installed.

Features

  • Supports autocomplete when creating queries by pressing CTRL+SPACE.
  • On-the-fly generation of ERD diagrams.

Useful Keyboard Shortcuts

  • CTRL+SPACE - autocomplete database, table, and fields in queries.
  • CTRL+t - SQL Editor Tools Popup
  • CTRL+j - Display Query Bookmarks
    (Note: need to enable with CTRL+t edit bookmarks first.)
  • CTRL+SHIFT+, / CTRL+SHIFT+. - switch to prev/next results tab

Useful Plugins

  • UnityJDBC - A plugin for SQuirreL that allows queries involving multiple kinds of databases, much in the same way that MS-Access allows linked tables.
290 questions
1
vote
3 answers

Fix SQL with more than 255 UNION ALL statements

Is there any way I could optimize the below SQL in DB2 : The below SQL is a combination of 257 UNION ALL statements. This query works when I m combining less than 255 UNION ALL statements, but fails with the below error when we are trying to execute…
user1993412
  • 802
  • 2
  • 15
  • 29
1
vote
2 answers

Where does Squirrel SQL store its auto correct entries?

I use Squirrel SQL as my goto SQL editor for DB2 for iSeries, and one feature I love is the autocorrect. I enter shortcuts into the editor like ssf and "select * from" pops up. I know it's possible to add entries to the library one row at a time,…
oxwilder
  • 756
  • 5
  • 14
1
vote
0 answers

Create procedure fails due to semicolons

I have a Postgres database that I connect to using SQL Squirrel (which under hood uses the postgres jdbc driver). When I run the following statement (which is valid sql, copied directly from this page) CREATE PROCEDURE insert_data(a integer, b…
ThatDataGuy
  • 1,969
  • 2
  • 17
  • 43
1
vote
0 answers

How to create a variable in SQuirrel SQL

I'm trying to figure out how to create a variable in SQuirrel SQL that can be used in a query. Help! Just a simple piece of code would suffice. Something that would be similar to the code below. DECLARE @iVariable INT = 1, @vVariable…
jondough
  • 21
  • 2
1
vote
1 answer

Squirrel can not find an informix drivers

This is my first question in this program, but I really can't find a drivers for squirrel SQL client. When I try to connect to INFORMIX I get error like this "Could not find class com.informix.jdbc.IfxDriver in neither the Java class path nor…
Gytis Gedminas
  • 11
  • 1
  • 2
1
vote
0 answers

PL/SQL on SquirreL SQL Client 3.8.1

I am trying to execute a PL/SQL anonymous block with SQuirrel SQL: BEGIN NULL; END; / However, I get this error: Error: ORA-06550: line 2, column 5: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: …
A Jar of Clay
  • 5,622
  • 6
  • 25
  • 39
1
vote
1 answer

Squirrel - changing driver properties not possible

I use Squirrel 3.8.1 and try to configure a connection to Amazon Redshift via driver RedshiftJDBC42-1.2.1.1001.jar. However, I am not able to change the properties of the driver which are listed in tab Driver properties. I check the Specify box and…
AgeBee
  • 11
  • 1
1
vote
1 answer

VBA, Query Vertica database and populate to excel

I query a vertica database (using squirrel-sql tool). Is this possible to be done in excel and populate into a worksheet? Does anyone have a possible solution for this? Can't find anything about this online. I have the driver location, host name,…
excelguy
  • 1,574
  • 6
  • 33
  • 67
1
vote
3 answers

Support for JRE-9 on SQUIRREL JDBC client

Does anyone know when SQuirreL the JDBC Client will support java-9? At the moment I get an error that the version is not supported, It fails while testing the java version on the start-up script. Does anyone know when a release for 9 will be out?
Jose Alberto Fernandez
  • 126
  • 2
  • 5
1
vote
1 answer

Cassandra Datastax Driver with Squirrel SQL

I'm trying to use the Datastax driver cassandra-driver-core-3.0.0.jar with the Squirrel SQL client. The problem is that I don't know what to put in the class name field. Does anyone know? Or does anyone know how I would figure it out? I think it's…
user7748021
1
vote
1 answer

Squirrel SQL gives: FATAL: database "localhost:5432:postgres" does not exist

I want to use Squirrel SQL since it seems a good alternative to pgAdmin but I do not succeed to connect with database postgresSQL, respectively, MariaDB. The error I got is: java.util.concurrent.ExecutionException: java.lang.RuntimeException:…
giordano
  • 2,954
  • 7
  • 35
  • 57
1
vote
0 answers

How to connect with squirrel in node js

I am totally new to nodejs and squirrel both.I am trying to make a connection with squirrel having some tables in it through node js. I achieved to connect with mysql previously. But now my connction code is not working for squirrel Here is my…
Nyki
  • 97
  • 1
  • 9
1
vote
1 answer

Exception in thread - Squirrel SQL Client

Specs: Kali Linux squirrel-sql-snapshot-20170214_2214 openjdk version "1.8.0_121" OpenJDK Runtime Environment (build 1.8.0_121-8u121-b13-3-b13) OpenJDK 64-Bit Server VM (build 25.121-b13, mixed mode) Error: Exception in thread "main"…
Cheyenne Forbes
  • 491
  • 1
  • 5
  • 15
1
vote
0 answers

SQuirrel and UCanAccess

I am trying to configure SQuirrel to work with UCanAccess and get the following error: The UCANACCESS_HOME system variable isn't defined: it should be: -DUCANACCESS_HOME= I defined the variable as a system variable but it does not work
Frank Morreale
  • 11
  • 1
1
vote
0 answers

squirrel sql installation

I have a question regarding SQL Squirrel installation. Someone at work told me that we can use sql squirrel already packaged as java executable. I am not sure what he means and what i need to do at my end to get SQL Squirrel going. Any help is…
software_art
  • 57
  • 3
  • 8
1 2 3
…
19 20