squirrel-sql Questions

3

Solved

I have now tried 2 days to connect to external DB2 database with SQuirreL. I always get error: [jcc][t4][2030][11211][3.58.82] A communication error occurred during operations on the connection's ...
Thermocouple asked 4/6, 2012 at 8:7

4

Solved

I am Launching SQuirrel SQL on Mac OS X(El Capitan) that has JDK1.8 on it produces an error message saying the JDK-version should be at least 1.6. It then quits. SQL client version is 3.7. How do I...
Harbird asked 22/9, 2017 at 17:54

5

Solved

I use Squirrel SQL to connect to a JavaDB/Derby database on my desktop. I can run SQL queries. But how can I list all tables in the database? And preferably all column and column types.

9

I really like SQuirreL SQL as a SQL query tool, but I've never been able to get it to call stored procedures in our AS/400 DB2 database. I always get the error "The number of parameter values set o...
Woundwort asked 16/2, 2011 at 18:25

3

Solved

I installed the squirrel client 3.4.0 on my windows 7 64 bit machine. I see a squirrel client settings folder ".squirrel-sql" created in: C:\Users\ayusman\ Is there any way I can specif...
Cointreau asked 27/8, 2012 at 19:20

7

Solved

The size of the font to enter the SQL is too small. What is the way to increase the size of the font to type the SQL ? In 'global options' there is a possibility to increase the size of the fonts. ...
Stalkinghorse asked 24/8, 2015 at 7:14

1

I have installed SQuirreL client to open my file database. I have file named "database.h2.db" and I want to read its content. Well, that's first time I work with database like that. All I need to d...
Flatfish asked 14/1, 2017 at 13:57

4

Solved

I was using a SQuirrel SQL Client to connect & browse my oracle database servers. I have given the credentials in the connection URL itself. But it still prompts for the username and password. ...
Scoundrelly asked 5/4, 2011 at 4:32

10

Solved

I'm trying to run SQuirreL SQL. I've downloaded it and installed it, but when I try to run it I get this error message: Java Virtual Machine Launcher. Could not find the main class. Program w...
Ectogenous asked 23/9, 2008 at 12:28

6

Solved

I need to connect to a SQL 2008 R2 Server from my Linux box that's not registered in my company's domain. I'm trying to use SQuirreL SQL version 3.2.1. I downloaded Microsoft SQL Server JDBC Driver...
Ivetteivetts asked 8/2, 2012 at 14:6

5

Solved

It is not related to whatever version it is, just working to find out how to change (of course increase) session timeout value of Squirrel Sql Client. Because I really get bored of getting kind of ...
Capital asked 7/3, 2011 at 12:43

2

In a tool like SQL Developer, I can right click on a row and select duplicate to get a copy of row, edit it, and commit it. How can I do this in Squirrel? I don't even see how to add a new row in t...
Extraneous asked 10/10, 2011 at 12:40

2

Solved

I downloaded SQuirreL SQL and I want to use it as an Oracle client, but when I go to Drivers tab, the following jars are missing: Oracle OCI Driver Oracle Thin Driver How can I fix this probl...
Hint asked 1/8, 2016 at 7:58

5

Solved

I'm running SQuirreL SQL (2.6.8) on Max OS X. I'm running out of heap space when trying to create a Table script. How to configure SQuirreL SQL to start up with a higher JVM heap size?
Cryptoanalysis asked 30/3, 2009 at 13:21

5

I was able to create a stored procedure for an Oracle database, but now I can't figure out how to run it. I'm using SQuirrel SQL and this worked to create the procedure: CREATE OR REPLACE PROCEDUR...
Digenesis asked 29/3, 2011 at 17:10

1

Solved

I have the following function definition for a PostgreSQL 9.3.4 database: CREATE OR REPLACE FUNCTION update_modified_timestamp() RETURNS TRIGGER AS $$ BEGIN NEW.modified_at = now(); RETURN NEW...
Womack asked 13/5, 2015 at 9:40

1

Solved

How to configure SQuirreL for DB2 access. In SQuirreL I do see two DB2 drivers. But they are both marked with an red X. I checked with Start Page but did not find an easy solution :/
Solvency asked 10/2, 2017 at 15:57

4

Solved

I searched but could not quite find this information anywhere else. Could you list the best shortcut keys Squirrel? I know it is possible to avoid a lot of typing with this feature of the tool. T...
Serge asked 13/1, 2014 at 17:25

1

Solved

I'd like to use squirrel-sqls keep-alive feature since my Oracle database connections get cut if they idle for too long. It's a self-explanatory feature - or so one would expect - and also covered ...
Gaptoothed asked 21/10, 2016 at 14:54

1

I just have a Postgres database(PostgreSQL 9.4.5) and Squirrel windows client (SQuirreL SQL Client Version 3.7). In database there is a table which has column type jsonb Column | Type --------+-...
Megohm asked 22/2, 2016 at 15:34

1

Solved

I encounter the following error when trying to connect to a database using SQuirreLSQL. Error : Unexpected Error occured attempting to open an SQL connection Stacktrace : java.util.concurren...
Aho asked 21/7, 2014 at 5:11

2

I'm struggling to get Squirrel SQL to connect to MS Access database (just a normal one, no password): I create an Alias and use Driver: JBDC ODBC bridge (There is a tick in front of this driver) ...
Henden asked 9/12, 2014 at 23:12

2

Solved

I tried add an column alias in SELECT statement using SQuirrel SQL 3.4 + Firebird 1.5 + Driver JDBC Jaybird 2.2.[0|1] (JVM 1.7.0_03), but doesn't work. The column aliased appears with the original ...
Alkanet asked 3/10, 2012 at 13:43

1

Solved

I use version 3.4.0 of SQuirreL SQL client, and whenever I execute a request that returns numbers (IDs for example), the result numbers are formatted with commas, i.e. 123,456,789 instead of plain ...
Selfhood asked 8/10, 2015 at 9:43

2

Solved

I use the ancient System i Navigator (french) to get to query a DB2 (AS/400) database. I liked to update the client and use a more fresh (and English) sql client for that database. So, I installe...
Awestricken asked 17/12, 2013 at 12:59

© 2022 - 2024 — McMap. All rights reserved.