You are here

FAU Collections » FAU Research Repository » FAU Theses and Dissertations

critical investigation of SQLJ

Download pdf | Full Screen View

Date Issued:
1999
Summary:
We critically investigate, evaluate, and illustrate the language of SQL and Java provided by SQLJ. We investigate the main constructs of SQLJ, such as use of declarative and executable statements, SQLJ clauses, and use of bind variables in SQLJ applications. We also observe usage of named and position iterators and we illustrate how to develop and run applications on the server side. In particular, we analyze the difference between SQLJ and JDBC and we find that SQLJ is good for static SQL whereas JDBC is good for dynamic SQL. We also compare the relationship of SQLJ to ANSI/ISO embedded SQL. Finally we evaluate the advantages of developing SQLJ stored procedure over PL/SQL procedures.
Title: A critical investigation of SQLJ.
70 views
26 downloads
Name(s): Borkar, Anjali P.
Florida Atlantic University, Degree grantor
Solomon, Martin K., Thesis advisor
Type of Resource: text
Genre: Electronic Thesis Or Dissertation
Issuance: monographic
Date Issued: 1999
Publisher: Florida Atlantic University
Place of Publication: Boca Raton, Fla.
Physical Form: application/pdf
Extent: 128 p.
Language(s): English
Summary: We critically investigate, evaluate, and illustrate the language of SQL and Java provided by SQLJ. We investigate the main constructs of SQLJ, such as use of declarative and executable statements, SQLJ clauses, and use of bind variables in SQLJ applications. We also observe usage of named and position iterators and we illustrate how to develop and run applications on the server side. In particular, we analyze the difference between SQLJ and JDBC and we find that SQLJ is good for static SQL whereas JDBC is good for dynamic SQL. We also compare the relationship of SQLJ to ANSI/ISO embedded SQL. Finally we evaluate the advantages of developing SQLJ stored procedure over PL/SQL procedures.
Identifier: 9780599540514 (isbn), 15722 (digitool), FADT15722 (IID), fau:12478 (fedora)
Collection: FAU Electronic Theses and Dissertations Collection
Note(s): College of Engineering and Computer Science
Thesis (M.S.)--Florida Atlantic University, 1999.
Subject(s): Database management
SQL (Computer program language)
Java (Computer program language)
Held by: Florida Atlantic University Libraries
Persistent Link to This Record: http://purl.flvc.org/fcla/dt/15722
Sublocation: Digital Library
Use and Reproduction: Copyright © is held by the author, with permission granted to Florida Atlantic University to digitize, archive and distribute this item for non-profit research and educational purposes. Any reuse of this item in excess of fair use or other copyright exemptions requires permission of the copyright holder.
Use and Reproduction: http://rightsstatements.org/vocab/InC/1.0/
Host Institution: FAU
Is Part of Series: Florida Atlantic University Digital Library Collections.