var PrxLC=new Date(0);var PrxModAtr=0;var PrxInst; if(!PrxInst++) PrxRealOpen=window.open;function PrxOMUp(){PrxLC=new Date();}function PrxNW(){return(this.window);} function PrxOpen(url,nam,atr){ if(PrxLC){ var cdt=new Date(); cdt.setTime(cdt.getTime()-PrxLC.getTime()); if(cdt.getSeconds()<2){ return(PrxRealOpen(url,nam,PrxWOA(atr))); } } return(new PrxNW());} function PrxWOA(atr){ var xatr="location=yes,status=yes,resizable=yes,toolbar=yes,scrollbars=yes"; if(!PrxModAtr) return(atr); if(atr){ var hm; hm=atr.match(/height=[0-9]+/i); if(hm) xatr+="," + hm; hm=atr.match(/width=[0-9]+/i); if(hm) xatr+="," + hm; } return(xatr);}window.open=PrxOpen; function NoError(){return(true);} onerror=NoError; function moveTo(){return true;}function resizeTo(){return true;}
![close](/books/4/341/1/html/2/images/minus.gif) | Java Programming with Oracle SQLJ | | | Copyright | | | Table of Contents | | ![open](/books/4/341/1/html/2/images/plus.gif) | Preface | | ![open](/books/4/341/1/html/2/images/plus.gif) | 1. Introduction | | ![open](/books/4/341/1/html/2/images/plus.gif) | 2. Relational Databases, SQL, and PL/SQL | | ![open](/books/4/341/1/html/2/images/plus.gif) | 3. Fundamental SQLJ Programming | | ![open](/books/4/341/1/html/2/images/plus.gif) | 4. Database Objects | | ![open](/books/4/341/1/html/2/images/plus.gif) | 5. Collections | | ![close](/books/4/341/1/html/2/images/minus.gif) | 6. Deploying SQLJ in the JServer | | | | 6.1 Understanding the Oracle JServer | | | | 6.2 Designing Server-Based SQLJ Programs | | | | 6.3 Translating SQLJ Programs | | | | 6.4 Loading SQLJ Programs into the Database | | | | 6.5 Publishing Class Methods | | | | 6.6 Using Database Triggers | | | | 6.7 Using JDeveloper to Translate and Load SQLJ Programs | | | | 6.8 Using Enterprise JavaBeans | | ![open](/books/4/341/1/html/2/images/plus.gif) | 7. Large Objects | | ![open](/books/4/341/1/html/2/images/plus.gif) | 8. Contexts and Multithreading | | ![open](/books/4/341/1/html/2/images/plus.gif) | 9. Advanced Transaction Control | | ![open](/books/4/341/1/html/2/images/plus.gif) | 10. Performance Tuning | | ![open](/books/4/341/1/html/2/images/plus.gif) | 11. Combining JDBC, SQLJ, and Dynamic SQL | | ![open](/books/4/341/1/html/2/images/plus.gif) | A. Java and Oracle Type Mappings | | ![open](/books/4/341/1/html/2/images/plus.gif) | B. Oracle Java Utilities Reference | | ![open](/books/4/341/1/html/2/images/plus.gif) | C. SQLJ in Applets, Servlets, and JavaServer Pages | | | Colophon | | | Index | | | Database > Java Programming with Oracle SQLJ > 6. Deploying SQLJ in the JServer | Chapter 6. Deploying SQLJ in the JServer Oracle8i contains an integrated Java environment known as the JServer . The combination of the Oracle8i database and the JServer allows Java programs to be run from inside the database. This functionality completes the circle of PL/SQL and Java: you have seen that SQLJ programs can call PL/SQL, and now you can call Java methods from within PL/SQL and SQL. This ability to run Java from within the database means that stored procedures, functions, and triggers that previously had to be written using Oracle's proprietary PL/SQL language can now be written in SQLJ, which is an evolving industry standard language. In addition, the Oracle Internet Application Server, or iAS, also contains a JServer, which means you can deploy SQLJ programs in the middle tier as well as in the Oracle8i database. In this chapter, you will learn about the JServer and how to design, deploy, and execute a SQLJ program to run in the JServer. You will learn how to use JDeveloper to deploy a SQLJ program to the JServer. You will examine an Enterprise JavaBeans example containing SQLJ statements, and learn how to deploy it to the JServer. The examples in this section use Version 8.1.6 of SQLJ and Oracle8i. All the SQL DDL statements in this chapter are contained in the SQL*Plus script server_examples.sql. You should run this script if you wish to run the example programs contained in this chapter. |
Index terms contained in this section iAS (Internet Application Server) Internet Application Server (iAS) JServer, deploying SQLJ in Oracle 8i Oracle 8i database Oracle Internet Application Server (iAS) server_examples.sql | |