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
11
votes
5 answers

Calling an Oracle stored procedure in Squirrel SQL

I was able to create a stored procedure for an Oracle database, but now I can't figure out how to run it. I'm using SQuirrel SQL and this worked to create the procedure: CREATE OR REPLACE PROCEDURE MyProc(label IN varchar2, results OUT…
Kayeight
  • 111
  • 1
  • 1
  • 3
11
votes
2 answers

Create/replace trigger in Squirrel

I use squirrel 3.2.0 When I try to replace this trigger: CREATE OR REPLACE TRIGGER crw_ins_trig BEFORE INSERT OR UPDATE ON crew FOR EACH ROW DECLARE BEGIN if (:new.crw_id is null) then select crw_id_seq.nextval into…
A.W.
  • 2,858
  • 10
  • 57
  • 90
10
votes
2 answers

Oracle OCI and Thin drivers are missing in SQuirreL SQL

I downloaded SQuirreL SQL and I want to use it as an Oracle client, but when I go to Drivers tab, the following jars are missing: Oracle OCI Driver Oracle Thin Driver How can I fix this problem?
ROMANIA_engineer
  • 54,432
  • 29
  • 203
  • 199
10
votes
4 answers

Keyboard shortcuts (Autocomplete) for Squirrel SQL

I searched but could not quite find this information anywhere else. Could you list the best shortcut keys Squirrel? I know it is possible to avoid a lot of typing with this feature of the tool. The only one I know is to type SF and then press the…
Uder Moreira
  • 865
  • 6
  • 17
  • 33
8
votes
2 answers

In Squirrel, how can I duplicate a row?

In a tool like SQL Developer, I can right click on a row and select duplicate to get a copy of row, edit it, and commit it. How can I do this in Squirrel? I don't even see how to add a new row in the Content view.
Cincinnati Joe
  • 2,077
  • 6
  • 23
  • 32
8
votes
5 answers

Increasing Heap size for SQuirreL SQL on Max OS X

I'm running SQuirreL SQL (2.6.8) on Max OS X. I'm running out of heap space when trying to create a Table script. How to configure SQuirreL SQL to start up with a higher JVM heap size?
Erik
  • 997
  • 4
  • 14
  • 24
8
votes
2 answers

How to configure Squirrel SQL client to work with MS Access

I'm struggling to get Squirrel SQL to connect to MS Access database (just a normal one, no password): I create an Alias and use Driver: JBDC ODBC bridge (There is a tick in front of this driver) I don't know what to put in URL -------- I use: Path…
Harry Duong
  • 407
  • 6
  • 14
8
votes
1 answer

Could not connect to SQL Database using SQuirrelSQL

I encounter the following error when trying to connect to a database using SQuirreLSQL. Error : Unexpected Error occured attempting to open an SQL connection Stacktrace : java.util.concurrent.ExecutionException: java.lang.RuntimeException:…
ariabele
  • 355
  • 1
  • 4
  • 9
8
votes
2 answers

Connect to IBM DB2 with SQuirreL "Reply.fill(). Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001"

I have now tried 2 days to connect to external DB2 database with SQuirreL. I always get error: [jcc][t4][2030][11211][3.58.82] A communication error occurred during operations on the connection's underlying socket, socket input stream, or socket…
vellotis
  • 829
  • 1
  • 12
  • 26
7
votes
9 answers

How can I call a DB2 stored procedure with OUT parameters from SQuirreL SQL?

I really like SQuirreL SQL as a SQL query tool, but I've never been able to get it to call stored procedures in our AS/400 DB2 database. I always get the error "The number of parameter values set or registered does not match the number of…
KC Baltz
  • 1,498
  • 1
  • 13
  • 22
7
votes
1 answer

Formatting of numbers: Get rid of thousand separators (comma, quote, etc)

I use version 3.4.0 of SQuirreL SQL client, and whenever I execute a request that returns numbers (IDs for example), the result numbers are formatted with commas, i.e. 123,456,789 instead of plain 123456789. How can I change this formatting, so that…
Bubolina
  • 141
  • 2
  • 16
7
votes
2 answers

Configure SQuirrel SQL Client to work for DB2/AS400

I use the ancient System i Navigator (french) to get to query a DB2 (AS/400) database. I liked to update the client and use a more fresh (and English) sql client for that database. So, I installed the SQuirrel SQL client (3.5.0, the latest at…
serhio
  • 28,010
  • 62
  • 221
  • 374
6
votes
1 answer

Open existing database file in SQuirreL

I have installed SQuirreL client to open my file database. I have file named "database.h2.db" and I want to read its content. Well, that's first time I work with database like that. All I need to do is simple change some data in it. I'm not working…
Patrik Krehák
  • 2,595
  • 8
  • 32
  • 62
6
votes
2 answers

How to call a stored procedure using a ref cursor in Oracle with squirrel

I'm trying to do the same request I'm using in Toad (the stored procedure signature is two varchar2 parameter and one REF CURSOR parameter) Here is what I do with Toad variable myCursor refcursor; EXEC myproc('param1','param2',:myCursor ); print…
rapdum
  • 323
  • 1
  • 2
  • 7
5
votes
1 answer

Squirrel Client Connecting to Phoenix - Timeout Exception

I am trying to connect to Phoenix via Squirrel client. I am receiving the following logs in the Squirrel logs. The logs suggests that the ClientConnection to zooperkeeper is established however it fails when a SQLClient Connection is being…
Rashmi Mahale
  • 81
  • 1
  • 6
1
2
3
…
19 20