Index

A

Amazon Redshift
ERROR: type "e" does not exist, Amazon Redshift

B

Batch files
connecting, Specifying the connection
defining variables, Defining variables
setting SQL Workbench/J configuration properties, Setting configuration properties
specify SQL script, Specifying the script file(s)
starting SQL Workbench/J, Using SQL Workbench/J in batch files

C

Clipboard
export result to, Export result data
import data from, Import the clipboard into the current result
Command line
connection profile, Connect using a pre-defined connection profile
JDBC connection, Connect without a profile
parameters, Command line parameters
Configuration
advanced configuration properties, Advanced configuration options
change advanced configuration properties, Change an internal configuration parameter - WbSetConfig
configure SQL keywords, Configuring SQL keywords
JDBC driver, Configuring JDBC drivers
Connection profile, Connecting to the database
autocommit, Autocommit
Configure SSH tunnel, Connecting through a SSH tunnel
connection URL, URL
create, Connection profiles
default fetch size, Fetch size
delete, Connection profiles
extended properties, Extended properties for the JDBC driver
separate connection, Separate connection per tab
separate session, Separate connection per tab
timeout, Timeout
Customize
DbExplorer DDL generation, Customize table source retrieval

D

DB2
Column comments not displayed, Column or table comments are not displayed
Connection closed, "Connection closed" errors
DATE values not displayed, Date values are not displayed
Problems, IBM DB2
Table comments not displayed, Column or table comments are not displayed
DbExplorer
customize DDL generation, Customize table source retrieval
prevent locking, Changing the isolation level for the table list retrieval
show all triggers, Show trigger panel
DbTree
macros, DbTree macros
DDL
Execute DDL statements, Creating stored procedures and triggers
DML
select values for foreign key columns, Selecting FK values when editing DML statements

F

FlatLaf
Configure, Customize the FlatLaf Look & Feel
Theme, Customize the FlatLaf Look & Feel
Foreign keys
editing values of foreign key columns, Editing foreign key values
Update foreign key columns, Selecting FK values when editing DML statements

J

Java runtime
Java not found on Windows, Starting the program using the Windows® launcher
JDBC Connection
connection properties, Extended properties for the JDBC driver
JDBC driver
class name, Configuring JDBC drivers
jar file, Configuring JDBC drivers
library, Configuring JDBC drivers
license file, Configuring JDBC drivers
sample URL, Configuring JDBC drivers

L

Liquibase
Run SQL from Liquibase file, Extract and run SQL from a Liquibase ChangeLog - WbRunLB
Look and Feel
FlatLaf Theme, Customize the FlatLaf Look & Feel

M

Memory problems
WbCopy or WbExport using a lot of memory with PostgreSQL, WbExport or WbCopy using a lot of memory
WbCopy or WbExport using a lot of memory with SQL Server, WbExport or WbCopy using a lot of memory
Microsoft SQL Server
Incorrect value for DATE columns, The value of DATE columns is not correct
JDBC URL properties, Sequences are incremented twice
Locking problems, Dealing with locking problems
lock timeout for DbExplorer, Define a lock timeout for the DbExplorer
prevent locking in DbExplorer, Changing the isolation level for the table list retrieval
Problems, Microsoft SQL Server
Problem when running SHOWPLAN_ALL, The Microsoft Driver throws an Exception when using SET SHOWPLAN_ALL
Sequence increments twice, Sequences are incremented twice
WbCopy memory problem, WbExport or WbCopy using a lot of memory
WbExport memory problem, WbExport or WbCopy using a lot of memory
Windows authentication, Using Windows authentication to connect to a SQL Server
MySQL
display table comments in DbExplorer, No table comments are displayed in the DbExplorer
problems, MySQL

P

PostgreSQL
.pgpass, Using .pgpass
check for pending transactions, Checking for un-committed changes
COPY, Using the COPY API for client side files
libpq, PostgreSQL connections
pgpass, PostgreSQL connections
pgpass.conf, Using .pgpass
Problems, PostgreSQL
WbCopy memory problem, WbExport or WbCopy using a lot of memory
WbExport memory problem, WbExport or WbCopy using a lot of memory
Problems
Amazon Redshift, Amazon Redshift
Cipher not available, Connecting through a SSH tunnel
Context menu not displayed, The GUI freezes when displaying menus or context menus
create stored procedure, Syntax error when creating stored procedures
create trigger, Syntax error when creating stored procedures
dialog too small, Some of the dialogs are too small
driver not found, The driver class was not found
Editor, Text cursor is not shown at the correct position
Excel export not possible, Excel export not available
Excel files can't be opened, Generated XLSX files can't be opened with Excel
GUI freezes, The GUI freezes when displaying menus or context menus
Hi-DPI, Text cursor is not shown at the correct position
IBM DB2, IBM DB2
memory usage during export, Memory usage and WbExport
Microsoft SQL Server, Microsoft SQL Server
MySQL, MySQL
Oracle, Oracle
out of memory, Out of memory errors
PostgreSQL, PostgreSQL
Sybase SQL Anywhere, Sybase SQL Anywhere
Text cursor at wrong position, Text cursor is not shown at the correct position
timestamp with timezone, Timestamps with timezone information are not displayed correctly
timezone, Timestamps with timezone information are not displayed correctly
wrong DDL, The SQL source code for tables or indexes is incorrect
wrong index source, The SQL source code for tables or indexes is incorrect
wrong table source, The SQL source code for tables or indexes is incorrect
Profile dialog
dialog too small, Some of the dialogs are too small

S

SQL
change the statement delimiter, Creating stored procedures and triggers
configure SQL keywords, Configuring SQL keywords
SSH Host
Setup, SSH Hosts
SSH Tunnel
Setup, Connecting through a SSH tunnel
Starting
Java runtime not found on Windows, Starting the program using the Windows® launcher
Statement delimiter
change the statement delimiter, Creating stored procedures and triggers
Stored procedures
create stored procedure, Creating stored procedures and triggers

T

Triggers
create trigger, Creating stored procedures and triggers
show all triggers in DbExplorer, Show trigger panel