Java Programming with Oracle SQLJ
O'Reilly Media (Verlag)
978-0-596-00087-5 (ISBN)
- Titel ist leider vergriffen;
keine Neuauflage - Artikel merken
Layered on top of JDBC, SQLJ simplifies database programming. Rather than make several calls to the JDBC API just to execute a simple SQL statement, SQLJ executes that statement simply by embedding it within the Java code. In this book, Jason Price explains SQLJ programming from a task-oriented point of view. You'll learn how to: embed queries and other SQL statements within Java programs; deploy SQLJ code not only on client machines, but also to JServer-Oracle's Java engine built into the database; use advanced techniques for working with collections, streams, large objects, and database objects, all without leaving the comfort of the SQLJ environment; and tune SQLJ programs for maximum performance.
Jason Price is currently employed as a product manager with Oracle Corporation. He has contributed to many products at Oracle, including the database server, the application server, and several CRM applications. Prior to working at Oracle, he was employed as a consultant at Logica PLC in London, a systems integration and technical consulting firm. He is a certified Oracle DBA and Application Developer, and has over ten years of experience in the software industry. When Jason is not working or writing, he enjoys walking, running, and working out. Jason holds a Bachelor of Science degree (with honors) in Physics from the University of Bristol, England. Jason currently resides in California.
Preface. 1. Introduction Comparing SQL J and JDBC SQL J Components Requirements for Using SQL J Configuring Your Environment A "Hello World" Program for SQL J The sqlj Command-Line Utility Oracle JDeveloper. 2. Relational Databases, SQL, and PL/SQL Relational Databases Structured Query Language (SQL) PL/SQL. 3. Fundamental SQL J Programming SQL J Programs Database Connections Simple SQL J Statements Transactions Queries That Return Multiple Rows Nested Cursors PL/SQL in SQL J. 4. Database Objects Defining Object Types Object Columns and Object Tables Creating Custom Classes Accessing Database Objects Using SQL J Object Identifiers and REF Columns. 5. Collections VARRAYs Nested Tables Storing an Object Type in a Collection Collection Custom Classes Accessing Collections Using SQL J. 6. Deploying SQL J in the JServer Understanding the Oracle JServer Designing Server-Based SQL J Programs Translating SQLJ Programs Loading SQLJ Programs into the Database Publishing Class Methods Using Database Triggers Using JDeveloper to Translate and Load SQL J Programs Using Enterprise JavaBeans. 7. Large Objects The Example Files and Directories Large Objects (LOBs) LONG and LONG RAW Columns. 8. Contexts and Multithreading Connection Contexts Execution Contexts Multithreaded SQL J Programs. 9. Advanced Transaction Control Transaction Processing Problems Transaction Isolation Levels The SET TRANSACTION Statement A Transaction Isolation Level Example. 10. Performance Tuning Row Prefetching Batch Processing Tuning SQL Statements The Oracle Optimizer. 11. Combining JDBC, SQL J, and Dynamic SQL Static and Dynamic SQL Sharing Database Connections SQL J Iterators and JDBC Result Sets. A. Java and Oracle Type Mappings. B. Oracle Java Utilities Reference. C. SQL J in Applets, Servlets, and JavaServer Pages. Index
| Erscheint lt. Verlag | 2.10.2001 |
|---|---|
| Zusatzinfo | Illustrations |
| Verlagsort | Sebastopol |
| Sprache | englisch |
| Maße | 178 x 234 mm |
| Gewicht | 650 g |
| Einbandart | kartoniert |
| Themenwelt | Informatik ► Datenbanken ► Oracle |
| Informatik ► Programmiersprachen / -werkzeuge ► Java | |
| Mathematik / Informatik ► Informatik ► Web / Internet | |
| ISBN-10 | 0-596-00087-1 / 0596000871 |
| ISBN-13 | 978-0-596-00087-5 / 9780596000875 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
