Book description
In Building e-Commerce Database Applications Using Oracle8i and Java from scratch, Meghraj Thakkar takes novice web programmers through the process of creating a web-enabled database application. You will look at the requirements, analysis, design, implementation, testing and deployment of an "Online Coffee Shop" from scratch. You will also learn to create database objects (tables and indexes), populate the database, and use SQL, PL/SQL and Java to manipulate the data. Additional topics include using Oracle tools such as SQL*Loader and Export/Import to populate Oracle databases, use of JDBC to connect and interact with the database, how to process the results coming back from the database, use of SQLJ to write efficient Java code, JDBC error messages & exceptional handling in the project, how to store Java code in the database using Java Stored Procedures, techniques for debugging & stress testing your applications, and more.
Table of contents
- Copyright
- Foreword
- About the Author
- Acknowledgments
- Introduction
-
Introduction to the Internet Capabilities of Oracle8i
- What Is a Database?
- Database Management Systems (DBMS)
- Understanding the Relational Model
- Oracle8i Architecture
- Physical Database Structure
- Logical Database Components
- The Oracle Data Dictionary
- Managing Transactions
- The Starter Database
- Web-enabling Oracle Database Applications
- Introducing the Project
- Next Steps
-
Creating and Populating the JavaStop Database
- Making Use of Java as a Strategic Component
- Designing and Building the Application
- Designing the JavaStop Database
- Issues with Web-enabling JavaStop
- Tasks Prior to Database Creation
- Choosing Initialization Parameters for JSTP
- Organizing Database Objects
- Setting Environment Variables
- Methods for Database Creation
- Populating the Database Using Oracle Utilities
- Working with Export/Import Utilities
- Next Steps
- Manipulating the JavaStop Oracle Database Using SQL
- Java Basics for Developing JavaStop
- Using JDBC to Connect to JavaStop
- Using JDBC to Perform Data Manipulation in JavaStop
- Implementing Clean and Compact Code Using SQLJ
- Handling Exceptions in JavaStop
- Writing Java Stored Procedures for JavaStop
- Diagnosing Problems and Debugging JavaStop Code
-
Securing JavaStop Using Database Security and Firewalls
- Introduction
- Understanding the Security Challenges in JavaStop
- Understanding Firewalls
- Understanding the Oracle Advanced Security Option
- Authenticating Connections to JavaStop
- Securing the JSTP Database
- Securing Applications
- Understanding Definer and Invoker Rights
- Auditing JavaStop Activity
- Next Steps
- Improving the Scalability of JavaStop
- Optimizing JavaStop Performance
- Testing JavaStop to Improve Quality
- Enhancing JavaStop Using EJBs and CORBA
- JDBC API Reference
- Oracle8i Commonly Used SQL Statements and Data Dictionary Views
- Index
Product information
- Title: e-Commerce Applications Using Oracle8i and Java from Scratch
- Author(s):
- Release date: March 2000
- Publisher(s): Que
- ISBN: 9780789723383
You might also like
book
SOA with Java: Realizing Service-Orientation with Java Technologies
“An outstanding depth-and-breadth resource for IT architects and Java professionals to understand and apply the marriage …
book
Beginning Java EE 7
Java Enterprise Edition (Java EE) continues to be one of the leading Java technologies and platforms. …
book
Full Stack Development with JHipster - Second Edition
Written by the core development team of JHipster and fully updated for JHipster 6, Java 11, …
book
Java Enterprise in a Nutshell, Third Edition
Nothing is as constant as change, and this is as true in enterprise computing as anywhere …