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

 

ij.URLCheck property

Function

This property determines whether ij checks for invalid or non-Derby URL attributes when you are using the embedded driver. Set this property to false to prevent ij from validating URL attributes. The default value is true.

When the ij.URLCheck property is set to true, you are notified whenever a connection URL contains an incorrectly specified attribute. For example if the attribute name is misspelled or cased incorrectly ij prints a message.
Note: ij checks attribute values if the attribute has pre-defined values. For example, the attribute shutdown has the pre-defined values of true or false. If you try to set the attribute shutdown to a value other than true or false, ij displays an error. For example: 
ij> Connect 'jdbc:derby:anyDB;shutdown=rue';
ERROR XJ05B: JDBC attribute 'shutdown' has an invalid value 'rue',
valid values are '{true|false}'.
ij>

Syntax

ij.URLCheck={ false | true }

Example

By default, ij displays messages about invalid attributes: 
java org.apache.derby.tools.ij
ij version 10.6 
ij> connect 'mydb;uSer=naomi';
URL Attribute [uSer=naomi]
   Case of the Derby attribute is incorrect.
The following command line specifies to turn off URL attribute checking in ij. 
java -Dij.URLCheck=false org.apache.derby.tools.ij
ij version 10.6 
ij> connect 'mydb;uSer=naomi';
ij>

Typically, you would only explicitly turn off the URL checker if you were using ij with a non-Derby JDBC driver or database.

Notes

The URL checker does not check the validity of properties, only database connection URL attributes.

For a list of attributes, see "Setting attributes for the database connection URL" in the Derby Reference Manual. Because the ij.URLCheck property is valid only with the embedded driver, it does not apply to attributes such as securityMechanism=value, ssl=sslMode, and the attributes related to tracing.

 

javadb@jdbcurl.com