- Paperback: 514 pages
- Publisher: Morgan Kaufmann Publishers In; Pap/Cdr edition (23 May 2000)
- Language English
- ISBN-10: 1558605622
- ISBN-13: 978-1558605626
- Product Dimensions: 23.3 x 18.8 x 2.9 cm
- Amazon Bestsellers Rank: 2,891,093 in Books (See Top 100 in Books)
- See Complete Table of Contents
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Amazon.co.uk Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Amazon.co.uk 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, amazon.com
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.
Product Description
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.
Inside This Book
(Learn More)
First Sentence
"routines, written in Java, you can ensure that the exact same semantics are provided in both places. The specification for invoking Java routines from SQL has been standardized, but not as part of the SQL standard; instead, it constitutes the first part of" Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
"routines, written in Java, you can ensure that the exact same semantics are provided in both places. The specification for invoking Java routines from SQL has been standardized, but not as part of the SQL standard; instead, it constitutes the first part of" Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
|
There are no customer reviews yet on Amazon U.K.
|
||||||||||||||||||||
|
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
3.0 out of 5 stars (4 customer reviews)
8 of 9 people found the following review helpful:
1.0 out of 5 stars
Not a book for a coder., 20 Dec 2000
By "eggcozy" - Published on Amazon.com
This review is from: Understanding Sql and Java Together: A Guide to Sqlj, Jdbc, and Related Technologies (The Morgan Kaufmann Series in Data Management Systems) (Paperback)
I purchased this book for an independent study and found it severely lacked pertinent information. The core of JDBC is the Java objects that assist you in accessing a database, but this book fails to provide a decent explanation of them. The first 2 chapters are filler on Java and SQL, which someone learning to access a database using Java should already know. If you don't know them, the coverage in this book is hardly sufficient. Descriptions of code examples or discussions leading up to the code examples were probably the biggest shortfalls of the book. There is so much going on underneath that this book fails to explain.
9 of 12 people found the following review helpful:
1.0 out of 5 stars
Why are there C code examples in a Java book, 21 Oct 2000
By doug ison - Published on Amazon.com
This review is from: Understanding Sql and Java Together: A Guide to Sqlj, Jdbc, and Related Technologies (The Morgan Kaufmann Series in Data Management Systems) (Paperback)
I found the the C code examples unbelievable in a book that says it's for Java. The SQL is not your standard JDBC SQL its PL/SQL style. I wish I hadn't opened the CD in the back so I could return it. A waste of time and money. Perhaps if you are a very advanced SQL person and have a lot of experience with Java this might be a helpful book, but then you wouldn't want this book either, nothing good here.
6 of 10 people found the following review helpful:
5.0 out of 5 stars
Highly recommended, 19 Sep 2000
By Steven Kerrick "Steve Kerrick" - Published on Amazon.com
This review is from: Understanding Sql and Java Together: A Guide to Sqlj, Jdbc, and Related Technologies (The Morgan Kaufmann Series in Data Management Systems) (Paperback)
Very excellent book. Here's why: 1. The book is readable without being verbose. 2. After every English explanation of a topic, there is a short code example. 3. The code examples show just what's relevant -- no fluff. 4. The authors tell you what topics they don't have space to cover in depth, and refer the reader to the appropriate sources.I found this book perfect for getting started with database access using Java.
Listmania!
Look for similar items by category
- Books > Computing & Internet > Computer Science > Information Systems > Information Retrieval
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Databases > Java & Databases
- Books > Computing & Internet > Programming > Languages > Java
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
