Java 与 PL_SQL集成( 35 ).pptVIP

Introduction Why do programmers use stored procedures? Stored procedures are able to process a set of operations in a call and they have better performance of data-intensive operations. Starting with Oracle8i, Oracle supports two stored procedures, PL/SQL stored procedures and Java stored procedures PL/SQL Stored procedures Before Oracle8i, PL/SQL is the only language that can be used in the database. PL/SQL is the procedural language extension to SQL and it encapsulates SQL statements in procedural logic and execute all database object types. Java Stored procedures Starting with Oracle8i, Oracle supports Java in the database. Java stored procedures also can encapsulate SQL statements that run within the database via procedural logic and it can avoid overhead of networks. Terminology of PL/SQL vs. Java Terminology of PL/SQL vs. Java Terminology of PL/SQL vs. Java Terminology of PL/SQL vs. Java How to develop Java Stored procedures Step 1: To create a new Java class or reuse an existing one that meet your need. Oracle provides JDeveloper and supports many other Java IDEs such as Symantecs Visual Café, and Borlands Jbuilder. How to develop Java Stored procedures Step 2: To load Java program into database to be stored as Java scheme objects. The program can load Java in one of the following forms: Java source files and compiled in the database. compiled outside the database and be loaded as .class or .jar files loaded as Java resource files How to develop Java Stored procedures Two method to load Java: Using Create Java statements to load Java source, binaries, or resource files into the database from a binary file on the operating system level or from a LOB column in the database. Using loadjava utility to load Java programs into the database. How to develop Java Stored procedures Step 3: Publish the Java codes. Three issues should be addressed before publishing Java classes(Oracle Technical White Paper, 1999): Mapping SQL types to Java types. Mapping S