Java programming with Oracle SQLJ

  • Authors:
  • Affiliations:
  • Venue:
  • Java programming with Oracle SQLJ
  • Year:
  • 2001

Quantified Score

Hi-index 0.00

Visualization

Abstract

SQLJ is a standards-based technology for embedding SQL statements in Java programs. Functioning at a higher level of abstraction than JDBC, SQLJ uses a simpler, more concise syntax, allowing you to focus your energies on writing SQL queries rather than JDBC method calls. In addition, SQLJ can automatically perform compile-time syntax checking of SQL statements and type checking of parameters-JDBC does those things only when you actually run your program. The result of using SQLJ? A decreased likelihood of errors making it into your production code. Java Programming with Oracle SQLJ is a clear, comprehensive guide to SQLJ for developers who are writing Java programs to run against an Oracle database. You will learn how to: Create SQLJ connections to a database, issue static and dynamic SQL statemens, and get results back, add SQLJ statements to standalone Java applications, Enterprise JavaBeans, JavaServer Pages, servlets, and applets, use SQLJ in conjunction with oracle's database object features, deploy Java stored procedures to the Oracle JVM (JServer), store and retrieve large objects such as CLOBs, BLOBs, and BFILEs using SQLJ and Java streams, use WQLJ and JDBC together in the same program, create multithreaded SQLJ applications. In addition to all of this, you will find descritions of the various SQLJ command-line tools, requirements for using SQLJ in your environment, performance tuning tips that you can put to use in your SQLJ programs, and an abundance of working code examples to illustrate the real-world use of SQLJ. Source code for the examples can be downloaded from the book's web site.