RE: Oracle apps in Java (was: RE: standard edition vs. enterprise edition)
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 1 Apr 2004 13:57:10 -0600
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@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of DENNIS WILLIAMS
Sent: Thursday, April 01, 2004 1:33 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Leslie Tierstein
Sent: Thursday, April 01, 2004 12:57 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Freeman, Donald
Sent: Thursday, April 01, 2004 1:29 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Kommareddy, Srinivas (MED, Wissen Infotech)
Sent: Thursday, April 01, 2004 11:55 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
