You are here
Implementation of an improved embedded SQL for Java
- Date Issued:
- 2012
- Summary:
- The Java Devlopment 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 provided applications that show the utility of these extensions in terms of clarity and power.
Title: | Implementation of an improved embedded SQL for Java. |
110 views
44 downloads |
---|---|---|
Name(s): |
Bradley, Louis M. College of Engineering and Computer Science Department of Computer and Electrical Engineering and Computer Science |
|
Type of Resource: | text | |
Genre: | Electronic Thesis Or Dissertation | |
Date Issued: | 2012 | |
Publisher: | Florida Atlantic University | |
Physical Form: | electronic | |
Extent: | vi, 84 p. : ill. | |
Language(s): | English | |
Summary: | The Java Devlopment 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 provided applications that show the utility of these extensions in terms of clarity and power. | |
Identifier: | 827936118 (oclc), 3358327 (digitool), FADT3358327 (IID), fau:4012 (fedora) | |
Note(s): |
by Louis M. Bradley. Thesis (M.S.C.S.)--Florida Atlantic University, 2012. Includes bibliography. Mode of access: World Wide Web. System requirements: Adobe Reader. |
|
Subject(s): |
SQL (Computer program language) Java ( (Computer program language) Object-oriented programming ( (Computer science) Client/server computing Application software -- Development |
|
Persistent Link to This Record: | http://purl.flvc.org/FAU/3358327 | |
Use and Reproduction: | http://rightsstatements.org/vocab/InC/1.0/ | |
Host Institution: | FAU |