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

-Purpose of this document
-Audience
-How this guide is organized

-What are the Derby tools and utilities?

-Overview

-Environment setup and the Derby tools

-Java 2 Platform, Standard Edition, Version 1. 4
-Classpath

-About Derby databases
-JDBC connection basics

-JDBC drivers overview
-Database connection URLs

-Tools and localization

-About locales
-Database territory
-Specifying an alternate codeset
-Formatting display of locale-sensitive data

-Using ij

-Starting ij
-Creating a database using ij
-Starting ij using properties
-Getting started with ij

-Connecting to a Derby database

-The ij Driver name and connection URL

-Using ij commands

-Other uses for ij

-Running ij scripts

-ij properties reference

-ij. connection. connectionName property
-ij.database property
-ij.dataSource property
-ij.driver property
-ij.exceptionTrace property
-ij. maximumDisplayWidth property
-ij.outfile property
-ij.password property
-ij.protocol property
-ij. protocol. protocolName property
-ij.showErrorCode property
-ij. showNoConnectionsAtStart property
-ij. showNoCountForSelect property
-ij.URLCheck property
-ij.user property
-derby.ui.codeset property
-derby.ui.locale property

-ij commands and errors reference

-ij commands

-Conventions for ij examples
-ij SQL command behavior

-ij command example

-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

-ERROR SQLState
-WARNING SQLState
-IJ ERROR
-IJ WARNING
-JAVA ERROR

-Using the bulk import and export procedures

-Methods for running the import and export procedures
-Bulk import and export requirements and considerations
-Bulk import and export of large objects
-File format for input and output
-Importing data using the built-in procedures

-Parameters for the import procedures
-Import into tables that contain identity columns

-Exporting data using the built-in procedures

-Parameters for the export procedures

-Examples of bulk import and export
-Import and export procedures from JDBC
-How the Import and export procedures process NULL values
-CODESET values for import and export procedures

-Storing jar files in a database

-Adding a Jar File
-Removing a jar file
-Replacing a jar file
-Installing a jar example

-sysinfo

-sysinfo example
-Using sysinfo to check the classpath

-dblook

-Using dblook
-dblook options
-Generating the DDL for a database
-dblook examples

-SignatureChecker

-Using SignatureChecker

-Trademarks

		Search documentation:

sysinfo example When you run the `sysinfo` command using the `derbyrun.jar` file, the output looks something like this: java -jar C:\db-derby-10.6.0.0-bin\lib\derbyrun.jar sysinfo ------------------ Java Information ------------------ Java Version: 1.6.0_20 Java Vendor: Sun Microsystems Inc. Java home: C:\jdk1.6.0_20\jre Java classpath: C:\db-derby-10.6.0.0-bin\lib\derbyrun.jar OS name: Windows XP OS architecture: x86 OS version: 5.1 Java user name: user1 Java user home: C:\Documents and Settings\user1 Java user dir: C:\DERBYDBS java.specification.name: Java Platform API Specification java.specification.version: 1.6 java.runtime.version: 1.6.0_20-b02 --------- Derby Information -------- JRE - JDBC: Java SE 6 - JDBC 4.0 [C:\db-derby-10.6.0.0-bin\lib\derby.jar] 10.6.0.0 - (908506) [C:\db-derby-10.6.0.0-bin\lib\derbytools.jar] 10.6.0.0 - (908506) [C:\db-derby-10.6.0.0-bin\lib\derbynet.jar] 10.6.0.0 - (908506) [C:\db-derby-10.6.0.0-bin\lib\derbyclient.jar] 10.6.0.0 - (908506) ------------------------------------------------------ ----------------- Locale Information ----------------- Current Locale : [English/United States [en_US]] Found support for locale: [cs] version: 10.6.0.0 - (908506) Found support for locale: [de_DE] version: 10.6.0.0 - (908506) Found support for locale: [es] version: 10.6.0.0 - (908506) Found support for locale: [fr] version: 10.6.0.0 - (908506) Found support for locale: [hu] version: 10.6.0.0 - (908506) Found support for locale: [it] version: 10.6.0.0 - (908506) Found support for locale: [ja_JP] version: 10.6.0.0 - (908506) Found support for locale: [ko_KR] version: 10.6.0.0 - (908506) Found support for locale: [pl] version: 10.6.0.0 - (908506) Found support for locale: [pt_BR] version: 10.6.0.0 - (908506) Found support for locale: [ru] version: 10.6.0.0 - (908506) Found support for locale: [zh_CN] version: 10.6.0.0 - (908506) Found support for locale: [zh_TW] version: 10.6.0.0 - (908506) ------------------------------------------------------ When you request help for a problem by posting to the derby-user mailing list, include a copy of the information provided by the `sysinfo` utility. Parent topic: sysinfo Related concepts Using sysinfo to check the classpath

	javadb@jdbcurl.com