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

Connecting to Sybase DB using Squirrel SQL Client - Driver Class not found Exception

I am currently trying to connect to a Sybase DB using Squirrel Client. However, when I try to connect I am getting an error with the following stack trace. java.lang.RuntimeException: java.lang.ClassNotFoundException:…
Christopher Coleman
  • 126
  • 1
  • 9
0
votes
1 answer

Need help connecting Squirrel SQL Client 4.0.0 to IBM DB2

I need help negating this stack trace while trying to connect to the database: java.net.SocketException: Invalid argument: create at java.base/java.net.Socket.createImpl(Unknown Source) at java.base/java.net.Socket.connect(Unknown Source) …
Tom-Inge Nilsen
  • 15
  • 6
0
votes
0 answers

SQuirrel_SQL_Client_3.7.1 unable to connect to SQL server 2016 SSL error

we have migrated to SQL server 2016 and getting issue with SQuirrel_SQL_Client_3.7.1 connection as SSL error. SSL is not enforced on SQL server. From web i found we have to upgrade to SQL driver 4.2 or later. Currently we are using JDBC SQL Driver 4…
CIGEEK
  • 41
  • 7
0
votes
1 answer

Where is the Syntax-Autocorrect data stored in Squirrel-SQL snapshot 20190612_2127?

In older versions of Squirrel-SQL, autocorrect data was stored in an XML file as documented in Where does Squirrel SQL store its auto correct entries?. After updating to a more recent version, this file no longer exists in the same "syntax" folder…
benihaha
  • 11
  • 2
0
votes
1 answer

Connecting Squirrel Client to Embedded Teiid Server

I have a Spring Boot project, on which I have some csv files and have converted them into entities and querying them based on my requirement. For this approach, I am using Teiid Spring Boot Starter, which is starting a embedded server - This is the…
Debashis
  • 81
  • 1
  • 9
0
votes
1 answer

Trying to query data based on range of date but for only one time point

I am trying to query a MSSQL database through SQuirreL, which works if I just want all data through a range of timestamps. However, I would like to query a range of dates but for only one time point. I have been successful at performing this type of…
Gregory Boyle
  • 9
  • 3
0
votes
1 answer

How to change the font size in Squirrel results tab?

There is an option available to change the font size of the SQL entry area as shown below. I'm looking to modify the size of the text in the query table in results tab. Is there a separate menu available in UI to change the font sizes of the…
Harish
  • 638
  • 1
  • 10
  • 20
0
votes
1 answer

How to insert asian characters using Squirrel Sql

I'm running Squirrel-SQL on Ubuntu. I cannot write chinese characters on Squirrel, but I can write them in another text editor and copy+paste into squirrel. However, when I run the update and select the data I just inserted, the characters I write…
Corey
  • 1,133
  • 4
  • 17
  • 30
0
votes
1 answer

Connect Squirrel SQL to Hive

I followed these steps to connect Squirrel to Hive. https://cwiki.apache.org/confluence/display/Hive/HiveJDBCInterface#HiveJDBCInterface-IntegrationwithSQuirrelSQLClient In the fourth one, I get this error: Error registering driver: Hive. …
SA2018
  • 367
  • 4
  • 16
0
votes
1 answer

IBM Cloud: Connecting SQuirreL to Databases for PostgreSQL gives SSL error

I provisioned Databases for PostgreSQL on IBM Cloud. Now I try to connect SQuirreL to my database. However, my attempts result in this error: FATAL: no pg_hba.conf entry for host "xx.xx.xx.xx", user "myuser", database "my-database", SSL off Is…
data_henrik
  • 16,724
  • 2
  • 28
  • 49
0
votes
0 answers

SQuirreL SQL Client interface font too small

I would like to increase the font size of my SQuirreL interface because it's ridiculously small. I can't find the way to do that. Here how it look like: I would like to emphasize that I want to adjust the interface, not the font of the SQL, which…
Berdy
  • 34
  • 6
0
votes
2 answers

Squirrel Client with SAP Hybris

I'm new to SAP Hybris(6.2) and I need some help in looking up the Hsqldb tables (hybris\data\hsqldb). Someone told me to download Squirrel and connect the database driver to it, however, I'm unable to find any tutorial or document on connecting the…
sagar
  • 175
  • 1
  • 16
0
votes
0 answers

Connect to Hive using Squirrel SQL

I started Hadoop, Hive metastore and Hwi using the following commands, sh start-all.sh bin/hive --service metastore bin/hive –service HWI I then configured drivers with Squirrel SQL. The example URLs I have tried in my Squirrel SQL connection…
Aaron
  • 1,345
  • 2
  • 13
  • 32
0
votes
1 answer

Squirrel won't run (ClassNotFoundException : TextureLookAndFeel )

At work we had a java update, and then I tried opening my Squirrel today, and I get this error : 2018-08-01 16:20:04,936 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData - Unable to load LAF class …
Oliver Watkins
  • 12,575
  • 33
  • 119
  • 225
0
votes
1 answer

Connecting to Knox through Squirrel using Hive JDBC driver

I created a VMWare machine on my computer running Ubuntu. I set up Apache Knox on there using the demo LDAP and I'm currently trying to set up a connection string to Knox through SQuirreL. I can't use the Hortonworks Sandboxes because I need to make…
derpyburp
  • 1
  • 1
1 2 3
…
19 20