August 2001
Intermediate to advanced
400 pages
9h 28m
English
Content preview from Java Programming with Oracle SQLJ
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.