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

Error while connecting to oracleXE11.2 from Squirrel

I'm getting this error when I connect to oracleXe 11.2 from squirrel java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Io exception: Connection …
user2328677
  • 3
  • 2
0
votes
1 answer

Querying Netezza via SquirrelSQL returns WKT geometry in unknown encoding

I am using SquirrelSQL to write and execute SQL queries on a Netezza database. Using Netezza's spatial capabilities (which are essentially the same as those of PostGIS) I've executed a query and returned a single result that contains a geometry.…
Jack Harrison
  • 156
  • 8
0
votes
1 answer

SQuirrel SQL client with hibernate 4.1.7

has anybody tried running HQL queries using SQuirrel in combination with hibernate hibernate 4.1.7. Software versions: SQuirrel 3.4.0 Oracle Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production Hibernate 4.1.7-final The problem's…
anche
  • 66
  • 2
  • 8
0
votes
1 answer

In a Derby database, how are "username" and "table owner" related, and what is a simple way to set them?

I am using Derby to study Hibernate; I used to have it as an embedded database, but my ant jobs for filling it with data have trouble with that, so I'm switching to the network version. Besides my Java/Hibernate program, I access the database with a…
arcy
  • 12,845
  • 12
  • 58
  • 103
0
votes
1 answer

connecting to mysql and gae RDBMS with one application

I have installed MySQL locally and I am trying to use it as a development server and then upload history and master data to the RDBMS on GAE. I can connect to the local MySQL with ... c:>mysql -u root -p ...and I connect to the RDBMS with …
dan_ras
  • 109
  • 10
0
votes
1 answer

Syntax error or access violation in MS-Access stored proc?

I'm attempting to create a very simple stored procedure with one parameter in MS-Access 2003. CREATE PROC procTest(lname VARCHAR(50)) AS SELECT * FROM T_Employees t WHERE t.LastName = lname; I get the error: Error: [Microsoft][ODBC Microsoft…
leeand00
  • 25,510
  • 39
  • 140
  • 297
0
votes
1 answer

[Microsoft][ODBC Visual FoxPro Driver]Cannot open file C:\users\aleer\locals\locals~1\temp\6uu0004.tmp?

Okay I checked this out and C:\users\aleer\locals\locals~1\temp\6uu0004.tmp is actually point to C:\Users\aleer\Local Settings\temp where the 6uu0004.tmp file does not even exist. I guess it's possible that this file is being created and then it…
leeand00
  • 25,510
  • 39
  • 140
  • 297
0
votes
1 answer

What is wrong with my Sybase CREATE TABLE syntax?

What's wrong with my syntax here? I'm adhering strictly to the rules in the Sybase Reference CREATE TABLE dashlogactions ( action_id SMALLINT NOT NULL DEFAULT IDENTITY PRIMARY KEY, action_name VARCHAR(64) NOT NULL UNIQUE ) SQuirrel SQL…
Jeremy Goodell
  • 18,225
  • 5
  • 35
  • 52
0
votes
1 answer

Creating External Table takes long time

I have a table called table B that as 28 million records that is in Netezza and I want to export it to a text file so that I can export the text file to the mysql server. When I run the command below, the SQL client hangs. I am using SquirrelSQL.…
cool_cs
  • 1,661
  • 6
  • 20
  • 26
0
votes
1 answer

Syntax for importing table

What is the syntax for importing an external table into a created table? Whenever I right click on a table in squirrelsql, and click import file, I always get the error message "A database error has occurred. I suspect that Netzilla does not support…
user1408672
-1
votes
2 answers

Connect SQL client to an MS Access database (instead of using MS Access SQL text editor)

Is there a way to connect an SQL client to query an MS Access database? For example, with a Java-based SQL client like SQuirreL SQL, use a JDBC connection to query tables in an .accdb file. Use case: Complex SQL queries with multiple subqueries…
User1974
  • 276
  • 1
  • 17
  • 63
-1
votes
1 answer

MacOS: SquirrelSQL will not run from launchpad

I installed jenv, OpenJDK, and SquirrelSQL on MacOS 13. I am able to run SquirrelSQL from the terminal, but it would not run from launchpad: the icon gets displayed in the dock, bounces once, and then nothing. What am I missing?
Alex O
  • 1,429
  • 2
  • 13
  • 20
-1
votes
2 answers

Informix - Cant find syntax error

This may be a stupid mistake but I'm new to Informix and I can't seem to figure out why none of my CREATE TABLE statements won't run. I keep getting a syntax error on all of my CREATE TABLE statements. CREATE TABLE customer( store_num INTEGER NOT…
ScottyDooZA
  • 45
  • 7
-1
votes
1 answer

MariaDB SQL Syntax error from SquirelL SQL Client

I am using SQuirelL client to connect to MariaDB. My OS is Ubuntu. I have downloaded the Mariadb driver (mariadb-java-client-1.5.2.jar) to the proper location and linked it in the SQuirelL client. I have setup a database, and am able to create…
A. Jose
  • 1
  • 1
-1
votes
1 answer

Squirrel sql client 3.7 on Mac OSX 10.11 and Ubuntu 15.10 has no drivers installed

Here is my problem. I am installing Squirrel SQL Client 3.7 on a Mac and an Ubuntu computers. After executing java -jar squirrel-sql-3.7-MACOSX-install.jar All drivers are marked with and "x" on a red circle. Even when I am specifically requesting…
L.D
  • 1,279
  • 3
  • 15
  • 31
1 2 3
…
19
20