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

compile procedure in oracle 11g

I create a simple procedure in oracle 11g with the client squirrel, this s the code create or replace procedure EXAMPLE_P is begin 1+2; end;/ while executing i got this warning Warning: Warning: execution completed with warning SQLState: …
R Vive L OL
  • 177
  • 3
  • 3
  • 10
2
votes
0 answers

Meaning of Column properties in SQuirreL SQL

I am using SQuilrreL SQL to connect to a local MySQL server, and am looking at the specification of the Columns of some table. At the same time I'm looking at the specification of the same table directly in MySQL (MySQL Workbench), and obviously,…
OferBr
  • 297
  • 2
  • 13
1
vote
1 answer

SQLite database with Squirrel: No relations

What I have: I have an SQLite database with connections. Here is a little part of the sql create code (A many-to-many connection between destinations and log_entries table): DROP TABLE IF EXISTS "destinations"; CREATE TABLE "destinations"…
ald mike
  • 95
  • 1
  • 9
1
vote
3 answers

How to translate CCSID 65535 in SQuirrel from a DB2 on an iseries

I am new to SQuirrel SQL. I need some help to translating CCSID 65535 into ASCII, UNICODE (or anything human readable) I am using the JDBC driver per the following guide. According to IBM's website: What character conversion issues must my program…
Christoff Erasmus
  • 925
  • 1
  • 10
  • 26
1
vote
1 answer

ODBC: Data source name not found and no default driver specified

I'm trying to make a connection to a sql server on a local lan but I keep getting the following error, sqlTest: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified java.sql.SQLException: [Microsoft][ODBC…
stack356
  • 170
  • 1
  • 16
1
vote
0 answers

PhoenixNonRetryableRuntimeException: Could not load/instantiate class org.apache.phoenix.query.DefaultGuidePostsCacheFactory (from database clients))

I am trying to use various database clients (Squirrel 4.1.0, DBVisualizer Free 12.1.1) to connect to an HBase database, but I get an error: PhoenixNonRetryableRuntimeException: Could not load/instantiate…
kc2001
  • 5,008
  • 4
  • 51
  • 92
1
vote
0 answers

How to map data from different records of a table to an single record in SQL?

I am new at SQL. The following is the type of data I am working with: Sample input: Description Timestamp ----------- --------- The *machine1- is being analysed …
Arthur
  • 21
  • 2
1
vote
1 answer

Squirrel SQL Editor does not return multiple results from a stored procedure with 3 select statements

I have a stored procedure which is run in Squirrel SQL editor for Sybase. The stored procedure has 3 select statements, but when executed , it returns only Ithe result of first select statement. What I have tried: Executed the stored procedure using…
chargedfever
  • 43
  • 6
1
vote
1 answer

SQuirreL (SQL) fails to load with IllegalStateException

SQuirreL (SQL) will fail to load with the following stack trace. ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event…
Nicolaas Winter
  • 76
  • 4
1
vote
0 answers

How to open a database with SQuirrel SQL Client? (Database not found)

I've recently been fiddling around with databases and finally. So, naturally, I turned to SQuirrel to open and view my work, but it seems I can't get the formatting for the alias right. Currently what I have been trying is:…
MilitantMissourian1776
  • 25
  • 6
1
vote
1 answer

Golang Postgres pq failed scanning to *string

I'm trying to scan a postgresql list into an empty slice of string. However, I'm getting the error below: Failed creating education: sql: Scan error on column index 14, name "descriptions": unsupported Scan, storing driver.Value type string into…
thousight
  • 1,134
  • 1
  • 14
  • 39
1
vote
0 answers

SQL query issue on thrift server client

I have performed join on 2 tables memberstable (service_id,created_date) and member_servicestable (id and user_id) the join was made on registered id and id since they are the same. I want to get the total number of user ids for service id using a…
Srinidhi Nagabhushan
  • 11
  • 1
1
vote
1 answer

Apache drill GUI SQuirrel on Windows Class not found

I am trying to use Apache drill GUI on windows 10, I have followed all the instructions on their link https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/ , adding the driver shows the message Driver class org.apache.drill.jdbc.Driver…
shzyincu
  • 409
  • 4
  • 21
1
vote
1 answer

Grant Resource to user to create table

I am trying to give privileges to a db user, and want to allow the user to create tables. Checking on "RESOURCE" privilege, it contains the following: SELECT privilege FROM dba_sys_privs WHERE grantee = 'RESOURCE'; Resource CREATE TABLE CREATE…
user10518
  • 117
  • 2
  • 11
1
vote
1 answer

Primay key in Phoenix returns Null when decleared as bigint

I am using Phoenix to run SQL on my HBase, but when I try bigint for primary key it returns NULL for that columns in select but varchar return correct result
Gaurav Swaroop
  • 31
  • 4
1 2 3
…
19 20