Java DB

Apache Derby

Derby Tools and Utilities Guide

Derby Getting Started
Derby Reference Manual
Derby Developer's Guide
Derby Performance Tuning
Derby Server and Admin Guide
Derby Tools and Utilities
Derby Tools and Utilities
-Copyright
-License
-About this guide
-What are the Derby tools and utilities?
-Using ij
-ij properties reference
-ij commands and errors reference
-ij commands
-Absolute command
-After Last command
-Async command
-Autocommit command
-Before First command
-Close command
-Commit command
-Connect command
-Describe command
-Disconnect command
-Driver command
-Elapsedtime command
-Execute command
-Exit command
-First command
-Get Cursor command
-Get Scroll Insensitive Cursor command
-Help command
-Last command
-LocalizedDisplay command
-MaximumDisplayWidth command
-Next command
-Prepare command
-Previous command
-Protocol command
-Readonly command
-Relative command
-Remove command
-Rollback command
-Run command
-Set Connection command
-Show command
-Wait For command
-Syntax for comments in ij commands
-Syntax for identifiers in ij commands
-Syntax for strings in ij commands
-ij errors
-Using the bulk import and export procedures
-Storing jar files in a database
-sysinfo
-dblook
-SignatureChecker
-Trademarks

 

derby.ui.locale property

Function

Set this property to a supported locale name when using one of the Derby tools, if you want another locale than the system default locale. The locale determines the localized display format for numbers, dates, times and timestamps, as well as the language of the messages from the Derby tools. Note that some pages in the Derby documentation guides refer to a "locale" as a "territory".

Syntax

derby.ui.locale=derbyval

where derbyval is a supported locale name, in the form ll_CC, where ll is the two-letter language code, and CC is the two-letter country code; for example, ja_JP.

Example

The following command specifies to run ij using the Japanese territory (derby.ui.locale=ja_JP) using Japanese Latin Kanji mixed encoding (codeset=Cp939):

java -Dderby.ui.locale=ja_JP -Dderby.ui.codeset=Cp939 
    -Dij.protocol=jdbc:derby:
    org.apache.derby.tools.ij
Language codes consist of a pair of lowercase letters that conform to ISO-639.
Table 1. Sample Language Codes
Language Code Description
de German
en English
es Spanish
ja Japanese

To see a full list of ISO-639 codes, go to http://www.ics.uci.edu/pub/ietf/http/related/iso639.txt.

Country codes consist of two uppercase letters that conform to ISO-3166.
Table 1. Sample Country Codes
Country Code Description
DE Germany
US United States
ES Spain
MX Mexico
JP Japan

A copy of ISO-3166 can be found at http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html.

 

javadb@jdbcurl.com