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

Squirrel client not opening

I have been using Squirrel SQL client to access Vertica (on a Windows 7 machine). It was working fine until last week but I am unable to open the Squirrel anymore and it throws an error "error occurred initializing plugin: oracle". I haven't…
Ravi
  • 3,223
  • 7
  • 37
  • 49
1
vote
1 answer

H2: Read Comment on Column?

Just started using the H2 database. Have found the COMMENT command but as I have already set the comment through LibreOffice, is there any way to return it? This is a sense check as I can set and see column comments in H2 via Squirrel, but…
Paul Eden
  • 338
  • 1
  • 3
  • 10
1
vote
2 answers

can't see tables in SQuirrel

I am using a HSQL driver to connect to my database. I am able to connect without any errors but I can't see any of my tables in the table tree under public. I am able to create new tables which do appear, but I can't see the already created ones. …
user3178147
  • 31
  • 1
  • 5
1
vote
1 answer

Transforming a 2 column SQL table into 3 columns, column 3 lagged on 2

Here's my problem: I want to write a query (that goes into a larger query) that takes a table like this; ID | DATE A | 1 A | 2 A | 3 B | 1 B | 2 and so on, and transforms it into; ID | DATE1 | DATE2 A | 1 | 2 A | 2 |…
yjtan
  • 193
  • 1
  • 1
  • 6
1
vote
1 answer

List Oracle LDAP connection endpoints for use in SQuirreL

Toad/Oracle has a mechanism where it can use LDAP to lookup a list of database endpoints. It uses a file called ldap.ora which looks like: DIRECTORY_SERVERS= (server1.foo.bar.baz:1628:1629, server2.foo.bar.baz:1628:1629) DEFAULT_ADMIN_CONTEXT =…
lance-java
  • 25,497
  • 4
  • 59
  • 101
1
vote
0 answers

SquirrelSQL access more databases in one SQL script

It's probably a trivial question but I wasn't able to find any solution. The following script: use Database1 go ... use Database2 go ... works in SQL Server Management Studio but not in SquirrelSQL 3.5.0 (jTDS Microsoft SQL driver) - use: invalid…
user681768917
  • 193
  • 1
  • 12
1
vote
1 answer

Connecting to SQL Server with SQuirrel SQL

I am in the process of learning more about database manipulation. I downloaded SQuirrel since it seemed like a good place to start. I know quite a bit about SQL and databases already due to an internship I had last summer but know absolutely…
kuersch
  • 81
  • 1
  • 6
1
vote
0 answers

Squirrel SQL Client UI remains hidden

Since I keep getting the log message to add -Dsun.java2d.noddraw=true to the JAVA_OPTS for the squirrel bat file, I finally added the argument and started Squirrel. Now the Squirrel-SQL client shows a weird behavior. The SQL Client starts without…
Ayusman
  • 8,509
  • 21
  • 79
  • 132
1
vote
1 answer

squirrel-sql : no sequence options

I've installed Squirrle and connect to DB2. Yet in my install I don't get the tree node for "sequences". I get... ALIAS HIERARCHY TABLE INOPERATIVE VIEW MATERIALIZED QUERY NICKNAME SYSTEM TABLE TYPED TABLE TYPED VIEW VIEW PROCEDURE UDT I'm missing…
jeff porter
  • 6,560
  • 13
  • 65
  • 123
1
vote
4 answers

How to get source SQL queries for the views in squirrel client 3.4.0?

Basically I want to modify the existing view in DB2 database. We are using quirrel client 3.4.0 to access the Database. How to get source SQL queries for the views in squirrel client 3.4.0?
Zia
  • 11
  • 1
  • 1
  • 3
1
vote
1 answer

Squirrel, sqrat, error when binding class

I am trying to compile a program that binds a class so that I can use it with a squirrel script. I am using VS2010 under Windows 7 and have compiled the squirrel libraries and sqrat using the unicode character set with debug configuration. The error…
Alex
  • 458
  • 5
  • 17
1
vote
1 answer

Is it possible to export results from Google Cloud SQL using SQuirreL SQL

I'm looking for the most efficient way to get results out of a Google Cloud SQL instance. I know from the FAQ that the INTO OUTFILE command isn't supported, and the only official way of getting data out of Cloud SQL is by exporting your entire…
Nelluk
  • 1,171
  • 2
  • 12
  • 23
1
vote
2 answers

Making simple database in Squirrel SQL

I am trying to make a simple java application that connects to database in Squirrel SQL which I use JDBC connector to connect to but I can't seem to pass making the database in Squirrel. I have my jdbc jar file in place as there is a blue tick…
Raymond Nakampe
  • 371
  • 7
  • 22
1
vote
2 answers

What is the MySQL SQL REGEX for this regex

Regular regex: foo(\((\d{1}|\d{2}|\d{3})\))? This regex works in Java: foo(\\((\\d{1}|\\d{2}|\\d{3})\\))? Examples: fooa //no match foo(1)a //no match foo(a) //no match foo(1) //match foo(999) //match foo //match MySQL 5.5…
Harrison F
  • 492
  • 5
  • 15
1
vote
0 answers

Hive metadata not visible in Squirrel SQL

We have installed Squirrel SQL and are able to connect to the hive db, but we are not able to view any tables and not able to execute any query. What's wrong?
sjayendra
  • 91
  • 3
  • 9
1 2 3
…
19 20