Configure a DB Connection #

How To Video #

This video shows how to create and test a database connection, as part of creating an app. Details follow in the page below.

Video: Create a database connection [starts at time 3:55] #

Overview #

After clicking the Create New Application button on the Admin > DB Connectons page, you will be prompted with the Create New Database Connection dialog box.

Create New Database dialog box #

• Database Connection Name - A name for the DB connection.

• Database Type - Specify the database type you want to connect to, example: "Oracle", "MySQL", and so on.

Click the Create Database Connection button to create it.

Edit Database Connection Properties #

Locate your new connection in the list of connections and click "Edit".

Connection Name - Used to specify a descriptive name for the Data Source.

JDBC Driver - Used to specify the classname of the JDBC driver that will be used to establish the JDBC connection. The default value is based on the "Database Type" selected during create.

JDBC Username - Used to specify the username that will be used to establish the JDBC connection. The correct value will depend on your own database system configuration.

JDBC Password - Used to specify the password that will be used to establish the JDBC connection. The correct value will depend on your own database system configuration.

JDBC URL - Used to specify the JDBC connection URL that will be used to establish the JDBC connection. The default value is based on the "Database Type" selected during create.

"Close" button - Clicking the button will close the dialog box without saving any of the changes.

"Test" button - Clicking the button will cause DataSpeeder to attempt to connect to the database using the properties specified in the dialog box. A message will appear reporting the results of the test (success or failure).

"Save" button - Clicking the button will save the changes and close the dialog box.

Test Database Connection #

Clicking the "Test"" button will cause DataSpeeder to attempt to connect to the database using the properties specified in the dialog box. A message will appear reporting the results of the test (success or failure).

Delete Database Connection #

The "Delete ..." button - Click the button for the specific item to delete that Data Source. You will be prompted for confirmation before the delete occurs.