critical investigation of SQLJ

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.