4.7. Database Checklist
OK, so here's the checklist of things we've accomplished so far:
Because of the way we've set things up, switching databases at this point is relatively easy. For example, if you'd prefer to work against an instance of MySQL, we only need to copy the JDBC drivers to the $JBOSS_HOME/server/default/lib directory and copy a new database deployment descriptor into the deploy directory. If you use the same JNDI name that we already used, your job is doneall the code upstream will be configured and ready to hit the new database.
We've said it many times before, but it's worth saying again: Hypersonic is a great database for our immediate purposes because it doesn't require configuring an external resource. However, in a production environment, we'd most likely use a more robust database.
We are now ready to create a Car table and insert some sample data.