ij Properties Reference
Page 11 of 13

ij.URLCheck

Function

This property determines whether ij checks for invalid or non-Cloudscape URL attributes. Set this property to false to prevent ij from validating URL attributes. The default value is true.

NEW: This property and default attribute checking in ij are new in version 3.6.

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 autocommit has the pre-defined values of true or false. If you try to set the attribute autocommit to a value other than true or false, ij displays an error. For example:

ij> Connect 'jdbc:cloudscape:anyDB;create=true;autocommit=falj';
ERROR XJ05B: JDBC attribute 'autocommit' has an invalid value 'falj',
valid values are '{true|false}'.
ij>

Syntax

ij.URLCheck={ false | true }

Examples

By default, ij displays messages about invalid attributes:

java -Dij.protocol=jdbc:cloudscape: COM.cloudscape.tools.ij
ij version 3.6 (c) 1997-2000 Informix Software, Inc.
ij> connect 'mydb;uSer=naomi';
URL Attribute [uSer=naomi]
   Case of the Cloudscape attribute is incorrect.

The following command line specifies to turn off URL attribute checking in ij.

java -Dij.URLCheck=false -Dij.protocol=jdbc:cloudscape: COM.cloudscape.tools.ij
ij version 3.6 (c) 1997-2000 Informix Software, Inc.
ij> connect 'mydb;uSer=naomi';
ij>

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

Notes

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

The following table lists the attributes recognized by ij:

Attribute

autocommit

bootPassword

convertToSource

create

createSource

createTargetFrom

current

databaseName

dataEncryption

encryptionAlgorithm

encryptionProvider

locale

logDevice

password

shutdown

unicode

upgrade

user