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.
Opens the JDBC Drivers dialog, allowing you to configure a new driver that will appear in in the list from "Select database table" dialog.
Provide the name for the JDBC Driver
Provide the URL for the JDBC Driver
Provide the Driver Class for the JDBC Driver
Adds the JDBC driver class library.
Removes driver class library from the list.
Detects JDBC driver candidates.
Stops the detection of the JDBC driver candidates.
Opens the JDBC Drivers dialog, allowing you to edit the selected driver. See above the specifications for the JDBC Drivers dialog.
Deletes the selected JDBC Driver.
Here it is configured how empty values and null values are handled when they are encountered in an import operation.
If this option is enabled an empty value from a database column will be imported as an empty element.
If this option is enabled a null value from a database column will be imported as an empty element.
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.
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.