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
3
votes
1 answer

displaying db2 error codes in SquirrelSQL

When you run a query in db2 commandline tool you get explanations like: db2 => select * from sysibm.systables where owner = 'SAM' and type = 'T'; SQL0206N "OWNER" is not valid in the context where it is used. SQLSTATE=42703 However, when ran in…
LetMeSOThat4U
  • 6,470
  • 10
  • 53
  • 93
3
votes
2 answers

"Error: ORA-04098: trigger 'CA0513.ITEMAVGRATINGTRIGGER' is invalid and failed re-validation"

I'm creating a trigger: CREATE OR REPLACE TRIGGER ItemAvgRatingTrigger AFTER INSERT OR UPDATE OF rating ON Collectionitems REFERENCING NEW AS newRow FOR EACH ROW BEGIN UPDATE Item SET rating = (SELECT AVG(Collectionitems.rating) FROM…
Will Andrew
  • 693
  • 1
  • 10
  • 29
2
votes
2 answers

Debug SQL queries in SQuirrel-sql

How do I go about debugging a SQL statement in SQuirrel-sql? I keep getting "unhelpful" errors like: Error: [SQL0104] Token , was not valid. Valid tokens: ) OR. SQLState: 42601 ErrorCode: -104 I would love to be able to see the line number where…
Christoff Erasmus
  • 925
  • 1
  • 10
  • 26
2
votes
0 answers

Golang Postgres Squirrel Syntax Error (SQLSTATE 42601)

I'm simply trying to insert my object in which one of the fields is a slice. So I built my query with Squirrel like below: squirrel.StatementBuilder.PlaceholderFormat(squirrel.Dollar).RunWith(db).Insert("educations"). Columns("id", "school",…
thousight
  • 1,134
  • 1
  • 14
  • 39
2
votes
1 answer

Assign more memory to SQuirreL SQL Client

I am using SQuirreL 3.8.1 on Windows 10. If I open large tables I receive the following error. Error occurred during task execution: Java heap space Apparently, this has something to do with the memory that is allocated to my SQuirreL…
Stücke
  • 868
  • 3
  • 14
  • 41
2
votes
2 answers

Cant connect to oracle db in docker with squirrel-sql

I tried to connect to oracle db 11 in docker (https://hub.docker.com/r/sath89/oracle-xe-11g/). Started docker with command: docker run -d -p 8080:8080 -p 1521:1521 -e DEFAULT_SYS_PASS=sYs-p@ssw0rd sath89/oracle-xe-11g From this…
Vadim
  • 557
  • 8
  • 21
2
votes
1 answer

Squirrel SQL - UCANACCESS_HOME system variable isn't defined

Setup Windows 10 1709, 16299.64 Squirrel SQL squirrel-sql-3.8.0 installed at "C:\Program Files\squirrel-sql-3.8.0" UCanAccess UCanAccess-4.0.2-bin installed at "C:\Java\UCanAccess-4.0.2-bin" Java 8 Update 151 I'm new to Squirrel SQL. I'm…
user2970483
  • 323
  • 5
  • 14
2
votes
0 answers

Unable to launch squirrel client

Unable to launch squirrel client.. When I hit on squirrel jar , it flashes launch pop up window and then disappears. I am using windows 7 enterprise 64 bit I have set the Java Home path When I launch squirrel-sql.bat.. I get below error:-The system…
ss271189
  • 21
  • 6
2
votes
1 answer

Edit Squirrel shortcuts

Someone knows if there is a way to edit keyboard shortcuts in sQuirrel? Some of them have conflicts with the SO ones. This question comes from an old "windowser" and new "linuxer". I would rather not change the SO shorcuts.
Malefactor
  • 21
  • 4
2
votes
1 answer

I've been SQuirreLed

I'm seeing something extremely strange.. in SQuirreL I am updating the column of a SQL table to have a ReviewDueDate of '2016-08-15 00:00:00.000' (and also tried cast('2016-08-15' as datetime)). When I query the same row I am seeing a value of…
jKlaus
  • 382
  • 3
  • 8
2
votes
1 answer

SELECT / Querying "into" JSON arrays

I have a PostgreSQL 9.4.5 database. There's a table itemtable with a JSONB column called data, which contains sets of information like so (lots of stuff stripped for brevity): { "items": [ { "id": 158597 }, { "id": 156300 }, (...) ]…
zb226
  • 9,586
  • 6
  • 49
  • 79
2
votes
2 answers

Connect to mysql / oracle database with ssh

I want to connect to my database with the tool SquirreL in ssh. Is it possible? Sadly I have no other options for this server, so I ll have to change of tool if it is not working.
Nicolas D
  • 1,182
  • 18
  • 40
2
votes
0 answers

how to connect to secure hbase cluster using SQuirreL SQL

I am trying to setup SQuirreL SQL client to connect to secure hbase cluster deployed on CDH5.4.3. I have copied kerberos keytab file, hbase-site.xml and core-site.xml in lib directory of SQuirreL SQL. I am using phoenix-4.3.0-client containing all…
dev
  • 143
  • 2
  • 9
2
votes
3 answers

Query select rows based on distinct values of a column

i have a problem for my current query, i wish to get record/result based on a column (example column Status have the value of new/pending/completed for the query i execute if there are 3 record with status new,it should be filter to show 1 record…
FruitLai
  • 23
  • 3
2
votes
1 answer

Squirrel Setup to connect to Phoenix - HBASE: Error java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.NoSuchMethodError:

I am a newbie to Hbase & phoenix. I am trying to connect to HBASE via Phoenix JDBC Driver using Squirrel Client. Somehow I seem to get a strange error where the runtime complains of a NoSuchMethod Exception. I have included the relevant client jar…
Rashmi Mahale
  • 81
  • 1
  • 6
1 2 3
…
19 20