ij.URLCheck property The ij.URLCheck property specifies whether ij should check for invalid or non- URL attributes when you are using the embedded driver. Attributes to database connection URLvalidating in ij URL attributesverifying in ij ij.URLCheck property

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 has an incorrect case, ij prints a message.

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 ij> connect 'mydb;uSer=naomi'; URL Attribute [uSer=naomi] Case of the attribute is incorrect.

The following command line turns off URL attribute checking in ij. java -Dij.URLCheck=false org.apache.derby.tools.ij ij version ij> connect 'mydb;uSer=naomi'; ij>

Typically, you would only explicitly turn off the URL checker if you were using ij with a non- 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 . 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.