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 parameter - 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
Customize
DbExplorer DDL generation, Customize table source retrieval

D

DB2
Column comments not displayed, Column or table comments 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
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
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

S

SQL
change the statement delimiter, Creating stored procedures and triggers
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

V

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