Index

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 paramter - WbSetConfig
JDBC driver, Configuring JDBC drivers
Connection profile, Connecting to the database
autocommit, Autocommit
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

D

DB2
Problems, DB2 Problems
DbExplorer
prevent locking, Changing the isolation level for the table list retrieval
show all triggers, Show trigger panel
DDL
Execute DDL statements, Creating stored procedures and triggers
DML
select values for foreign key columns, Selecting FK values when editing DML statements

F

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

M

Microsoft SQL Server
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 Problems
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
MySQL
display table comments in DbExplorer, No table comments are displayed in the DbExplorer
problems, MySQL Problems

S

Starting
Java runtime not found on Windows, Starting the program using the Windows® launcher
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

V

Variables
define on commandline, Defining variables
definition, Variable substitution in SQL statements
use in batch files, Defining variables