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 SQL mac lag when typing codes

My screen lags very badly when I type my sql codes in the Squirrel interface. When I scroll up or down the page the interface also lags in and out. It becomes very hard to type code if it is more than 10 lines. I have tried reinstalling Squirrel and…
Cicero
  • 11
  • 1
1
vote
1 answer

PostgreSQL: skip erros in SQL clients using JDBC

I want to execute a SQL script in a client using JDBC (not the postgreSQL pslq client). In this script I would like to do something like that: skip errors on; alter table foo ...; skip errors off; Is there a way to do this with PostgreSQL >= 9.1?
maroonyw
  • 71
  • 5
1
vote
1 answer

Can't connect to database after restoring database from backup

I restored my local developing database with a backup file made from production database with SQL Server Management Studio. I overwrited my local database on that restore. Now I can't connect to the database with SQL Squirrel. What could have caused…
Steve Waters
  • 3,348
  • 9
  • 54
  • 94
1
vote
1 answer

Connect to Informix database using Visual Studio 2013

I want to connect to informix database from Visual Studio 2013. I've checked the IBM site and it contains whole lot of drivers and plugins. I've installed Client SDK and then I installed IBM server driver package then I installed Visual Studio…
Bharath
  • 195
  • 1
  • 1
  • 19
1
vote
1 answer

Squirrel SQL Disconnects when Incorrect SQL executed

Squirrel 3.6 connected to Oracle 11g using an Oracle thin driver (ojdbc6.jar). Whenever I type an SQL query incorrectly, instead of saying 'Wrong SQL' (or something to that effect), I get an Oralce Error (Error: IO Error Size Data Mismatch) and…
italian_homes
  • 101
  • 1
  • 11
1
vote
0 answers

Not able to insert an XML in a table

I have an XML that has to be inserted in production DB. A row got accidentally deleted due to which a batch job has failed to run. So, I need to insert an XML. I have this XML in test region schema. I tried to convert XML from varchar2 to clob, but…
Chinmay
  • 11
  • 3
1
vote
1 answer

Creting view for hbase table using SQuirrel SQL client 3.6

I have created hbase table using SQuirrel SQL client 3.6. Below is query I tried- create table test (mykey integer not null primary key, mycolumn varchar); upsert into test values (1,'Hello'); upsert into test values (2,'World!'); Now I am trying…
S Singh
  • 1,403
  • 9
  • 31
  • 47
1
vote
1 answer

Remote connect to DerbyDB

I'm running a Derby DB on an Ubuntu Server. When I'm using ij i on the Server i can perfectly connect using localhost. connect 'jdbc:derby://localhost:1527/MyDB'; But now i want to connect from my DesktopPc. So i use the…
user2167495
  • 25
  • 1
  • 7
1
vote
0 answers

SQuirreL SQL Connecting to VJDBC database

I'm trying to use SQuirreL SQL to connect to a VJDBC database. Is there any way to change the login properties of Squirrel? Let me explain in Java: With the VJDBC driver, you login with these property…
wells
  • 11
  • 1
1
vote
2 answers

db2 stored procedure format

I'm using db2 and SQuirreL SQL I'm trying to create a stored procedure with a simple select statement inside of it. When I omit the select statement in the following below and run the code, the procedure is created. Also this procedure can be…
developer234
  • 79
  • 3
  • 14
1
vote
1 answer

Postgres combines two fields into one with UnknownType values

I'm using the squirrel sql client to work with Postgres and the problem is that the same query returns different results. If a query below execute as is, it works fine: select foo.column1 as Field1, 1 as Field2 from (values (3343),(45323)) as…
drewango
  • 25
  • 6
1
vote
1 answer

Unable to find Derby database, how to connect in Java

I have a MySQL database with some tables and records in them. I have written a Java application which, during development, used the MySQL database. Now since development is finished, I wish to make an executable JAR of my program together with a…
RazorAlliance192
  • 722
  • 9
  • 23
1
vote
1 answer

concat() shown as varbinary in hex format in squirrel sql instead of plain text

How to prevent Squirrel SQL to show concat() of int data types as varbinary in hex format instead of plain text? For example, SELECT CONCAT(1,2) shows the hex notation 3132 instead of "12" ... Looking at the MetaData result tab shows that the…
Phil
  • 341
  • 4
  • 5
1
vote
2 answers

SQL. Finding the average between certain dates

I'm trying to find the average score received by films between a certain time SELECT SUM (score * ?) / SUM(?) AS AGGSCO FROM movie, casting INNER JOIN casting WHERE movie.id = casting.movieid AND yr BETWEEN 1930 AND 1939; Instead…
user3456235
  • 11
  • 1
1
vote
1 answer

How do you add a Squirrel SQL alias for an Oracle 10g database?

I am trying to create an Add Alias within Squirrel DB for Oracle. Does anyone have a sample of how to make this Alias work? I just need some pointers.
prafix
  • 25
  • 1
  • 6
1 2 3
…
19 20