To connect to a MySQL server, create a data source of a generic JDBC type, based on
the
MySQL JDBC driver available on the MySQL website. The following steps describe how
you can configure such a data source:
-
Open the
Preferences dialog box and go to .
-
Click the
New button in the
Data Sources panel.
The dialog box for configuring a data source is opened.
Figure: Data Source Drivers Configuration Dialog Box
-
Enter a unique name for the data source.
-
Select Generic JDBC in the driver Type drop-down
list.
-
Add the MySQL driver files using the Add Files button.
The driver file for the MySQL server is called
mysql-com.jar. The
Driver files section lists
download links for database
drivers that are necessary for accessing MySQL databases in
Oxygen XML Developer plugin.
-
Select the most appropriate Driver
class.
-
Click the OK button to finish the data source
configuration.
