background image
| Contents - Sysinfo >>

Contents - Derby tools and utilities

| Contents - Sysinfo >>
Version 10.8 Derby Tools and Utilities Guide
i
Contents
About this guide..................................................................................................................10
Purpose of this document...................................................................................... 10
Audience................................................................................................................... 10
How this guide is organized...................................................................................10
What are the Derby tools and utilities?............................................................................11
Overview................................................................................................................... 11
Environment setup and the Derby tools..............................................................11
About Derby databases...........................................................................................11
JDBC connection basics.........................................................................................12
JDBC drivers overview........................................................................................ 12
Database connection URLs.................................................................................12
Tools and localization............................................................................................. 13
About locales....................................................................................................... 13
Database territory................................................................................................ 13
Specifying an alternate codeset.......................................................................... 14
Formatting display of locale-sensitive data......................................................... 14
Using ij................................................................................................................................. 15
Starting ij.................................................................................................................. 15
Creating a database using ij.................................................................................. 16
Starting ij using properties.....................................................................................16
Getting started with ij..............................................................................................17
Connecting to a Derby database........................................................................ 17
Using ij commands.............................................................................................. 19
Running ij scripts................................................................................................. 19
ij properties reference........................................................................................................ 21
ij.connection.connectionName property............................................................... 21
ij.database property................................................................................................. 21
ij.dataSource property............................................................................................. 22
ij.driver property.......................................................................................................23
ij.exceptionTrace property...................................................................................... 23
ij.maximumDisplayWidth property......................................................................... 24
ij.outfile property......................................................................................................24
ij.password property................................................................................................24
ij.protocol property.................................................................................................. 25
ij.protocol.protocolName property......................................................................... 25
ij.showErrorCode property......................................................................................25
ij.showNoConnectionsAtStart property................................................................. 26
ij.showNoCountForSelect property........................................................................ 26
ij.URLCheck property.............................................................................................. 27
ij.user property......................................................................................................... 28
derby.ui.codeset property....................................................................................... 28
derby.ui.locale property.......................................................................................... 29
ij commands and errors reference....................................................................................31
ij commands............................................................................................................. 31
Conventions for ij examples................................................................................ 31
ij SQL command behavior...................................................................................31
Absolute command..................................................................................................32