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
1
vote
0 answers

SQuirreL database, and standard deviation

I'm using Python to load data into an embedded SQLite database (i.e. just an SQLite file). Following that, I'm using SQuirreL to connect to the file and analyze the data. I'd like to be able to use standard deviation as part of my analysis, but…
Neil McF
  • 259
  • 1
  • 15
1
vote
0 answers

How does Squirrel add jdbc jars dynamically?

Java Squirrel is an great sql tool. It supports ALL databases. I checked it. The only thing you need to do is to point to an external jar. However, in java, a classpath is immutable. How is it possible? Here is the only solution that works How…
john
  • 647
  • 5
  • 23
  • 53
1
vote
0 answers

SQuirreL SQL for Oracle & IBM UDB

I tried using SQuirreL SQL for Oracle & UDB databases, I see some functionality are missing for both Oracle & UDB. Have anyone faced/observed similar issues and any workaround/fixes for the same. Below are the issues which I see: Oracle using ojdbc7…
Satsun
  • 33
  • 4
1
vote
0 answers

Error connecting SQuirrel to TIBCO Activespaces

I am trying to connect to TIBCO ActiveSpaces using SQuirrel SQL client. I am receiving the following error. Below is the stack trace java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.NoClassDefFoundError:…
3nadh
  • 76
  • 4
1
vote
1 answer

Apache Phoenix LIMIT OFFSET Error

I need to know what the error means and how to debug it. Here is what I did. Query1: SELECT * FROM us_population ORDER BY population DESC; Result1: NY New York 8143197 CA Los Angeles 3844829 IL Chicago 2842518 TX Houston …
vhen
  • 105
  • 12
1
vote
0 answers

Inserting rows through SQirreL SQL Client for Apache Phoenix

Using: SQuirreL SQL Client Version 3.7 Phoenix Thin Drive Database us_population is already created by running the following query in SQuirreL SQL Client CREATE TABLE IF NOT EXISTS us_population ( state CHAR(2) NOT NULL, city VARCHAR…
vhen
  • 105
  • 12
1
vote
1 answer

Batch delete in HSQLDB and SQuirreL

I am trying to create an sql statement to delete records that match a certain condition by 1000, everything i try however doesn't work. For example i have tried DECLARE @count int SET @count = 1000 DELETE FROM HISTORY WHERE HISTORYID IN ( …
codeCompiler77
  • 508
  • 7
  • 22
1
vote
0 answers

Get row id in SQuirreL

I want to get back the row id on the left hand side along with the rest of the columns is that possible? SELECT * from WSJ0CPP WHERE J0YOCD = '08' AND J0ACCD = '01'; I am using SQuirreL.
IMTHEKINGOFHEARTS
  • 21
  • 5
1
vote
1 answer

View Triggers in Squirrel SQL client

I am using Squirrel SQL Client 3.7.1 version. I am unable to see the triggers available in the database. How do i see the trigger's in Squirrel SQL client tool. I only see the tables. Could someone help me on this. Do i have to install any plug-ins…
CurlyCream
  • 63
  • 2
  • 8
1
vote
0 answers

SQuirreL Simplicit vjdbc VirtualDriver java.sql.SQLException: java.lang.NullPointerException

Using SQuirreL to connect/consult a distributed MariaDB, I get a java.sql.SQLException: java.lang.NullPointerException after every query execution. It arises even on SHOW tables FROM catalog_name; or the SHOW columns FROM table_name; kind of query.…
manuelvigarcia
  • 1,696
  • 1
  • 22
  • 32
1
vote
2 answers

Import from Excel to MySQL database using SQuirrel

I have an Excel spreadsheet with a few thousand entries in it. I want to import the table into a MySQL 4 database (that's what I'm given). I am using SQuirrel for GUI access to the database, which is being hosted remotely. Is there a way to load…
Elie
  • 13,693
  • 23
  • 74
  • 128
1
vote
1 answer

Squirrel Client DB2 Stored Procedure Session Delimiter

I am facing a tricky problem while I am trying to run stored procedure via Squirrel against DB2 database. In the stored procedure have part where combine an sql statement like this: SET V_SQL = 'SELECT DISTINCT ' || PARAM_COLUMNNAME || ' FROM…
Pirx
  • 45
  • 2
1
vote
0 answers

HDP (2.3): Squirrel (3.7): Phoenix (4.4.0.2.3.0.0-2557): Hbase connection time out

We have HDP installed on AWS EC2 Cluster (2 Name Nodes, 3 Data Nodes, and 1 Management Server). In order to use phoenix (4.4.0.2.3.0.0-2557) with Hbase, we have followed basic steps mentioned in Hortonworks documentation. (Hortonworks-Phoenix…
Hrushi
  • 153
  • 3
  • 13
1
vote
0 answers

Db2 Connection in Squirrel or Dbeaver

iam trying to connect with Db2 using Squirrel/ Dbeaver and my url contains securityMechanism=13 at the end. I am getting an excpetion .. com.ibm.db2.jcc.b.SqlException: SqlException: java.security.InvalidAlgorithmParameterException is caught when…
NiranjanK
  • 427
  • 2
  • 6
  • 23
1
vote
1 answer

Solr import command not working

I need your help to solve a big problem. I have to index with solr some datas from an EMC xDB source. I configured xDB to be requested like an RDBMS. Then i configured Squirrel to request xDB. It works and when for exemple i try: Select * from…
Erwan C.
  • 709
  • 5
  • 18
1 2 3
…
19 20