Re: How to do development in Oracle using Java?

Daniel A. Morgan <damorgan_at_exesolutions.com> wrote:

> Put all of your SQL into packages in the database and just pass parameters.
> Otherwise debugging, tuning, scalability, and performance will be a nightmare.
>
> Norris Sze wrote:
>
> > I am going to write a new database transaction processing system that are
> > web based for my company. I will develop it using Java. However, there is
> > many variants in Java development, such as servlet, java bean, JSP, applet,
> > etc. It's really confusing. Anyone has experience with Java development? Can
> > someone such how to get started? Thanks!

Daniel's answer is right on, especially if you have little experience in Java. Let me add a bit of advice:

• stay away from applets, unless you enjoy supporting every possible combination of browser and Java virtual machine out there
• stay away from EJBs, they're not the best way to get started into Java
• JSPs get automatically compiled into servlets by the servlet container, so they *are* servlets after all

My suggestion: JSPs purely for presentation, servlets for logic and Java Beans to hold informations between JSPs and servlets. The servlets can invoke stored procedures in packages as Daniel said, and they should never output any HTML code directly. Look into tag libraries to ease your coding.

It may look a bit intimidating at first, but there are many benefits in the long run.

Sebastiano Pilla Received on Sun Feb 03 2002 - 18:35:08 CET