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-mapping elements to the
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.