File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Small size web app Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Small size web app" Watch "Small size web app" New topic

Small size web app

subba Sathi

Joined: Jul 02, 2008
Posts: 8
I would like to develop a small size web app(3-5 screens) that needs to access DB2 table in the backend..

What should be the technology used..

JSP/Servlets/java beans
Here how does the database connection happens
What is the architecture diagram look like? like presentation layer/business logic layer/data access layer etc..

JSP/Servlets/EJB - Does it need EJB for a small size app..

Please advise..

PS. I would like to know different combinations of architecture designs for various types of web applications like small, medium and large applications..

can someone guide me thru this.. i am being exposed to web technologies recently and would know JSP/Servlets only..

Presentation Layer - JSP/Servlets
Business Logic Layer - Java Beans
Data Access layer - JDBC

Subba S
[ July 02, 2008: Message edited by: subba Sathi ]
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Not really a JDBC question.

A small web application is very unlikely to require EJBs. Do you have specific non-functional requirements you need to meet that would suggest EJBs are a good choice?

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
subba Sathi

Joined: Jul 02, 2008
Posts: 8
Thanks for reply..

Not knowing EJB much, what kind of NFRs EJB supports..

What are the limitations of using JDBC as data access layer..

The screen will have read/Update records from the DB2 table..

Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

No offense your questions kind of large and all-encompassing, perhaps you should pick up a book or two on web applications, J2EE servers, and ejbs. I recommend the Head First series.

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: Small size web app
It's not a secret anymore!