Data Sources

The Data Sources preferences panel is opened from menu OptionsPreferences+Data Sources

 Configuration of Data Sources

Here you can configure data sources and connections to relational databases as well as native XML databases. You can check the list of drivers (http://www.oxygenxml.com/database_drivers.html) available for the major database servers.

 

Figure 24.66. The Data Sources preferences panel

The Data Sources preferences panel

New

Opens the Data Sources Drivers dialog, allowing you to configure a new driver.

 

Figure 24.67. The Data Sources Drivers dialog

The Data Sources Drivers dialog

Name

Allows you to name the new data source driver.

Type

Select data source type from the supported driver types.

Help

Open the User Manual at the list of the sections where the configuration of supported data sources is explained and the URLs for downloading the database drivers are specified.

Driver Class

Provide the Driver Class for the data source driver

Add

Adds the driver class library.

Remove

Removes driver class library from the list.

Detect

Detects driver candidates.

Stop

Stops the detection of the driver candidates.

Edit

Opens the Data Sources Drivers dialog, allowing you to edit the selected driver. See above the specifications for the Data Sources Drivers dialog (in order to edit a data source , there must be no connections using that data source driver).

Delete

Deletes the selected Data Source Driver (in order to delete a data source , there must be no connections using that data source driver).

 

Figure 24.68. The Connections preferences panel

The Connections preferences panel

[Note]Note

Checked connections will be visible in the Data Source Explorer View.

For performance issues, you can set the maximum number of cells that will be displayed in the Table Explorer view. Leave the field Limit the number of cells empty if you want the entire content of the table to be displayed. By default this field is set to 2,000. If a table having more cells than the value set here is displayed in the Table Explorer view, a warning dialog will inform you that the table is only partially shown.

In Oracle XML and Tamino databases a container can hold millions of resources. If the node corresponding to such a container in the Data Source Explorer view would display all the contained resources at the same time the performance of the view would be very slow. To prevent such a situation only a limited number of the contained resources is displayed as child nodes of the container node. Navigation to other contained resources from the same container is enabled by the Up and Down buttons of the Data Source Explorer view. This limited number is set in the option Maximum number of children for container nodes. The default value is 200 nodes.

New

Opens the Connection dialog.

 

Figure 24.69. The Connection dialog

The Connection dialog

Name

Allows you to name the new connection.

Data Source

Select data source defined in the Data Source Drivers dialog.

Depending upon the selected Data Source, you can set some of the following parameters in the Connection details area:

URL:

The URL used to connect.

User:

Provide the database user .

Password:

Provide the database password.

Host:

Provide the host address.

Port:

Provide a port to connect.

XML DB URI:

Provide the database URI to connect.

Database:

Provide the initial database.

Collection:

Select one of the available collections for the specified data source.

Environment home directory:

Specify the home directory for a Berkeley database.

Verbosity:

Set the verbosity level for a Berkeley database.

Edit

Opens the Connection dialog, allowing you to edit the selected connection. See above the specifications for the Connection dialog.

Delete

Deletes the selected connection.