How to Configure a MySQL Data Source

Previous versions of Oxygen XML Developer (up to version 11.2) included a built-in type of data sources called MySQL and based on the JDBC driver for the MySQL 4 server. That type of data source is still available but is marked outdated because it does not support more recent versions of the MySQL server (starting from version 5.0) and it will be removed in a future version of Oxygen XML Developer .For connecting to a MySQL server you should create a new data source of type Generic JDBC based on the MySQL JDBC driver available from the MySQL website. The steps for configuring such a data source are the following:
  1. Go to menu Preferences > Data Sources.
  2. Click the New button in the Data Sources panel.

    The dialog for configuring a data source will be opened.

    Data Source Drivers Configuration Dialog

  3. Enter a unique name for the data source.
  4. Select Generic JDBC in the driver type combo box.
  5. Add the MySQL 5 driver files using the Add button. The driver file for the MySQL server is called mysql-com.jar. In the Download links for database drivers section there are listed the URLs from where to download the drivers necessary for accessing MySQL databases in Oxygen XML Developer .
  6. Select the most suited Driver class.
  7. Click the OK button to finish the data source configuration.