Buy Used
+ £2.80 UK delivery
Used: Very Good | Details
Condition: Used: Very Good
Comment: Expedited shipping available on this book. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Understanding Sql and Java Together: A Guide to Sqlj, Jdbc, and Related Technologies (The Morgan Kaufmann Series in Data Management Systems) Paperback – 1 Jan 2000

See all 3 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
£46.95 £3.35
click to open popover

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.

Amazon Original Books on Sale
Browse a selection of over 160+ Kindle Books currently on sale from 99p. Learn more

Product details

  • Paperback: 514 pages
  • Publisher: Morgan Kaufmann Publishers In; Pap/Cdr edition (1 Jan. 2000)
  • Language: English
  • ISBN-10: 1558605622
  • ISBN-13: 978-1558605626
  • Product Dimensions: 19.7 x 3.2 x 24.1 cm
  • Average Customer Review: Be the first to review this item
  • Amazon Bestsellers Rank: 5,408,169 in Books (See Top 100 in Books)
  • Would you like to tell us about a lower price?
    If you are a seller for this product, would you like to suggest updates through seller support?

  • See Complete Table of Contents

Product description

Amazon Review

Database vendors like Oracle and Sybase have quickly signed on with Java support. The result has been a growing list of database standards (like SQLJ) that let DBMS products interoperate with Java. Written for the competent programmer, Understanding SQL and Java Together surveys all of the today's standards for making database development easier with Java.

Many books on Java cover JDBC in detail, but this title goes much further by surveying a handful of other database standards from a variety of vendors including Oracle and Sybase. (Don't worry: there's full coverage of JDBC, both version 1.0 and 2.0.) The real focus of this book is on SQLJ, which is really three standards in one. SQLJ Part 0 is the easiest to understand as it supports embedded SQL calls within Java code. Next comes SQLJ Part 1 where a database product (like Oracle) can use Java to define stored procedures. Here, the authors take care to show off how to deploy JAR files into a database. (Their sample movie database--used throughout this book--is both comprehensible and a little more entertaining than most sample database schemas.)

Next, the authors look at SQL user-defined types (UDTs) and then SQLJ Part 2, which allows Java code to make use of these UDTs directly, as well as store Java objects in a database. The last stop on the tour is a "true" object/relational mapping, Sun's Java Blend standard, which allows Java objects to be saved and restored from a database transparently. The book also reviews several of today's Java development tools (including Oracle's JDeveloper, which is included on the accompanying CD in a starter version).

Of course, readers will have to wait and see if the more object-oriented approach will displace the older relational model. (The authors put in their proverbial two pence on the future of Java database standards.) In the meantime, programmers are lucky to have so many options when it comes to working with databases in Java. But until this book, information on standards beyond JDBC was in scarce supply. Understanding SQL and Java Together fills a valuable need by cataloging and describing all of today's advanced Java database standards, a valuable combination that readers won't likely find anywhere else. --Richard Dragan,

Topics covered: Overview of Java used with databases; refresher course on basic Java, SQL tutorial, Java Database Connectivity (JDBC) v. 1.0/v. 2.0 APIs (connecting to JDBC data sources, using result sets), SQLJ Part 0 and embedded SQL, the SQLJ Part 0 translator and runtime classes, SQLJ Part 1: Java stored procedures and deployment tips for JAR files; tutorial for SQL User Defined Types (UDTs), the SQL:1999 standard, structured types, typed tables and table hierarchies; SQL Part 2: accessing UDTs from within Java; Java Blend and ODMG Java database mappings, persisting Java objects, database schemas and Java objects, review of GUI-based Java tools (PowerJ, JDeveloper and Visual J++), future directions for Java database standards, and syntax reference for SQLJ Part 0, 1 and 2.

About the Author

Jim Melton is editor of all parts of ISO/IEC 9075 (SQL) and representative for database standards at Oracle Corporation. Since 1986, he has been his company's representative to the ANSI NCITS Technical Committee H2 for Database and a U.S. representative to ISO/IEC JTCI/SC32/WG3. He was the editor of SQL-92 and the recently published SQL:1999 suite of standards and is increasingly involved in standards related to querying XML and integrating SQL and XML. He is also the editor of the next generation of the SQL standards, currently under development, as well as an editor for the Functions and Operators specification currently being developed by the W3C XML Query Working Group. He is the author of several SQL books. Andrew Eisenberg is Manager of Standards and Consortia at Progress Software Corporation. He represents his company on the ANSI NCITS Technical Committee H2 for Database, the W3C XML Query Work Group, and the Transaction Processing Performance Council. He has represented prior companies on the OMG and the SQLJ informal group.

Customer reviews

There are no customer reviews yet.
Share your thoughts with other customers

Most helpful customer reviews on 3.0 out of 5 stars 4 reviews
Amazon Customer
1.0 out of 5 starsNot a book for a coder.
19 December 2000 - Published on
8 people found this helpful.
Steven Kerrick
5.0 out of 5 starsHighly recommended
19 September 2000 - Published on
6 people found this helpful.
doug ison
1.0 out of 5 starsWhy are there C code examples in a Java book
21 October 2000 - Published on
9 people found this helpful.
Roald Andresen
5.0 out of 5 starsAn excellent all-in-one-book
8 June 2000 - Published on
16 people found this helpful.

Where's My Stuff?

Delivery and Returns

Need Help?