7.2.3. Testing the MySQL DataSource
We’ll use the CMP roster application to test the new database connection. In order to use MySql in our application, we'll need to set the datasource name a nd type-mapping in the jbosscmp-jdbc.xml
file in the dd/team
directory of the CMP roster application. Edit the file and add the following datasource
and datasource-mapping
elements to the defaults
element.
After restarting JBoss, you should be able to deploy the application and see the tables being created. . The tables should be visible from the MySQL client.
You can see the JMS persistence tables in there too since we’re using MySQL as the default datasource.