Stack Overflow
Stack Overflow

Questions tagged [sql-workbench-j]

SQL Workbench/J is a multi DBMS cross-platform SQL client written in Java. It should not be confused with MySQL Workbench.

SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and should run on any operating system that provides a Java Runtime Environment.

Home page

SQL Workbench/J has no relation to MySQL Workbench. Use for that.

106 questions
18
votes
13 answers

Tables could not be fetched - Error loading schema content

I open workbench and connect to a local database on XAMPP and when open the connection the schema show the error message: "tables could not be fetched"
Alex Roitman
  • 151
  • 1
  • 2
  • 7
16
votes
3 answers

Redshift VACUUM cannot run inside a transaction block on SQLWorkbenchJ

I have got a: VACUUM cannot run inside a transaction block error on SQLWorkbenchJ in Redshift, but I already commit all transactions before this.
Ting Jia
  • 197
  • 1
  • 1
  • 6
12
votes
2 answers

Connection to SQL Workbench/J gets disconnected frequently

The connection to SQL Workbench/J gets disconnected very frequently. Where can I change the settings so that it does not lose the connections for atleast an hour. Thanks
Amy123
  • 902
  • 9
  • 15
10
votes
1 answer

"Unable to load Java Runtime Environment" when starting SQLWorkbench/J

I get Unable to load Java Runtime Environment when starting SQLWorkbenchJ.app. I'm on macOS Catalina 10.15.2, and I installed the app with brew cask install sqlworkbenchj. My JDK 8 is installed using brew install adoptopenjdk8. How do I solve this…
neu242
  • 15,796
  • 20
  • 79
  • 114
10
votes
3 answers

How to save Amazon Redshift output to local CSV through SQL Workbench?

I am writing psql through Amazon Redshift and now I am trying to save the output as CSV through PSQL query, on SQL Workbench The reason I am planning to do this through query instead of using select clause and then right click to save the output as…
Cherry Wu
  • 3,844
  • 9
  • 43
  • 63
10
votes
4 answers

Increase heap size for sqlworkbench/J

How do we increase heap size for SqlWorkbench/J? I have tried different options but most of it says to execute below command :- java -Xmx4g -jar sqlworkbench.jar Even on http://www.sql-workbench.net/manual/install.html#install-increase-memory , it…
Neil
  • 1,715
  • 6
  • 30
  • 45
6
votes
1 answer

SQL Workbench/J and BigQuery

I am currently using SQL Workbench/J as my GUI to interface and run queries for BigQuery, however I'm running into a 10 second timeout issue when running more complicated queries. Any advice on how to increase the default timeout limit? Is it…
Jon
  • 71
  • 1
  • 4
4
votes
3 answers

list tables in redshift using SQLWorkbench

How do I list tables in redshift ? I am using SQLWorkbench. I tried SHOW TABLES; and \dt are not recognized commands. Any help?
roy
  • 6,344
  • 24
  • 92
  • 174
3
votes
0 answers

Salesforce JDBC connection

I am trying to establish a connection with Salesforce via JDBC driver which I got from https://github.com/ascendix/salesforce-jdbc I have set up this driver in SQLWorkbench tool. The connection is successful. But when I execute any query like…
Vikas J
  • 795
  • 3
  • 14
  • 31
3
votes
2 answers

Azure SQL Datawarehouse JDBC Connectivity

Asking here as a last resort, we've been having many issues trying to connect to Azure SQL DW from a non-Windows environment (Linux, Mac) where SQL Server Managment Studio (SSMS) is not an option. The core requirement is a GUI for analysis…
Kaiwalya Joshi
  • 55
  • 4
3
votes
2 answers

java.sql.SQLException: Connections could not be acquired from the underlying database! — HSQLDB

I have installed SQL Workbench/J Build 118 and I logged into the HSQL database of Liferay Portal. Then I closed the SQL Workbench without making any changes to the database. I restarted Liferay tomcat server and then I get the following…
Mustapha Aoussar
  • 5,833
  • 15
  • 62
  • 107
2
votes
0 answers

Unable to connect with GRIDDB using SQL workbench

I need to connect to a GRIDDB instance running on a CentOS 7 machine by using SQL workbench from my Windows 10 machine. I have setup the GRIDDB environment on CentOS 7 VM on Hyper-V. I am successful in taking a putty session of my VM, and can also…
Syed Mudassir Ali
  • 41
  • 2
2
votes
0 answers

Unable to run SQLWorkbenchJ on Mac OS with `temurin-18.jdk` or `sapmachine-jdk-11.0.11.jdk`: Unable to load Java Runtime Environment

Related to this post, but I do not have enough reputation to post a comment there. The problem: SQL Workbench J fails to use Java on my machine. Steps I took: Installed SQLWorkbenchJ with brew install --cask sqlworkbenchj Tried to launch SQL…
dlaz
  • 23
  • 1
  • 4
2
votes
1 answer

Using multiple instances of SQL Workbench/J

How to open multiple instances of "SQL Workbench/J" or connect to multiple Database Instances?
Dinakar Ullas
  • 203
  • 2
  • 8
2
votes
2 answers

Cannot connect to AWS RDS database using SQL Workbench

I am trying to connect to a free AWS RDS PostgreSQL database I created using SQL Workbench/J, I am following the instructions provided from AWS. When I get to the end of Step 4, connecting to the PostgreSQL database, I keep receiving this…
user14656359
  • 21
  • 1
  • 2
1
2 3 4 5 6 7 8