Architecture for web based applications

[Quoted] We are starting a new web based project. We will be using oracle 9i as database, oracle 9iAS for application server and Java based code as front end. We also plan to use JDeveloper for front end development.

We are struggling to visualize end to end application architecture. Most of the team has worked on client/server applications.

I request information/answers for the following:

(1)In what language I should paint my front end (presentation layer)
screen (Is it JSP/HTML/Servlet/others)

(2)How should I separate business logic from presentation layer? What
language I should write? Will I be using EJB for reusable components?

(3) Will I be using JDBC drivers, if I use 9iAS? Depending on the
userid, visibility of data should be imposed.

(4) We would like to maximize the reusability of components. Hence we
thought all db-table related DMLs, we will put in database via pl/sql procedures. Is this approach correct? In this case, I will be calling pl/sql procedures from my application logic area.

(5) If I put all DMLs in database, there would be lot of
insert/update/select statements for one table depending on the user input. Example, if user is inserting a record, he will definetely pass all NOT NULL values, but he may give only few NULL values. So my insert statement in database should cater to all combinations. How can I achieve this?

(6) Are there any readymade projects available on the net for this
kind of combination? Can I refer the source code?

(7) Are there any documentation/books cover these topics. I find
individual books on database, 9iAS, JSP. But couldn't find a book which will explore the capabilities of the 3.

Anticipating a quick reply.

Prahtap. Received on Fri Nov 16 2001 - 08:48:35 CET