Hi we are planning to migrate our old application to a web application. and JSF seems fit for requirements for the front-end and mid-tier functionalities.

My question is what would be the best way to gather data from our database (ORACLE Database).

We are currently using JBOSS AS5 for our development server.

The application forms will be having:

1. List of Values for selecting records and application will automatically capture data to the form.

Should i use some sort of caching mechanism for the values?  what about on tables that changes fast?

2. Transactions accross pages.

Should I use EJB3?

3. Users will range from 200 users to 400 intranet, and we are planning to expose this also to 5000 to 10000 external users after POC is successful.

We have existing tables that we would like to use for posting of transactions.