Protocol command The Protocol command specifies the protocol for establishing connections and automatically loads the appropriate driver. Protocol command

Providing a protocol allows you to use a shortened database connection URL for connections. You can provide only the database name (and a subsubprotocol name if needed) 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.

Syntax PROTOCOL String [ AS Identifier ]

The protocol specified by the String is the part of the database connection URL syntax appropriate for your environment, including the JDBC protocol and the protocol specific to . For further information about the database connection URL, see . Only protocols are supported. Those protocols are listed in .

If you name the protocol by specifying an Identifier, you can refer to the protocol name in the Connect command.

 Examples ij> protocol 'jdbc:derby:'; ij> connect 'sample'; ij> protocol 'jdbc:derby:'; ij> connect 'memory:sample;create=true'; ij> protocol 'jdbc:derby:memory:'; ij> connect 'sample;create=true';