From oracle-l-bounce@freelists.org Thu Apr 1 13:44:12 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i31JiBx04272 for ; Thu, 1 Apr 2004 13:44:11 -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 i31JiAo04256 for ; Thu, 1 Apr 2004 13:44:10 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 634F36369C8; Thu, 1 Apr 2004 14:38:01 -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 25302-41; Thu, 1 Apr 2004 14:38:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B9776636DFE; Thu, 1 Apr 2004 14:35:00 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 01 Apr 2004 14:33:36 -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 5BC0E6368D5 for ; Thu, 1 Apr 2004 14:31:18 -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 23898-11 for ; Thu, 1 Apr 2004 14:31:17 -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 D39A8636367 for ; Thu, 1 Apr 2004 14:28:06 -0500 (EST) Received: from no.name.available by corporate.LifeTouch.com via smtpd (for freelists-180.iquest.net [206.53.239.180]) with SMTP; 1 Apr 2004 19:36:35 UT Received: (private information removed) Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00333@EXCHMN3> From: DENNIS WILLIAMS To: "'oracle-l@freelists.org'" Subject: RE: Oracle apps in Java (was: RE: standard edition vs. enterprise edition) Date: Thu, 1 Apr 2004 13:32:52 -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: 2306 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 Leslie Great comment -- DIJAB!! How true! I've met these people. One small correction. You only need to increase the java_pool_size if you are going to create Java stored procedures. I agree with you that there isn't that much need for Java stored procedures, and for connection pooling. You will want to work with the app. server administrator to ensure the your Oracle PROCESSES init.ora parameter is set higher than the number of connections in the app. server. 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 Leslie Tierstein Sent: Thursday, April 01, 2004 12:57 PM To: oracle-l@freelists.org Subject: Oracle apps in Java (was: RE: standard edition vs. enterprise edition) >From the database perspective, at a minimum, you will need to vastly increase the default value of the java_pool_size parameter to get anything to run. Then, you have to make a lot of decisions about how the java application is going to deployed. Oracle has an option to deploy pieces of java in the database. The javaheads will probably not want to do this and, for this decision, I agree with them (the java in the database can become very large very quickly, if you need to link in lots of Java classes to get your class to run.) And also, what type of Java application you're going to develop: options include java client, JSP/HTML, UIX (proprietary to Oracle, but the apps are using it). You should really insist that the developers use some technology that supports connection pooling via the application server; Oracle's JDeveloper APIs (and generated code) offer this capability. Or at least persistent connections ... There will be a battle between the javaheads (who, to paraphrase a friend of mine, tend to like "DIJAB" technology -- Database Is Just A Bucket) and will want to design their classes first, and then have the DBA try to design a well-functioning database to fit those classes, and the Oracle types, who like to start with well-designed databases if they have any smarts whatsoever. A good piece of Object-Relational mapping software will help here; again, JDeveloper does some of this, as does TopLink (also an Oracle product). Have fun, Leslie -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Freeman, Donald Sent: Thursday, April 01, 2004 1:29 PM To: oracle-l@freelists.org Subject: RE: standard edition vs enterprise edition I'm really not very knowledgeable about creating Oracle applications in Java other than to say that Oracle is heavily invested in Java technology. Maybe someone else could expand on this? -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Kommareddy, Srinivas (MED, Wissen Infotech) Sent: Thursday, April 01, 2004 11:55 AM To: oracle-l@freelists.org Subject: RE: standard edition vs enterprise edition Hi, Currently we have data in MS-Access and we are migrating it to oracle and developing Java based applications for that. Is tehre any thing specific to know (configuration, versions etc..) if we are going to develop java based applications ? Srinivas ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------