Home arrow Oracle arrow Extending PL/SQL with Java Libraries

Extending PL/SQL with Java Libraries

If you are looking for a way to extend stored programs with Java, look no further. This article, the first of two parts, is excerpted from chapter five of Expert Oracle PL/SQL, written by Ron Hardman and Michael McLaughlin (McGraw-Hill/Osborne, 2005; ISBN: 0072261943).

  1. Extending PL/SQL with Java Libraries
  2. Java Architecture in Oracle
  3. Oracle JDBC Connection Types
  4. Building Java Class Libraries in Oracle
  5. Building Internal Server Java Functions
By: McGraw-Hill/Osborne
Rating: starstarstarstarstar / 8
January 12, 2006

print this article



Extending stored programs with Java is a very popular solution. PL/SQL is essential to the process of stored Java class libraries. PL/SQL wraps access to the Java class libraries, which means PL/SQL becomes the gate through which data moves to and from Java stored objects.

This chapter stands independent of others in the book since all its content works in currently supported versions of the Oracle database. We’ll be covering the following topics:

  • Java architecture in Oracle
  • Oracle JDBC connection types

    • Client-side driver, or JDBC thin driver

    • Oracle call interface driver, or middle-tier thick driver

    • Oracle server-side internal driver, or server-tier thick driver

  • Building Java class libraries in Oracle

    • Building internal server Java functions

    • Building internal server Java procedures

    • Building internal server Java objects

    • Troubleshooting Java class library build, load, drop, and use

  • Mapping Oracle types

This chapter introduces you to the big picture of thehows small boxes ne Oracle Java architecture. After explaining the architecture, you’ll see how to develop and extend Java components as application programming components.

Why Would I Use This?

We’ll use PL/SQL to interface between stored Java class libraries and other PL/SQL stored and anonymous block programs. We’ll also map native and user-defined data types between Oracle and Java to write effective interfaces and support external Java Server Pages (JSPs).

>>> More Oracle Articles          >>> More By McGraw-Hill/Osborne

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates


Dev Shed Tutorial Topics: