Oracle Database Programming using Java and Web Services.
Title:
Oracle Database Programming using Java and Web Services.
Author:
Mensah, Kuassi.
ISBN:
9780080525112
Personal Author:
Edition:
1st ed.
Physical Description:
1 online resource (1121 pages)
Contents:
Front Cover -- Oracle Database Programming Using Java and Web Services -- Copyright Page -- Contents -- Foreword -- Preface -- Introduction -- Acknowledgments -- Part I: Java in the Database -- Chapter 1. Stored Procedures as Database Programming Model -- 1.1 Rationale for Stored Procedures -- 1.2 Obstacles to the Adoption of Stored Procedures -- 1.3 Languages for Stored Procedures -- 1.4 PL/SQL or Java -- Chapter 2. OracleJVM: Under the Hood -- 2.1 Design Goals and Architecture -- 2.2 Java Memory Management -- 2.3 Security in OracleJVM -- 2.4 Java VM Life Cycle -- 2.5 Java Execution in the Database -- 2.6 The Native Java Compiler (NCOMP) -- 2.7 Conclusion -- Chapter 3. Developing and Running Java in the Database -- 3.1 Developing Java in the Database -- 3.2 Turning Java in the Database into Stored Procedures -- 3.3 Mapping SQL and PL/SQL Types to/from Java Types -- 3.4 Invoking Java in the Database -- 3.5 Managing Java in the Database -- Chapter 4. Pragmatic Applications Using Java in the Database -- 4.1 CNXO: Secure Credit Card Processing with Oracle and JSSE -- 4.2 Using J2EE and Java in the Database Together -- 4.3 JDBC Call-Out to Non-Oracle Databases -- 4.4 SAP Java Connector: Accessing the SAP System from the Oracle Database -- 4.5 Excel-like Expression Parser in the Database -- Chapter 5. Database Scripting Using Non-Java Languages -- 5.1 Why Contemplate Non-Java Languages for the Database? -- 5.2 Database Scripting with OracleJVM-Just for Fun! -- Part II. Java Persistence and Java SQL Data Access -- Chapter 6. Introducing the JDBC Technology and Oracle's Implementation -- 6.1 JDBC Primer -- 6.2 Overview of JDBC Specifications -- 6.3 Architecture and Packaging of Oracle JDBC Drivers -- Chapter 7. URL, DataSource, Connection, and Statements -- 7.1 JDBC URL -- 7.2 DataSources -- 7.3 Connections and Connection Services.
7.4 JDBC Statements and Oracle Extensions -- Chapter 8. SQL Data Access and Manipulation -- 8.1 Key Metadata in JDBC -- 8.2 Manipulating Oracle Data Types with JDBC -- 8.3 Result Set Support in Oracle JDBC -- 8.4 RowSet -- 8.5 Conclusion -- Chapter 9. JDBC Quality of Services and Best Practices -- 9.1 Transaction Services -- 9.2 Security Services -- 9.3 Tips and Best Practices -- 9.4 Conclusion -- Part III: Oracle Database Programming with SQLJ -- Chapter 10. Introducing the SQLJ Technology and Oracle's Implementation -- 10.1 Overview -- 10.2 SQLJ in the Database -- Chapter 11. The SQLJ Language and Oracle Extensions -- 11.1 Declaration Statements -- 11.2 Executable Statements -- 11.3 Expressions in SQLJ -- 11.4 Interoperability: Using SQLJ and JDBC Together -- 11.5 Conclusion -- Chapter 12. SQLJ Data Access and Best Practices -- 12.1 Manipulating Oracle SQL and PL/SQL Data Types with SQLJ -- 12.2 SQLJ Best Practices -- 12.3 Conclusion -- Part IV: Oracle Database Programming with JPublisher -- Chapter 13. Abridged Oracle JPublisher -- 13.1 Why JPublisher? -- 13.2 Overview -- 13.3 JPublisher In Action -- 13.4 Conclusion -- Part V: Programming the Oracle Database with Web Services -- Chapter 14. Web Services and SOA for DBA, Data Architects, and Others -- 14.1 Web Services 101 -- 14.2 Service-Oriented Architecture (SOA): The Bigger Picture -- 14.3 Conclusion -- Chapter 15. Database as Web Services Provider Service -- 15.1 Rationales for Database as Web Services Provider -- 15.2 How Does Database as Web Services -- 15.3 Turning Oracle Database Functionality into Web Services -- 15.4 Assembling Database Web Services Using the Command-Line Tool -- 15.5 Data Type Restrictions -- 15.6 Conclusion -- Chapter 16. Database as Web Services Consumer -- 16.1 Rationales for Database as Web Services Consumer -- 16.2 How Database as Web Services Consumer Works.
16.3 Turning Your Oracle Database into a Web Service Consumer -- 16.4 Database Web Services Call-Out Samples -- 16.5 Conclusion -- Part VI: Putting Everything Together -- Chapter 17. 360-Degree Programming the Oracle Database -- 17.1 TECSIS Systems: Custom Enterprise Integration Framework -- 17.2 Oracle interMedia -- 17.3 British Columbia: Online Corporate Registration -- 17.4 Information Retrieval Using Oracle Text -- 17.5 Database-Driven Content Management System -- 17.6 Conclusion -- Index.
Abstract:
The traditional division of labor between the database (which only stores and manages SQL and XML data for fast, easy data search and retrieval) and the application server (which runs application or business logic, and presentation logic) is obsolete. Although the books primary focus is on programming the Oracle Database, the concepts and techniques provided apply to most RDBMS that support Java including Oracle, DB2, Sybase, MySQL, and PostgreSQL. This is the first book to cover new Java, JDBC, SQLJ, JPublisher and Web Services features in Oracle Database 10g Release 2 (the coverage starts with Oracle 9i Release 2). This book is a must-read for database developers audience (DBAs, database applications developers, data architects), Java developers (JDBC, SQLJ, J2EE, and OR Mapping frameworks), and to the emerging Web Services assemblers. * Describes pragmatic solutions, advanced database applications, as well as provision of a wealth of code samples * Addresses programming models which run within the database as well as programming models which run in middle-tier or client-tier against the database. * Discusses languages for stored procedures: when to use proprietary languages such as PL/SQL and when to use standard languages such as Java; also running non-Java scripting languages in the database * Describes the Java runtime in the Oracle database 10g (i.e., OracleJVM), its architecture, memory management, security management, threading, Java execution, the Native Compiler (i.e., NCOMP), how to make Java known to SQL and PL/SQL, data types mapping, how to call-out to external Web components, EJB components, ERP frameworks, and external databases. * Describes JDBC programming and the new Oracle JDBC 10g features, its advanced connection services (pooling, failover, load-balancing, and the fast database event notification mechanism) for clustered
databases (RAC) in Grid environments. * Describes SQLJ programming and the latest Oracle SQLJ 10g features , contrasting it with JDBC * Describes the latest Database Web services features, Web services concepts and Services Oriented Architecture (SOA) for DBA, the database as Web services provider and the database as Web services consumer. * Abridged coverage of JPublisher 10g, a versatile complement to JDBC, SQLJ and Database Web Services.
Local Note:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2017. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Genre:
Electronic Access:
Click to View