ij Commands and Errors Reference
Page 26 of 39

Protocol

Syntax

PROTOCOL String [ AS Identifier ]

Description

Specifies the protocol, as a String, for establishing connections and automatically loads the appropriate driver. Protocol is the part of the database connection URL syntax appropriate for your environment, including the JDBC protocol and the Cloudscape-specific protocol. For further information about the Cloudscape database connection URL, see the Cloudscape Developer's Guide (embedded environment) or the Cloudscape Server and Administration Guide (client/server environment) for complete details. Only Cloudscape protocols are supported. Those protocols are listed in ij.protocol.

Providing a protocol allows you to use a shortened database connection URL for connections. You can provide only the database name instead of the full protocol. In addition, you do not need to use the Driver command or specify a driver at start-up, since the driver is loaded automatically.

If you name the protocol, you can refer to the protocol name in the Connect command.

Example

ij> protocol 'jdbc:cloudscape:';
ij> connect 'toursDB;autocommit=false';
ij> -- another example, this one showing the use of a name
ij> protocol 'jdbc:cloudscape:weblogic:' as wlp;
ij> connect 'toursDB' protocol wlp;