ADD CONNECTION

Core command ADD CO ADDCO AD CO ADCO

Creates a database connection in the CDF, through an interactive wizard.

Syntax

ADD CONNECTION <id>

Arguments

Argument	Required	Values	Default
`<id>`	Yes	A new connection ID, at most 15 characters, case-insensitive	None

Examples

ADD CONNECTION MYDB01;

Details

The connection ID

The ID has at most 15 characters and is case-insensitive: WORLD and world are the same connection. An ID already used by an active connection is refused before the first prompt. An ID used by an inactive connection offers to reactivate that connection instead (y); any other answer stops, so that you can choose another ID.

The wizard

The command asks in turn for Name, Type, URL, User Name, User Password, Database Group, Environment and Comment. The password is typed twice and never shown. There is no way to give these fields on the command line.

Type: one of the recognized database types. A type whose JDBC driver is not found in drivers/ or lib/ is listed with a note; it can still be chosen, but CONNECT fails until the driver JAR is added.
Environment: mandatory, an existing Environment.
Database Group: optional; left blank, the connection is standalone. When given, it is an existing Database Group, and no other connection may already use the same Database Group and Environment.

The wizard ends with Save database connection [y/n/c]?: y saves the connection and tests it at once (a failed test does not undo the save), n starts the wizard again, and any other answer stops without saving.

Used in these how-tos

How do I set up QA and production copies of WORLD to practise environment commands?

Last modified in release 5.5.0.

Found something wrong or unclear on this page? Tell us, with the page address.