The Java Development Environment defines SQLJ as a standard way of embedding the relational database language SQL in the object-oriented programming language Java. Oracle Corporation provides an extension of SQLJ that supports dynamic SQL constructs for the processing of SQL commands that are not completely known at compile time. Unfortunately, these constructs are not sufficient to handle all dynamic situations, so that the programmer has to depend on other SQL embeddings, such as JDBC, in addition to Oracle’s SQLJ.
In this thesis we implement several extensions to Oracle’s SQLJ so that all dynamic situations can be programmed in SQLJ, without resorting to other SQL embeddings. We also add a sub-query based for loop facility, similar to the one provided in Oracle’s database programming language PL/SQL, as an improvement over the iterator constructs that SQLJ provides.
This thesis discusses the design, development and implementation of these SQLJ extensions, and provides applications that show the utility of these extensions in terms of clarity and power.
|Advisor:||Solomon, Martin K.|
|Commitee:||Cardei, Ionut, Cooper, Robert B.|
|School:||Florida Atlantic University|
|Department:||Computer and Electrical Engineering and Computer Science|
|School Location:||United States -- Florida|
|Source:||MAI 51/05M(E), Masters Abstracts International|
Copyright in each Dissertation and Thesis is retained by the author. All Rights Reserved
The supplemental file or files you are about to download were provided to ProQuest by the author as part of a
dissertation or thesis. The supplemental files are provided "AS IS" without warranty. ProQuest is not responsible for the
content, format or impact on the supplemental file(s) on our system. in some cases, the file type may be unknown or
may be a .exe file. We recommend caution as you open such files.
Copyright of the original materials contained in the supplemental file is retained by the author and your access to the
supplemental files is subject to the ProQuest Terms and Conditions of use.
Depending on the size of the file(s) you are downloading, the system may take some time to download them. Please be