Building Java Enterprise Applications

Appendix B. SQL Deployment

This appendix contains deployment details about specific databases. If you are having trouble executing the SQL scripts covered in Chapter 3 or Chapter 5 or Appendix A, this appendix can be used as a helpful reference. The instructions in this chapter are supplied merely as a convenience, and are only one of many ways that SQL can be executed against databases. You should consult the vendor documentation for your database to see alternatives to the methods provided here.

The instructions in each section cover a means of deploying SQL scripts into a database. In this context, deployment refers simply to executing the SQL against the database so that tables, columns, and relationships are generated. If you are following along with the examples (and hopefully you are!), you will want to execute the SQL for your database (from Appendix A) against your instance. Once this is done, the entity beans and other code that utilize the database are ready to be used. As in the other appendixes, new versions of these products are always appearing; these may cause small inconsistencies in the instructions provided here. Please be tolerant of these mistakes; if major problems arise, I’ll attempt to correct them in later revisions and editions. I also welcome you letting me know about problems you find via the email addresses listed in the Preface; if you have a different database, you can also send me instructions on deployment for that product, and I’ll test it and ...