Database Connection


This chapter is composed of :

  1. Introduction
  2. New Database Connection
    1. New Database Connection
      1. Database Name
      2. User ID
      3. Password
      4. JDBC Connection URL
      5. Default Value
      6. Check Database Connection
      7. Meta Data
        1. Schema Name
        2. Schemas
    2. New Database Schema
      1. Database Schema Name
    3. New Database Schema DTD
      1. Database Schema DTD Name
    4. Finish
  3. Database Connection Update
  4. Database Schema Update
  5. Database Schema DTD Update
  6. Reverse Command

1. Introduction

The purpose of this chapter is to show you how to create and update a Database Connection in the DatabaseExplorer.

2. New Database Connection

Select a MyEclipseData node, right-click and select :

New -> Database Connection.


 

The New Database Connection wizard is composed of the following pages :

 

2.1. New Database Connection

The Database Connection page inherits the Connection Global Preferences.

The Reverse check box is not inherited as this wizard will attempt to retrieve the Meta Data of your connection.

 


 

2.1.1. Database Name

Database Name is the name of your new Database Connection file.

Each resource should have a unique name in the targeted selected workspace folder or project root.

This data is not related to any Meta Data information.

This name will be the file name of the generated Database Connection file.

A Database Connection is an XML file, its file extension could be :

This file extension is managed by the Save Policy Preference.

 

2.1.2. User ID

UserID is your JDBC user id.

UserID is stored in your Database Connection file.

 

2.1.3. Password

Password is your JDBC password.

Password is stored in your Database Connection file.

 

2.1.4. JDBC Connection URL

The JDBC Connection URL described the JDBC connection information.

Each time you select another Database Type, the new default JDBC URL is displayed, however, if the current JDBC Connection URL doesn't match its current default JDBC URL then this field will not be set to the new default value. It's up to the user to explicitly call the Default Value action.

This field is updatable.

 

2.1.5. Default Value

The Default value resets the JDBC Connection URL to its predefined value.

 

2.1.6. Check Database Connection

Click on the Check Database Connection and EclipseDatabase will attempt to connect to your Database.

Your User ID, Password and Connection URL will then be used.

If you have a successful connection :



If you have an unsuccessful connection :


 

You can find more information about what happened in the DatabaseConsole.

 

 

However check the following :

 

2.1.7. Meta Data

 

 

The Meta Data check box activates the Schema Meta Data selector.

Your Database Meta Data will then be narrowed with this Schema value.

 

2.1.7.1. Schema Name

Schema Name is a Database Meta Data Schema name.

This value will narrow your reversed Meta Datas.

 

2.1.7.2. Schemas

This button activates a Database Meta Data Schemas selector.

 

 

If your current database doesn't support Meta Data Schemas, an error will be displayed.

 

 

2.2. New Database Schema

The Database Schema page inherits the Schema Global Preferences.

 

 

 

2.2.1. Database Schema Name

Database Schema Name is the name of your new Database Schema file.

Each resource should have a unique name in the targeted selected workspace folder or project root.

This data is not related to any Meta Data informations.

This name will be the file name of the generated Database Schema file.

A Database Schema is an XML file, its file extension could be :

This file extension is managed by the Save Policy Preference.

This file is referenced in your current Database Connection.

 

2.3. New Database Schema DTD

The Database Schema DTD page inherits the Schema DTD Global Preferences.

 


 

2.3.1. Database Schema DTD Name

Database Schema DTD Name is the name of your new Database Schema DTD file.

Each resource should have a unique name in the targeted selected workspace folder or project root.

This data is not related to any Meta Data informations.

This name will be the file name of the generated Database Schema DTD file.

A Database Schema DTD is an DTD file, its file extension is :

This file is referenced in your current Database Schema.

 

 

2.4. Finish

The reverse of the new Database Connection will be processed and displayed in the Database Explorer.

Detailed information will be output in the DatabaseConsole window.



 

3. Database Connection Update

 

 

Any Database Connection can be updated.

Select a Database Connection node, right-click and select Properties.

 

 

 

4. Database Schema Update

 

 

 

Any Database Schema can be updated.

Select a Database Schema node, right-click and select Properties.

 

 

Parent information is inherited.

This means that you can modify the Database Connection information of a Database Schema.

 

5. Database Schema DTD Update

 

 

Any Database Schema DTD can be updated.

Select a Database Schema DTD node, right-click and select Properties.

 

 

Parent information is inherited.

This means that you can modify the Database Conection and the Database Schema information of a Database Schema DTD.

 

6. Reverse Command

 

 

Select a Database Connection node, right-click and select Reverse.

The Database Meta Data will be reversed and a merge process will be performed with the current content of your Database Schema.

A report will be displayed in the DatabaseConsole.