O'Reilly logo

Building Java Enterprise Applications by Brett McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix A. SQL Scripts

This appendix contains the SQL scripts that are specific to a variety of different databases. In addition to adding enhancements that will improve performance on a specific database, these scripts omit any constructs that are not supported by a specific database (for example, the InstantDB script does not employ foreign keys, a feature still under development). If you are having trouble with the standard SQL scripts provided in Chapter 3 or Chapter 5, check to see if a script for your specific database is included here.[33] All of the scripts shown here are available for download online by visiting http://www.newInstance.com.

Additionally, many of these scripts contain information that is not SQL, but instead is an instruction set for the database. For example, the Cloudscape database needs connection information specified at the head of any SQL script run against it, and InstantDB needs information about the JDBC driver to use. For each of the databases covered here, specific deployment details are covered in Appendix B. Any additional information specified in the examples in this appendix is also used in Appendix B as part of deployment.

Finally, the scripts used to create the accounts storage assume that the scripts to create the user store have already been run. In other words, if you are using Cloudscape, you must execute the script in Example A-1 before executing the one in Example A-6. This is because the foreign key constraint on the USER_ID in the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required