SQLJ: the next step in database access with Java. (Recent Literature).Until recently, Java programmers working in an Oracle environment have primarily used JDBC (Java DataBase Connectivity) A programming interface that lets Java applications access a database via the SQL language. Since Java interpreters (Java Virtual Machines) are available for all major client platforms, this allows a platform-independent database (Java Database Connectivity (database, programming) Java Database Connectivity - (JDBC) Part of the Java Development Kit which defines an application programming interface for Java for standard SQL access to databases from Java programs. http://java.sun.com/products/jdk/1.1/docs/guide/jdbc/index.html. ) to access data within an Oracle database. SQLJ (SQL Java) A programming interface that allows SQL statements to be expressed at a high level in a Java program. SQLJ statements are converted into JDBC commands. See JDBC. is a technology that serves the same purpose, but goes further than JDBC. In this new book, "Java Programming with Oracle SQLJ" (O'Reilly, 28.50 [pounds sterling]),the author Jason Price Jason Price is a professional footballer currently playing at Doncaster Rovers in Football League One. He came to the Rovers after playing for Hull City. He plays as a midfielder or forward. states that SQLJ operates at a higher level of abstraction The level of complexity by which a system is viewed. The higher the level, the less detail. The lower the level, the more detail. The highest level of abstraction is the single system itself. than JDBC and has a more concise syntax than JDBC. This results in SQLJ programs containing fewer lines of source code than comparable JDBC programs. In addition, with SQLJ the compiler checks the embedded SQL SQL statements that are written into a high-level programming language such as C or Pascal. In a preprocessing stage, the SQL code is converted into function calls, which may be optimized to provide the fastest results. statement during compilation, while JDBC checks them only when the program is actually run. This translates into more rapid, concise development with SQLJ, with fewer errors making their way into the production code. "SQLJ represents the next step in the evolution of database access using Java. It is poised to become THE way to use the Oracle9i database with Java," says Price. `Once programmers try SQLJ, they'll never want to go back to JDBC.1 A longtime Oracle insider, Price outlines SQLJ programming techniques in his book, first showing readers how to connect to an Oracle database to issue SELECT queries and other SQL SQL in full Structured Query Language. Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. statements. He then moves on to more advanced topics, such as deploying SQLJ code within the Oracle database server, using streams, and working with large objects. Price's goal in writing the book was to provide all the information programmers would need to write high-quality SQLJ programs. "Java Programming with Oracle SQLJ" also provides full descriptions of the various command-line tools, the requirements for using SQLJ, performance tuning tips, and an abundance of working code examples to illustrate the real-world use of SQLJ. An article by the author, `Using Static and Dynamic SQL in SQLJ" can be found at: http://oracle.oreilly.com/news/javaoracle SQLJ-0801.html |
|
||||||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion