Oracle Database Programming using Java and Web Services (eBook)
1120 Seiten
Elsevier Science (Verlag)
978-0-08-052511-2 (ISBN)
* 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.
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.
Front Cover 1
Oracle Database Programming Using Java and Web Services 4
Copyright Page 5
Contents 8
Foreword 20
Preface 22
Introduction 26
Acknowledgments 32
Part I: Java in the Database 34
Chapter 1. Stored Procedures as Database Programming Model 36
1.1 Rationale for Stored Procedures 36
1.2 Obstacles to the Adoption of Stored Procedures 44
1.3 Languages for Stored Procedures 46
1.4 PL/SQL or Java 52
Chapter 2. OracleJVM: Under the Hood 56
2.1 Design Goals and Architecture 56
2.2 Java Memory Management 74
2.3 Security in OracleJVM 93
2.4 Java VM Life Cycle 113
2.5 Java Execution in the Database 114
2.6 The Native Java Compiler (NCOMP) 117
2.7 Conclusion 136
Chapter 3. Developing and Running Java in the Database 138
3.1 Developing Java in the Database 138
3.2 Turning Java in the Database into Stored Procedures 159
3.3 Mapping SQL and PL/SQL Types to/from Java Types 168
3.4 Invoking Java in the Database 240
3.5 Managing Java in the Database 260
Chapter 4. Pragmatic Applications Using Java in the Database 264
4.1 CNXO: Secure Credit Card Processing with Oracle and JSSE 264
4.2 Using J2EE and Java in the Database Together 272
4.3 JDBC Call-Out to Non-Oracle Databases 293
4.4 SAP Java Connector: Accessing the SAP System from the Oracle Database 301
4.5 Excel-like Expression Parser in the Database 310
Chapter 5. Database Scripting Using Non-Java Languages 320
5.1 Why Contemplate Non-Java Languages for the Database? 320
5.2 Database Scripting with OracleJVM—Just for Fun! 321
Part II. Java Persistence and Java SQL Data Access 350
Chapter 6. Introducing the JDBC Technology and Oracle’s Implementation 352
6.1 JDBC Primer 352
6.2 Overview of JDBC Specifications 358
6.3 Architecture and Packaging of Oracle JDBC Drivers 367
Chapter 7. URL, DataSource, Connection, and Statements 378
7.1 JDBC URL 378
7.2 DataSources 381
7.3 Connections and Connection Services 390
7.4 JDBC Statements and Oracle Extensions 460
Chapter 8. SQL Data Access and Manipulation 504
8.1 Key Metadata in JDBC 504
8.2 Manipulating Oracle Data Types with JDBC 512
8.3 Result Set Support in Oracle JDBC 587
8.4 RowSet 610
8.5 Conclusion 656
Chapter 9. JDBC Quality of Services and Best Practices 658
9.1 Transaction Services 658
9.2 Security Services 675
9.3 Tips and Best Practices 690
9.4 Conclusion 699
Part III: Oracle Database Programming with SQLJ 700
Chapter 10. Introducing the SQLJ Technology and Oracle’s Implementation 702
10.1 Overview 702
10.2 SQLJ in the Database 675
Chapter 11. The SQLJ Language and Oracle Extensions 734
11.1 Declaration Statements 734
11.2 Executable Statements 763
11.3 Expressions in SQLJ 777
11.4 Interoperability: Using SQLJ and JDBC Together 781
11.5 Conclusion 786
Chapter 12. SQLJ Data Access and Best Practices 788
12.1 Manipulating Oracle SQL and PL/SQL Data Types with SQLJ 788
12.2 SQLJ Best Practices 844
12.3 Conclusion 846
Part IV: Oracle Database Programming with JPublisher 848
Chapter 13. Abridged Oracle JPublisher 850
13.1 Why JPublisher? 850
13.2 Overview 852
13.3 JPublisher In Action 882
13.4 Conclusion 906
Part V: Programming the Oracle Database with Web Services 908
Chapter 14. Web Services and SOA for DBA, Data Architects, and Others 912
14.1 Web Services 101 912
14.2 Service-Oriented Architecture (SOA): The Bigger Picture 923
14.3 Conclusion 930
Chapter 15. Database as Web Services Provider Service 932
15.1 Rationales for Database as Web Services Provider 932
15.2 How Does Database as Web Services 932
15.3 Turning Oracle Database Functionality into Web Services 938
15.4 Assembling Database Web Services Using the Command-Line Tool 958
15.5 Data Type Restrictions 975
15.6 Conclusion 976
Chapter 16. Database as Web Services Consumer 978
16.1 Rationales for Database as Web Services Consumer 978
16.2 How Database as Web Services Consumer Works 979
16.3 Turning Your Oracle Database into a Web Service Consumer 987
16.4 Database Web Services Call-Out Samples 992
16.5 Conclusion 997
Part VI: Putting Everything Together 998
Chapter 17. 360-Degree Programming the Oracle Database 1000
17.1 TECSIS Systems: Custom Enterprise Integration Framework 1001
17.2 Oracle interMedia 1007
17.3 British Columbia: Online Corporate Registration 1026
17.4 Information Retrieval Using Oracle Text 1042
17.5 Database-Driven Content Management System 1061
17.6 Conclusion 1091
Index 1092
Erscheint lt. Verlag | 8.4.2011 |
---|---|
Sprache | englisch |
Themenwelt | Sachbuch/Ratgeber |
Informatik ► Datenbanken ► Oracle | |
ISBN-10 | 0-08-052511-3 / 0080525113 |
ISBN-13 | 978-0-08-052511-2 / 9780080525112 |
Haben Sie eine Frage zum Produkt? |
![PDF](/img/icon_pdf_big.jpg)
Größe: 14,9 MB
Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich