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
2
votes
2 answers

squirrelsql doesn't like query_to_xml

I am using an SQL that includes query_to_xml: select query_to_xml('select 1+1 answer', true, true, '') as_xml; When any SQL with query_to_xml is executed in Squirrel SQL it will result in: | as_xml | +--------------------+ |
Sven
  • 892
  • 14
  • 29
2
votes
1 answer

How to disable creation of SQUIRREL_GET_ERROR_OFFSET in Squirrel SQL?

Squirrel SQL creates a function on the oracle database called SQUIRREL_GET_ERROR_OFFSET. This was questioned by our DBAs. I found an explanation on what it is, but not how to turn off its creation. I am using Squirrel SQL version 3.5.3. It is a…
rlshep
  • 580
  • 4
  • 13
2
votes
1 answer

Squirrel Client Stored Procedure

I am unable to create a stored procedure for an Oracle database using Squirrel Client. CREATE OR REPLACE PROCEDURE Notify_Ins( ID NUMBER, NAME CLOB, EMAILID VARCHAR2) as begin INSERT INTO test2 ("ID", "NAME", "EMAILID") …
Suraj
  • 407
  • 1
  • 8
  • 12
2
votes
1 answer

Squirrel - DB2 : Connection to the data server failed. The IBM Data Server for JDBC and SQLJ license was invalid

I am using squirrel to connect to DB2 database. I am able to successfully connect to one of our DB2 databases. But when I create a new connection to point to another db2 database, I get the below mentioned…
user2928913
  • 223
  • 1
  • 6
  • 15
2
votes
1 answer

Squirrel access to Phoenix/HBase

I got phoenix 4.0 running on hbase 0.98/hadoop 2.3.0 and was impressed by the command line tools. In the second step I followed the description on the webpage to connect to phoenix using its bundled JDBC driver. When I try to connect I get the…
woopi
  • 368
  • 2
  • 9
2
votes
1 answer

Squirrel SQL Exception Logging

I am developing a JDBC driver which is a wrapper for a web service. My unit tests work fine and I can write my own Java code that uses the driver to do useful things. When I plug it into Squirrel SQL it is able to connect and get its initial batch…
user439793
2
votes
0 answers

Why does my H2 query run very fast in Squirrel but very slow in my Java code?

I created a query on an H2 database that uses left outer joins on 7 tables. There are indexes on each table that reference the join columns. When I cut and paste the sql and execute it in Squirrel, the execution time is very fast, maybe 10…
user3372207
  • 21
  • 3
2
votes
1 answer

Missing Explain Plan tab in SQuirreL SQL

I seem to suddenly be missing the Explain Plan tab next to the Results tab in SQuirreL when logging on to Oracle. Does anybody know whether this could be due to a setting somewhere or a missing plugin? I couldn't find an obvious option (or in fact…
nsandersen
  • 896
  • 2
  • 16
  • 41
2
votes
0 answers

SquirrelSQL won't start/open

I haven't been using my Squirrel SQL application in a while and when I tried to open it now, it loads all the plugins and then goes to the task bar but when you click on it, the window doesn't show. There's no error warning or anything it just goes…
Carlos Escalera Alonso
  • 2,333
  • 2
  • 25
  • 37
2
votes
1 answer

DB2 stored procedure in sql using squirrel. Unable to loop

I am unable to use %notfound as I get the following error. How can I get past this?? I'm unable to figure out a way to use cursors apart from this method. Please help with other methods to use a cursor loop without using %notfound. The character…
Sherri
  • 23
  • 2
  • 5
2
votes
1 answer

Using squirrel sql with postgresql: backslash syntax error?

I am trying to run basic postgresql commands which start with a backslash within Squirrel SQL sql client. For example, I'd like to be able to type \dt to mean "SHOW TABLES" instead of "SELECT * FROM information_schema.tables WHERE table_schema…
vancan1ty
  • 563
  • 1
  • 4
  • 16
2
votes
0 answers

SQuirreL sql mmsql microsoft server SSO connection

Just adding this for others help (and my future reference) when setting up squirrel sql on windows domain and having connection hassles. Assumming the following: That "SQL Server and Windows Authentication mode" is set in MSSMS (m$ sql server…
Gary Thomann
  • 576
  • 6
  • 17
2
votes
2 answers

Group By making query astronomically longer

*As a first note, I only have read access to my server. Just, FYI as it seems to come up a lot... Server:DB2(6.1) for i (IBM) I have a query I'm running on a table that has 19mil rows in it (I don't design them, I just query them). I've been…
Jay Carr
  • 1,195
  • 6
  • 16
  • 32
2
votes
1 answer

Squirrel and setting up drivers

I like SQuirreL, but I am having a hell of a time getting the driver set up! I am trying to connect to a Intersystems Cache Database. I have downloaded the CacheBD.jar file but SQuirreL continually gives me the error: Could not find class CacheBD…
Leslie
  • 3,604
  • 7
  • 38
  • 53
2
votes
2 answers

Passing parameters from one query to a view in MS-Access?

If you define a query in Microsoft Access, For instance, SELECT * FROM T_Employees t WHERE t.LastName=[LastName] a popup dialog will display asking you to enter a value for LastName. LastName a named parameter. Now from here one can also create…
leeand00
  • 25,510
  • 39
  • 140
  • 297
1 2 3
…
19 20