Database

Here you can configure the JDBC Drivers for the Import from Database action. Any database server that supports JDBC connectivity can be configured. You can check the list of JDBC drivers (http://www.oxygenxml.com/database_drivers.html) available for the major database servers. Before configuring a new JDBC driver for your database server in the following dialog you have to copy the jar file containing the driver in the lib subfolder of the <oXygen/> installation folder and restart the <oXygen/> application.

 

Figure 15.42. The JDBC Drivers preferences panel

The JDBC Drivers preferences panel
New

Opens the JDBC Drivers dialog, allowing you to configure a new driver that will appear in in the list from "Select database table" dialog.

 

Figure 15.43. The JDBC Drivers dialog

The JDBC Drivers dialog
Name

Provide the name for the JDBC Driver

URL:

Provide the URL for the JDBC Driver

Driver Class

Provide the Driver Class for the JDBC Driver

Add

Adds the JDBC driver class library.

Remove

Removes driver class library from the list.

Detect

Detects JDBC driver candidates.

Stop

Stops the detection of the JDBC driver candidates.

Edit

Opens the JDBC Drivers dialog, allowing you to edit the selected driver. See above the specifications for the JDBC Drivers dialog.

Delete

Deletes the selected JDBC Driver.

 Import

Here it is configured how empty values and null values are handled when they are encountered in an import operation.

 

Figure 15.44. The Database import preferences panel

The Database import preferences panel
Create empty elements for empty values

If this option is enabled an empty value from a database column will be imported as an empty element.

Create empty elements for null values

If this option is enabled a null value from a database column will be imported as an empty element.

Add annotations for generated XML Schema

If checked, the generated XML Schema will contain an annotation for each of the imported table's columns. The documentation inside the annotation tag will contain the remarks of the database columns (if available) and also information about the conversion between the column type and the generated XML Schema type.

Date/Time format

If Data base specific Date/Time format is checked, the date and time formats specific to the database will be used for import. The type used in the generated XML Schema will be xs:string.

If XSL Schema specific Date/Time format is checked, the ISO8601 format ( yyyy-MM-ddTHH:mm:ss ) will be used for imported date/time data. The types used in the generated XML Schema will be xs:datetime, xs:date and xs:time.