Skip to Main Content
Building Java Enterprise Applications
book

Building Java Enterprise Applications

by Brett McLaughlin
March 2002
Intermediate to advanced content levelIntermediate to advanced
320 pages
8h 58m
English
O'Reilly Media, Inc.
Content preview from Building Java Enterprise Applications

Oracle

Unlike many of the databases in this appendix, particularly the Java-based ones such as InstantDB and Cloudscape, creating a new database with Oracle is not such a trivial matter. In fact, entire books have been written about configuration and maintenance of Oracle databases! So in this section, the assumption is made that the database has already been created and set up. The global name of the database is ftht.middleearth.com (“ftht” instead of “forethought” because there is an eight-character limit on global names, and “middleearth.com” because it’s my home network’s domain), and the SID is FTHT. Other than these basic parameters, specific configuration items like rollback sizes and TEMP tablespaces are left to you or your DBA.

Additionally, the examples shown assume that a user has been created in the database, with the username “forethought” and the password “forethought”. This user (for simplicity’s sake) has been given the role DBA. This makes connecting, creating tables, and other administrative duties possible without explicitly granting many permissions (like CREATE SESSION, ALTER ANY TABLE, etc.).

Deployment and execution of SQL scripts in Oracle is usually done through the use of the Oracle SQL*Plus tool, with the database to modify up and running. You connect as the user able to administrate the database schema; here the user “forethought” is used. You should be in the directory where the SQL scripts you want to execute are located.

Each SQL script can be run ...

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.
Start your free trial

You might also like

Enterprise Web Programming with Java

Enterprise Web Programming with Java

O'Reilly Media, Inc.
Modernizing Enterprise Java

Modernizing Enterprise Java

Markus Eisele, Natale Vinto

Publisher Resources

ISBN: 0596001231Supplemental ContentCatalog PageErrata