Understanding SQL and Java together

1st Edition

By Jim Melton

ISBN: 1558605622
Publisher: Morgan Kaufmann
Year: 2000
Pages: 514

About This Book

With the growth of Java and the rise of database-powered Web applications, the need to use Java with SQL is clear. Until now, authoritative coverage of the techniques available to meet these challenges and reap their benefits-both programming and career benefits-didn't exist.Understanding SQL and Java Together examines all the standards for combining SQL and Java. It shows you exactly how to use their features to write efficient and effective code supporting Java access to SQL data in a variety of ways. You'll gain a thorough understanding of the relationship between SQL and Java, which will allow you to write static and dynamic SQL programs in Java, merge Java code with SQL databases and SQL code, and use other data management techniques wherever appropriate. * Covers all the technologies for using SQL and Java together, including JDBC, Java Blend, and SQLJ Parts 0, 1, and 2* Explains how to embed SQL code in Java and take advantage of Java's ability to compile that code for a specific DBMS* Explains how to store and invoke Java routines in an SQL database-and how to store Java objects in an SQL database for seamless interchange among application layers* Covers dynamic SQL access techniques using JDBC and advantageous ways to combine static and dynamic SQL* Comes with a CD-ROM containing Oracle's JDeveloper , Sybase's Adaptive Server Anywhere, Informix's Cloudscape, the complete database schema, and the complete text of most of the examples

Product Details

Publisher Morgan Kaufmann
Publication date January 1, 2000
Language English
Print length 514 pages
ISBN-10 1558605622
ISBN-13 978-1558605626
Item Weight 2.1 pounds

Editorial Reviews

Editorial Review

Amazon.com ReviewDatabase vendors like Oracle and Sybase have signed on quickly 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 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 for versions 1.0 and 2.0.) The real focus of this book is on SQLJ, which really comprises three standards. SQLJ Part 0 is the easiest to understand, as it supports embedded SQL calls within Java code. Next comes SQLJ Part 1, by which 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.) 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 for versions 1.0 and 2.0.) The real focus of this book is on SQLJ, which really comprises three standards. SQLJ Part 0 is the easiest to understand, as it supports embedded SQL calls within Java code. Next comes SQLJ Part 1, by which 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 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 shipped in a starter version on the accompanying CD). Next, the authors look at SQL user-defined types (UDTs) and 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 shipped in a starter version on the accompanying CD). Of course, readers will have to wait and see if the more object-oriented approach wi
Shipping set per seller
Compare book + shipping totals for each offer
Seller-error returns
Returns accepted for seller errors. Ask the seller about change-of-mind returns
Partner purchases
MedicalBook.online handles payment, shipping and returns for its orders
Email Support
[email protected] for buyers and sellers