Java programming with Oracle JDBC

Viac o knihe

JDBC is essential for accessing relational databases, and Oracle is a leading platform in this realm. This book by Donald Bales effectively combines these technologies, guiding you through leveraging Oracle's JDBC implementation. It begins with the crucial process of establishing database connections, a challenging area for newcomers. Donald provides detailed explanations and examples for making connections from applications, applets, Servlets, and even Java programs running within the database. The book thoroughly covers JDBC's relational SQL features, including issuing SQL statements and retrieving results. You'll learn to handle large, streaming data types like BLOBs, CLOBs, and BFILEs, and interface with PL/SQL, Oracle's built-in programming language. For those utilizing Oracle's newer capabilities to create object tables and user-defined data types, Don offers comprehensive insights. Additionally, you'll discover how to use JPublisher and JDBC to interact with Oracle database objects in Java programs, as well as access nested tables and arrays. The book concludes with essential discussions on transaction management, locking, concurrency, and performance—key topics for any professional JDBC programmer. If you develop Java applications for Oracle databases, this resource is indispensable.