March 2002
Intermediate to advanced
320 pages
8h 58m
English
Content preview from Building Java Enterprise ApplicationsBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.