Jaeda Goodman Knihy

This book focuses on utilizing Java within the Oracle database, emphasizing real-world applications for developers. It explores when to use Java from a performance standpoint, including benchmarks, and highlights scenarios where Java offers functionality that PL/SQL cannot. The text demonstrates Java's ability to access external system resources, such as operating system commands and network sockets, and leverages Java Utilities for messaging and graphics generation. For instance, it details an application that creates a pie chart image from a query and distributes it via JavaMail. Java complements PL/SQL's programming capabilities, allowing for the handling of complex data types and task scheduling alongside Java's file transfer and compression features. The book is structured into four sections: the first provides a rapid Java tutorial for PL/SQL programmers; the second focuses on database access using JDBC and SQLJ, detailing the conversion between Java and SQL data types; the third section applies learned concepts to practical problem-solving with Java and PL/SQL; and the fourth examines performance issues, including Java application tuning and SQL tuning, guiding readers on when to choose between Java and PL/SQL for database operations.