The property is equivalent to the Connect AS
Identifier command. The database connection URL can be of the
short form if an
ij.protocol is
specified. This property can be specified more than once per session, creating
multiple connections. When ij starts, it displays the names
of all the connections created in this way. It also displays the name of the
current connection, if there is more than one, in the ij
prompt.
Syntax
ij.connection.connectionName=databaseConnectionURL
When specified on the command line, the databaseConnectionURL should
not be enclosed in single quotes. However, if the database path contains special
characters (such as a space), it must be enclosed in double quotes.
Example
This example connects to the existing database sample and
creates, then connects to, the database anotherDB.
java -Dij.connection.sample1=jdbc:derby:sample \
-Dij.connection.anotherConn=jdbc:derby:anotherDB;create=true \
org.apache.derby.tools.ij
ij version
ANOTHERCONN* - jdbc:derby:anotherDB;create=true
SAMPLE1 - jdbc:derby:sample
* = current connection
ij(ANOTHERCONN)>