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

Are SQL concatenations possible using the JDBC to ODBC bridge?

When I run a query using concatenation of fields in MS Access I can write the following and it works fine: SELECT e.FirstName + " " + e.LastName + " " + e.MiddleName AS Attendant FROM (EMPLOYEES e INNER JOIN PAY pay ON e.SocialSecurityNumber =…
leeand00
  • 25,510
  • 39
  • 140
  • 297
1
vote
2 answers

how do I update hibernate_sequence in Grails using oracle 11g database?

I imported some data into my schema and I have one sequence for all my tables. In my old app, the sequence was around 1000, but this new sequence is starting at 4, and thus I am getting conflicts when trying to enter a new row. Is there a way to…
Universitas
  • 493
  • 2
  • 5
  • 21
1
vote
1 answer

SQL Client with inner join exploration

I have a database which I sometime like to manually explore, in order to get info. I currently use squirrel sql client, which is quite good, but there's a feature I miss badly : when I issue a simple select to a table, let's say there's a line I…
Mikarnage
  • 893
  • 1
  • 9
  • 24
1
vote
6 answers

Inserting multiple rows into a table using a single INSERT statement

I have no idea why I cannot insert values into my table using this syntax. I can insert one row but I cannot insert multiple rows. CREATE TABLE T1 ( ID BIGINT NULL, CAT VARCHAR(255) NULL, M_ID BIGINT NULL, …
user1408672
1
vote
0 answers

Store Procedures in SQuirrel 3.2.1 when using it with a JDBC driver for a DB2 database

I expend a lot of time trying to retrieve data from a Stored Procedure, here is the code CREATE PROCEDURE aprocedure( IN idin CHAR, OUT returnvalue CHAR) AS: SET returnvalue= …
JCarlos
  • 51
  • 1
  • 8
0
votes
3 answers

Issues Creating SQL Server triggers using SQuirreL SQL Client

Recently I have been working with a SQL Server database and I was trying to create some triggers for some tables using SQuirreL SQL Client and for some reason I was unable to get rid of the following pesky error message: "Error: 'CREATE TRIGGER'…
BordrGuy108
  • 357
  • 2
  • 6
  • 13
0
votes
1 answer

Query to get all the column names and their type in Squirrel

I am using Squirrel SQL Client to access derby, sql server servers. I can access all the tables and their data from there. Could you please tell me a query to list all the column names, types with no data in Squirrel?
user1070440
  • 1
  • 1
  • 1
0
votes
3 answers

Access a firebird embedded database using squirrel

I am using an application that apparently uses Firebird as database. I believe this because in the app directory, I found the files firebird.conf and firebird.msg. The data file is called database.cdb. I'm trying to access this file directly,…
Bob Rivers
  • 5,261
  • 6
  • 47
  • 59
0
votes
1 answer

Can squirrel remember the column layouts of the Content tab?

I've started using squirrel and generally like it. But one thing that bugs me is that it doesn't seem to remember when I've rearranged how a table looks in the Content tab. If I'm looking at a table or view and reorder and resize the columns in a…
Cincinnati Joe
  • 2,077
  • 6
  • 23
  • 32
0
votes
0 answers

SquirrelSQL custom driver cannot find file

I have written a custom JDBC driver. It relies on configuration files. It works well when deployed as a typical Java application, with the configuration files copied to the class path. I would like to use it with SquirrelSQL. And I cannot use this…
Gilles
  • 357
  • 3
  • 20
0
votes
0 answers

How to close SQuirreL connection without closing session?

I establish a connection to an h2 database via SQuirrel SQL Client (version 4.5.1). The driver used is "H2 embedded". In the menu I found an item called "Reconnect". Is it possible to disconnect and reconnect (using the menu item mentioned) after…
sandromo
  • 1
  • 2
0
votes
0 answers

Squirrel sql date format issue

I would like to change the date time format that is being displayed in squirrel SQL client from yyyy-mm-yyyy hh:mm:ss.mi to dd-mm-yyyy hh:mm:ss. Could not find these in global settings Version I am using is : 4.5.0 Thanks
Harish Prasad
  • 17
  • 5
0
votes
2 answers

Squirrel SQL - user input prompt

I am a first time user of Squirrel SQL client for Oracle DB. When I am executing the below queries it is not popping up with a user input dialog box, instead just displaying empty rows Query Select * from employees e Where e.id in ('&emp_id'); The…
Harish Prasad
  • 17
  • 5
0
votes
0 answers

How to establish connection from AWS database to Squirrel

I have created a db in AWS in my root account but when i wanted to connect it from my local Squirrel i am getting below shown error. Steps i follwed were create aws Databse(Mysql) downloaded jdbc mysql driver and added to squirrel created an Alias…
Sai Kiran
  • 1
  • 1
0
votes
0 answers

Getting error UCANACCESS_HOME system variable doesn't point to the correct ucanaccess home, when attempting to use Squirrel IDE with an MS Access db

I found steps outlined most kindly by a stackover flow user - Gord Thompson How to configure Squirrel SQL client to work with MS Access to use the SQUIRREL IDE for an MS Access database using the UCanAccess driver but I am getting the…
Daniel Oranye
  • 11
  • 2
1 2 3
…
19 20