Oracle-L: RE: Java Oracle howto docs

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Sun, 18 May 2003 16:27:47 -0800
Message-ID: <F001.0059C22C.20030518162747@fatcity.com>

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). Received on Sun May 18 2003 - 19:27:47 CDT