SN#9957 Best Uses of Java[TM] Technology Stored Procedures and Oracle PL/SQL

SN#9957 Best Uses of Java[TM] Technology Stored Procedures and Oracle PL/SQL

Post by John J. McLaughli » Wed, 04 Jun 2003 00:30:44



SYSTEM NEWS FOR SUN USERS
Vol 63 Issue 4 2003-05-26  Article 9957 from section "Oracle"

     How to Get Unlimited Usage Patterns by Running Java Programming Language Code in the Database

     Stored procedures allow a set of database operations to be processed in one
     call. Java[TM] technology stored procedures use procedural logic
     encapsulating multiple SQL statements that run within the database and are
     invoked in one call, thereby avoiding multiple network round trips.

     Oracle strategy is to enhance both languages and make them interoperate.
     The Oracle white paper "Unleashing the Power of Java Stored Procedures"
     discusses when it is best to use Oracle PL/SQL or Java technology stored
     procedures. Which one to use depends on skills of programmers at a company
     and application requirements. The following recommendations are offered:

     - Use PL/SQL for SQL operations and access to all database types and
       objects. PL/SQL was originally designed for stored procedures and
       functions. Compiled PL/SQL packages can be moved to different platforms.
       It is well suited for encapsulating SQL operations with procedural logic
       and for manipulating all database object types.

     - Use Java technology when you already have the skill set; use it for SQL
       operations and for leveraging and interacting with the worlds of Web
       Services, XML, the Java[TM] 2 Platform, Enterprise Edition (J2EE[TM]) and
       Java technology. As opposed to PL/SQL, Java technology requires declaring
       exceptions that can be thrown by methods in any class, thereby making
       Java technology stored procedures more robust. All major database vendors
       provide Java technology support in their databases. Java technology
       programming in the database allows implementing more complex database
       logic than PL/SQL and extends database functionality.

     Common usage patterns of Java technology stored procedures are covered in
     the white paper, as well as the support Oracle furnishes for the Java[TM]
     DataBase Connectivity (JDBC[TM]) 2.0 API (a standard and common mechanism
     for accessing SQL data from the Java platform). The white paper includes
     code and illustrations.

Details at http://sun.systemnews.com/63/4/Oracle/index.shtml#9957

Have a custom version of 'System News for Sun Users' delivered to you
via email each week in PDF, text or HTML.  Only the sections that you
select will be included in your copy of the news magazine.  Subscribe at
http://sun.systemnews.com/subscribe
(c) 2003 System News, Inc.   http://www.systemnews.com

 
 
 

1. SN#10136 James Gosling and Others Showcase Variety of Uses of Java[TM] Technology

SYSTEM NEWS FOR SUN USERS
Vol 64 Issue 2 2003-06-09  Article 10136 from section "JavaOne"

        James Gosling's keynote talk at the JavaOne[SM] 2003 Developer
        Conference showcased how the use of Java[TM] technology has grown since
        the programming language was released in 1995. Highlights include the
        Mars Rover from the Jet Propulsion Labs, automation uses such as robots,
        and a cell phone enabled with Java technology and GPS.

        The Mars Rover

        Gosling and Dan Dvorak, deputy architect of the Mission Data System with
        Jet Propulsion Labs (JPL) demonstrated a Mars Rover exploration
        prototype using RTSJ (Real Time Specification for Java technology) to
        control rover mobility.

        Java Technology Automation

        Jim Wright, Solutions Architect with Sun, demonstrated how industrial
        Java technology powers robots, sensors and other manufacturing
        operations. The automation initiative was developed by Sun, aJile
        Systems, Cyberonix and Mitsubishi Electric Automation to extend Sun's
        Smart Station technology to the factory.

        Jentro GPS

        Ansgar Hempel, Vice President with Jentro, demonstrated Jentro's
        end-to-end cell phone-based navigation system giving access to Global
        Positioning System (GPS) data through a Java technology enabled cell phone.

        "Since the release of Java (programming language) in 1995, seeing what
        people are doing with it blows my mind," said James Gosling, vice
        president of Sun Labs and Sun Fellow. "After eight short years, the Java
        technology Community is millions strong, with the best and brightest
        minds collaborating and contributing to the cool technologies of the
        future. So where will Java (technology) be in the next eight years? That
        can only be answered by the developers who have made it what it is today
        and wherever the road takes us will be an exciting ride."

Details at http://sun.systemnews.com/64/2/JavaOne/index.shtml#10136

Have a custom version of 'System News for Sun Users' delivered to you
via email each week in PDF, text or HTML.  Only the sections that you
select will be included in your copy of the news magazine.  Subscribe at
http://sun.systemnews.com/subscribe
(c) 2003 System News, Inc.   http://www.systemnews.com

2. Canadian CIC Codes

3. SN#10041 New Game Technologies Group at Sun to Advance Java[TM] Technology in Online Gaming

4. Accessing internal info in vi

5. SN#9839 Using Bluetooth with Java[TM] Technology and Learning about Application Logging

6. How do I transfer My documents to compact flash?

7. SN#8954 How Java[TM] Technology is Used on Wall Street

8. Rasmol files anyone?

9. SN#10207 "Using AES with Java[TM] Technology"

10. SN#10132 Sun Debuts java.net Web Site for Java[TM] Technology

11. SN#10149 ISVs Showcase Solutions Built on Java[TM] technology and Sun[TM] Open Net Environment

12. SN#9402 Java[TM] Specification Request 127: JavaServer[TM] Faces Technology

13. SN#9474 Sun and IDA Launch Java[TM] Tarik ONE (Java[TM] TONE)