Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Details on the JDBC data source
The batch generator can use any JDBC-supported database as data source. This tutorial will walk you through setting up a MySQL database as a batch data source; setting up other databases works similarly.
For this example, we assume that a MySQL is already installed on our system. Furthermore, a database called batchdata
already exists. The database contains the table data
, which is populated with some sample data (shown below). Finally, the database is accessible for reading to a user on the local system, using user
as login name and password
as password. See the MySQL manual for information on how to set up this kind of database.
com.mysql.jdbc.Driver, and the URL for our database is <code>jdbc:mysql://localhost/batchdata
).
The user has to supply the JDBC driver and the database connection info. Token names are datbase column names, or column names qualified by table names.
-appropriate databases
-jdbc information
-setting up the information in the preference page
-valid tokens, default tables
-multiple tables, joins
-sample jdbc connection info, driver names, database names