Jim Melton Knihy

With the growth of Java and the rise of database-powered Web applications, the need for integrating Java with SQL has become essential. This resource offers comprehensive coverage of the techniques necessary to effectively combine these two technologies, providing both programming and career benefits. It thoroughly examines standards for integrating SQL and Java, demonstrating how to leverage their features to write efficient code that supports Java access to SQL data in various ways. Readers will gain a deep understanding of the relationship between SQL and Java, enabling them to write both static and dynamic SQL programs, merge Java code with SQL databases, and employ other data management techniques as needed. Key topics include the technologies for using SQL and Java together, such as JDBC, Java Blend, and SQLJ, as well as how to embed SQL code in Java and utilize Java's capabilities to compile code for specific DBMS. Additionally, it explains storing and invoking Java routines in an SQL database and how to store Java objects for seamless interchange among application layers. Dynamic SQL access techniques using JDBC and effective combinations of static and dynamic SQL are also covered. A CD-ROM is included, featuring Oracle's JDeveloper, Sybase's Adaptive Server Anywhere, Informix's Cloudscape, the complete database schema, and the full text of most examples.

This book serves as an essential resource for transitioning from SQL-92 to SQL-1999, offering much more than a simple bridge. Authored by SQL experts Jim Melton and Alan Simon, it provides a thorough and practical overview of SQL's latest version, detailing how to effectively implement its features. Catering to both novice and experienced users, the text covers the language's capabilities from basic to advanced levels, demonstrating how real applications utilize these features. The authors enhance understanding with engaging references to their custom database, available for download on the companion website. Key features include authoritative coverage from a team that includes the editor of the SQL-92 and SQL:1999 standards, a general introduction to SQL that outlines its components, history, and significance in computer languages, and an exploration of SQL:1999's advanced features such as value expressions, predicates, and active database support. Additionally, it addresses critical issues for programmers connecting applications to SQL databases, offers troubleshooting and internationalization guidance, and anticipates future changes in SQL. Appendices cover database design, a complete SQL-1999 example, and the standardization process, making this a comprehensive resource for anyone looking to deepen their SQL knowledge.