From oracle-l-bounce@freelists.org Fri Apr 2 10:14:02 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i32GE2222602 for ; Fri, 2 Apr 2004 10:14:02 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i32GE1o22596 for ; Fri, 2 Apr 2004 10:14:01 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8D8ED6343CE; Fri, 2 Apr 2004 11:09:51 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11853-56; Fri, 2 Apr 2004 11:09:51 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DBCEC6343C4; Fri, 2 Apr 2004 11:09:50 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 02 Apr 2004 11:08:46 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2D682634313 for ; Fri, 2 Apr 2004 11:08:46 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11853-33 for ; Fri, 2 Apr 2004 11:08:45 -0500 (EST) Received: from corporate.LifeTouch.com (corporate.LifeTouch.com [63.71.63.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 87C4A634342 for ; Fri, 2 Apr 2004 11:08:45 -0500 (EST) Received: from no.name.available by corporate.LifeTouch.com via smtpd (for freelists-180.iquest.net [206.53.239.180]) with SMTP; 2 Apr 2004 16:17:23 UT Received: (private information removed) Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B0034B@EXCHMN3> From: DENNIS WILLIAMS To: "'oracle-l@freelists.org'" Subject: RE: Java vs. Perl Date: Fri, 2 Apr 2004 10:13:36 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 2436 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DWILLIAMS@LIFETOUCH.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Cary Well said, as always. Can you pinpoint any parts of Java that are good for a DBA to concentrate on? I've learned just enough OOP to understand that languages like Java don't always lend themselves to clear transaction boundaries. Mostly I've used that as a well of empathy so I can look sympathetic and nod and agree and then say "yeah but you've got to figure it out somehow." I push the Java developers to use PreparedStatement. This causes Java to use bind variables. If I tell a Java developer to use bind variables, they look blankly, but they do understand PreparedStatement, or can at least go back and look it up in a book. Aside from the benefits in Oracle, it also defeats the SQL Injection hacking technique. I would gratefully appreciate any other points you would care to share. Dennis Williams DBA Lifetouch, Inc. dwilliams@lifetouch.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Cary Millsap Sent: Friday, April 02, 2004 9:51 AM To: oracle-l@freelists.org Subject: RE: Java vs. Perl The only reason I would recommend for a DBA to learn Java is if that's what your applications are written in. If you have any performance responsibilities, you MUST know something about the language your apps are written in. Substitute whatever your app is written in for "Java" in this paragraph (PHP, COBOL, C++, C#, Visual Basic, ...it doesn't matter; whatever your app is written in). This, by the way, is why you MUST understand SQL and probably also PL/SQL (if you're lucky); it's part of what your apps are written in. Perl is another story. Maybe your app is written in Perl, but probably not. Even so, Perl, Python, ksh, SQL, PL/SQL, and others are tools that a DBA might use to create new tools that help you do your job more effectively. There's probably someone out there who writes DBA scripts in Java, but whoever you are, I don't envy you. :) Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 4/6 Seattle, 5/7 Dallas, 5/18 New Jersey - SQL Optimization 101: 4/19 Denver, 5/3 Boston, 5/24 San Diego - Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of David Lee Sent: Friday, April 02, 2004 9:37 AM To: oracle-l@freelists.org Subject: RE: Java vs. Perl There are many reasons to use one tool over another. For me and my company, perl offers faster development time. What it boils down to, both tools allow you to connect to the Database so anything that can execute SQL or pl/sql is fine. In the past, executing the same business logic with medium to big amount of data (100k+ records) is faster in perl than java. Unfortunately I=20 don't have any statistics to back to support this. Anyone? The java developers that I know of, uses ODBC or OCI, to communicate = from the java application server (ATG) to 8i. I don't know of anyone using=20 java and communicating to Oracle's API. =20 - David Lee -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Juan Cachito Reyes Pacheco Sent: Friday, April 02, 2004 10:04 AM To: oracle-l@freelists.org Subject: Java vs. Perl Hi, please there is another reason than simple know perl, to use perl instead of Java. I always heard Java had more advantages than perl, including the fact = that Oracle include it in the database. Now you are talking as much about perl, and I am thinking to study java, = I am asking which is best. for most purpouses. Thanks :) Juan Carlos Reyes Pacheco OCP Database 9.2 Standard Edition ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------