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
4
votes
3 answers

How can I list all databases with Squirrel SQL?

Squirrel SQL would become my favourite SQL tool if only it would have one function: I need to connect to one and only database (alias) and I need to define it manually. Can I connect to all databases or at least browse the databases on server and…
4
votes
3 answers

Executing SQL Server stored procedure in sql squirrel

i'm in ubuntu 9.04 and using sql squirrel as my sql client. i connect to a remote SQL Server. There are some stored procedures in the db. I don't know how to execute them. No explicit gui. Earlier i was in windows and i could use management studio.…
Senthil Kumar
  • 9,695
  • 8
  • 36
  • 45
4
votes
1 answer

Colored cells in Squirrel SQL client

I use Squirrel SQL client to query my DB2 database. When I query one of the tables, I see some of the cells background are shown colored (teal). I am not sure why those cells can be shown in a teal color while other cells’ background are still in…
Harish
  • 638
  • 1
  • 10
  • 20
3
votes
4 answers

How to view Stored Procedures in Squirrel

Would like to know if one can view stored proc is Squirrel. Is there a plugin for this?
sonx
  • 661
  • 4
  • 19
  • 31
3
votes
2 answers

Implementing change in ThreadPoolSize on client side - JDBC driver Apache Phoenix

I have recently set up a JDBC driver to connect to Hadoop db using Apache Phoenix. Basic queries on Squirrel have worked well (for example, "select * from datafile"), but as soon as I ask a slightly more complicated query (ie, "select column1 from…
mmcclarty
  • 31
  • 3
3
votes
0 answers

SQuirreL SQL Client: How to expand and select the table node on startup?

I have already asked the same question for pgAdmin. I would like SQuirreL SQL Client to either automatically expand the object tree to PUBLIC.TABLE or even better: restore selection/expansion state of last session Bonus points: How to show the…
Reto Höhener
  • 5,419
  • 4
  • 39
  • 79
3
votes
1 answer

How to generate an insert script from a table with SQuirreL

I want to generate an insert script for a table. I don't know how to generate it from the table structure with SQuirreL as I do it with pgAdmin. With pdAdmin I do this: Getting this result: I have tables with a lot of columns(60) and I really…
Kaz Miller
  • 949
  • 3
  • 22
  • 40
3
votes
1 answer

Getting Read time out when connecting to hive/spark sql through squirrel sql

I'm trying to use Squirrel SQL to connect to spark-sql thriftserver using jdbc. For smaller resultset I'm getting the response. But for queries which are running for more than 30s, Squirrel throws the below exception: Error:…
Gayatri Mahesh
  • 327
  • 1
  • 3
  • 12
3
votes
1 answer

Cant connect to MySQL via Squirrel - Unable to create connection. Check your URL

I can't connect to our database using Squirrel. I am certain my URL is correct as I'm using it via my java code to access the database. I got the drivers from here: http://dev.mysql.com/downloads/file.php?id=454395 What is interesting is when I add…
ratsstack
  • 1,012
  • 4
  • 13
  • 32
3
votes
1 answer

Undefined method 'total_entries' after upgrading Rails 2.2.2 to 2.3.5

I am upgrading a Rails application from 2.2.2 to 2.3.5. The only remaining error is when I invoke total_entries for creating a jqgrid. Error: NoMethodError (undefined method `total_entries' for #) Code snippet: @route =…
Trevor
  • 6,659
  • 5
  • 35
  • 68
3
votes
1 answer

"Unexpected Error occurred attempting to open an SQL connection." when opening InMemory DB using SQuirreL SQL Client 3.5.0

We have an event generation mechanism that generates & save the events in a flatfile (or say DB file to make it easy). To view this event in DB we complete the run for generating the events & then we use "SQuirreL SQL Client 3.5.0". When the size…
Xat
  • 127
  • 1
  • 3
  • 10
3
votes
1 answer

Same query, different results. Possible causes?

For testing purposes, I am querying the same table from the same database using two different GUIs (RStudio and SquirreLSQL). The query in the SquirreLSQL console looks like this: select count(distinct idstr) from fact_table where…
zebrainatree
  • 351
  • 1
  • 3
  • 15
3
votes
1 answer

Unable to edit alias properties in SQuirreL SQL Client Version 3.5.0?

I'm unable to edit the properties for my DEV alias. The connection to my oracle 11g db is fine, I just need to 'trim the fat' so I don't load everything from the schema. I'm using the Oracle Thin Driver. Anyone have any suggestions?
destepp11
  • 53
  • 8
3
votes
1 answer

Connect to Hive server using SquirrelSQL client

I am trying to connect SquirrelSQL client to Hive. I am running Hadoop/Hive on a Debian 7.0 VM on virtualbox. Hive server is online, and when I ping my vm with my laptop client, the vm is responding, it's OK. Then, I trying to connect to Hive using…
user2462699
  • 429
  • 2
  • 8
  • 17
3
votes
0 answers

Squirrel client can't connect to MySQL instance: bad driver?

I am using Squirrel to connect to a MySQL instance being hosted on CloudBees. I downloaded what I believe is the correct JDBC driver, and installed it to Squirrel's lib directory at: ~/squirrel-sql-3.4.0/lib/mysql-connector-java-5.1.25-bin.jar I…
user1768830