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

create a mysql stored procedure in squirrel sql

I'm using squirrel sql 3.1 to create a store procedure on a mysql db. The sp works fine when I create it with other clients, but when i try with squirrel sql it gives me a bunch of errors. I tried to change the statement separator on the session…
luarwo
  • 253
  • 3
  • 8
0
votes
1 answer

PostgreSQL to Oracle migration through drag and drop in SQuirreL

I need to convert the structure of PostgreSQL databases to Oracle. I use SQuirreL SQL Client 3.3.0 with MDI interface and I opened two sessions: one for PostgreSQL, another for Oracle. MDI interface allows to move objects between schemas (drag and…
user1134181
0
votes
1 answer

Java exception when trying to run query in SQuirreL

I've installed SQuirreL 3.5.3 and I'm using Java 1.7.0_67 (JRE). This is at the end of my PATH environment variable: "C:\Program Files (x86)\Java\jre7\bin". I've set up drivers and an alias and am able to connect to my database. My problem is that…
LASmaug
  • 11
  • 4
0
votes
3 answers

DB2 Show the latest row record from users, using the date and time

I have 100 records from 3 users. I want to show the most recent record from each user. I have the following query: SELECT * FROM Mytable WHERE Dateabc = CURRENT DATE AND timeabc = ( SELECT MAX(timeabc) FROM Mytable ) It returns the…
lospreguntones
  • 19
  • 1
  • 4
0
votes
3 answers

Does Squirrel SQL or Oracle have a way to alias table names in queries?

I'm using Squirrel SQL with Oracle. I often have to write quick queries for tables with longish names. It would be nice if I could give aliases to them and write queries like "select * from ft where n='blah'" instead of "select * from…
HappyEngineer
  • 4,017
  • 9
  • 46
  • 60
0
votes
1 answer

Can't see any data in h2 database

I got some unit test that stores some Person data into the database. To do this i use the EntityManagerFactory. @Test public void findPersonById() { personDao.savePerson(new Person("Hans")); Person person = new Person("Peter"); …
Chris311
  • 3,794
  • 9
  • 46
  • 80
0
votes
1 answer

Calling a MySQL Stored Procedure in SQuirreL

What is the correct syntax to call a MySQL stored procedure in SQuirreL? Here's an example sproc? foo(IN VARCHAR s, OUT VARCHAR a, OUT VARCHAR b, OUT VARCHAR c),
KC Baltz
  • 1,498
  • 1
  • 13
  • 22
0
votes
1 answer

mysql connection refused for squirrel

I have a linux server that I access with putty. I access my mysql database of that server with the program SQuirrel SQL client. And everything works. Now I buyed a new windows computer and I wanted to install all the same applications to access my…
Bigjo
  • 613
  • 2
  • 10
  • 32
0
votes
2 answers

Is SQuirreL SQL Client compatible with QODBC?

Does anyone know if the SQuirreL SQL Client is compatible with QODBC? If not is there a plugin for SQuirreL to enable so? Any insight would be appreciated as I have never used either.
James
  • 70
  • 1
  • 9
0
votes
1 answer

My computer cannot connect through JDBC to SQL Server 2012 (times out) while others can

So basically, I'm having trouble connecting to SQL Server 2012 through JDBC through my tomcat web application and also SQuirreL I've tried substituting multiple versions of sqljdbc jar files. The weird thing is, my co-worker is able to successfully…
patlv23
  • 113
  • 2
  • 11
0
votes
1 answer

Why ‘procedure’ is invalid word (i.e. red word) in SquirreL SQL pane?

I am using DB2 net driver for my db. I can’t even execute DROP PROCEDURE TESTING_PROC; and the error is: Error: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: ESUB_TEST.TESTING_PROC I want to know why PROCEDURE is invalid word I…
dannail
  • 455
  • 2
  • 10
  • 27
0
votes
1 answer

How can I convert a float to 4 raw bytes in Squirrel?

I need to convert a 32 bit floating point number to 4 bytes for an embedded system using the Squirrel language. I was hoping I could just bit shift and mask the bytes into separate parts, doing something like: bytes = [ (myfloat >> 24) & 0xff, …
davidscolgan
  • 7,508
  • 9
  • 59
  • 78
0
votes
4 answers

Simply select char, or string

What is the way to achieve expected result from psql select: SELECT 'Hello world'; using this in SQuirreL I get value: in unnamed column. What is the way to get string Hello world as a result? I want to use this approach to format outputs using…
Václav
  • 365
  • 2
  • 15
0
votes
1 answer

How to access specific H2 database

I have 2 H2 databases under 2 different locations D:\test\activitiDB\activiti.h2.db and D:\myapps\jbpmDB\jbpmdb1.h2.db In Hsql, I can specify an alias name to the databases in Hsql properties files and simply use the alias name in the JDBC URL like…
Ayusman
  • 8,509
  • 21
  • 79
  • 132
0
votes
1 answer

Bizarre MySQL Workbench error on Linux desktop

I have an account with a Java PaaS (CloudBees) that hosts their platform off of Amazon EC2 instances. My account comes with access to a MySQL server instance and I am getting a bizarre error that only occurs when I try to log into the MySQL server…
IAmYourFaja
  • 55,468
  • 181
  • 466
  • 756
1 2 3
…
19 20