XML-DBMS wizard

This is a feature of JBuilder Enterprise.

The XML-DBMS wizard creates Map files and a SQL script file to be used with XML documents in data transer.

To open the XML-DBMS wizard, choose File|New to open the object gallery, click the XML tab, and double-click the XML-DBMS icon.



Generate XML-DBMS map document and SQL script

Connection Parameters

Choose Existing Connection

Select an existing database connection from the drop-down list.

Driver

Select an existing database driver from the drop-down list. If you choose from an existing connection, this field is filled out automatically.

URL

Enter the database address. If you choose from an existing connection, this field is filled out automatically.

User Name

Enter your user name, if required.

Password

Enter you password, if required.

Extended Properties

Choose the ellipsis button to add parameters and their values.

Test

Test Connection

Press this button to test the connection.



Generate XML-DBMS map document and SQL script

This is a feature of JBuilder Enterprise.

Input DTD File

Choose the ellipsis button and browse to the DTD file you want to generate the MAP and SQL files from.

Note: If you select the DTD file in the project pane before running the wizard, this field is automatically filled in for you.

Output Map File

Specify the name you want the map file to have. Accept the default Map file name or rename it.

Output SQL File

Specify the name you want the SQL file to have. Accept the default SQL file name or rename it.

Preserve Order Within PCDATA Elements

Select this option to preserve the order of the data within the PCDATA elements.

Create Default XMLDBMSKey Table

Select this option to create a default table of the keys. This option is checked by default.