| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle apps in Java (was: RE: standard edition vs. enterprise edition)
Oops, I put a period when I meant to put a comma.
You will want to use connection pooling. For connection pooling you'll want
to work with your app server administrator (if it isn't you), blah, blah,
blah.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DENNIS WILLIAMS
Sent: Thursday, April 01, 2004 1:33 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: Oracle apps in Java (was: RE: standard edition vs.
enterprise edition)
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_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Leslie Tierstein
Sent: Thursday, April 01, 2004 12:57 PM
To: oracle-l_at_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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Freeman, Donald
Sent: Thursday, April 01, 2004 1:29 PM
To: oracle-l_at_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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Kommareddy, Srinivas (MED, Wissen Infotech)
Sent: Thursday, April 01, 2004 11:55 AM
To: oracle-l_at_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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |