Java DB
Apache Derby
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:
The ij Driver name and connection URL
Specifying the Driver Name and database connection URL
, summarizes the different ways to specify the driver name and database connection URL.
Table 1. Specifying the Driver Name and database connection URL
Action
System Property
ij
Property
ij
Command
loading the driver implicitly
ij.connection.connectionName
(plus full URL)
ij.database
(plus full URL)
ij.protocol
ij.protocol.protocolName
(plus protocol clause in Connect command)
Protocol
Connect
(plus full URL)
loading the driver explicitly
jdbc.drivers
-D
ij.Driver
Driver
specifying the database connection URL
ij.connection.connectionName
ij.database
Connect
Parent topic:
Connecting to a Derby database
javadb@jdbcurl.com