Oracle-L: RE: Java Oracle howto docs

From: <Peter.McLarty_at_mincom.com>
Date: Sun, 18 May 2003 21:46:49 -0800
Message-ID: <F001.0059C344.20030518214649@fatcity.com>

I will add that if you want to do XML in the database then go Java in both Layers the XML parser that is within the database is in Java. Also as Tim said Java stored procedures are great for manipulating strings, I have found it useful for dissecting a CLOB that was CSV data for example. I could easily pull the row of data in the CLOB apart with a Java program and then utilise that information elsewhere in the database. There is also a ODTUG list that is dedicated to Java that can assist as well, A number of Oracle staff are hanging out there so you can sometimes get it from the horses mouth, so to speak.

Cheers

Peter McLarty               E-mail: Peter.Mclarty_at_mincom.com
Technical Consultant        WWW: http://www.mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461
Brisbane,  Australia        Mobile: +61 (0)402 094 238
                            Facsimile: +61 (0)7 3303 3048
=================================================

A great pleasure in life is doing what people say you cannot do.

Walter Bagehot (1826-1877 British Economist)
Mincom "The People, The Experience, The Vision"

This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.

DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> Sent by: root_at_fatcity.com
19-05-2003 10:27 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: Java Oracle howto docs


Melissa
     My company has made a strong commitment to Java. The following are

the
few points I have been able to glean from the subject:

To paraphrase Tim, nothing beats PL/SQL at what PL/SQL was designed to do. It is highly optimized for database actions.
Most people prefer to run Java in the Application Server. I can't find that much enthusiasm for moving Java into the database itself as a stored procedure. Since you've moved the Java program to the server level, the database interaction is much better than a program that executes on the client. Also your Java programmers seem much more comfortable working in the app server. I suspect this is because all the tools that support Java development assume an app server environment. I haven't seen any white papers on the above. My suspicion is that 5 years ago Oracle was afraid that 1) PL/SQL was considered obsolete since it lacks some of the OOP features that Java has, 2) Oracle wanted to be a significant player in the Web programming arena, and in the early days having Java execute inside the database seemed to get them there quickly. Now that Oracle is a strong player in the app server market, there is less reason for Oracle to continue to push the Java interface. Again, these are mostly my guesses from what I've observed, so maybe someone with the inside scoop will post.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>

-----Original Message-----

Sent: Sunday, May 18, 2003 10:52 AM
To: Multiple recipients of list ORACLE-L

Still hoping for someone's input!

I'm interested in finding some white papers or documents on the best way to
use Oracle 9iR2 and Java. Is it better to run the loadjava and build call specs for the programs, or is it better to have the java run on the application server. Are PL/SQL stored procedures better to use then building Java Stored Procedures?

I've read some of the Oracle documentation, but wanted opinions from people
who have actually implemented Java and Oracle to see if following the Oracle
recommendations is best.

Any Help is Appreciated

TIA M.Godlewski

Do you Yahoo!?
The <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com> New Yahoo! Search - Faster. Easier. Bingo.

Do you Yahoo!?
The New <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com> Yahoo! Search - Faster. Easier. Bingo.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Peter.McLarty_at_mincom.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message