Hi everyone,
I am working on a new project as a freelancer. Its web application but not a website as such. Just a small application with few JSPs to give some functionality for goods and sales details for a small firm. Basically to generate invoice, to maintain inventory, delivery details for the sold goods , update stock and generate all sorts fo reports.. There may be some 20 to 50 users for this application. I am using MySql and
JSP and want to use a simple but a really robust and scalable web architecture. I have decided to use spring framework and if needed hibernate else just the regular
jdbc dao classes. I do have a few questions in this regards,
1. Would it be necessary to have connection pooling (its the same set of 20-50 users logging in and updating some stock details and logging out)
2. what is the best suitable architecture. I am thinking of front controller
pattern. A controller
servlet with handlers for each kind of request and probably one or at the most 2 dao related classes, exception handling and a simple logging mechanism.
This is a pilot project if looks fine it may be later done in a large scale (500 users).
Its a one month fulltime project where I am the only developer.
P.S: I have not been working on
java in the last 4 years, There are a lot of things changed in the technology and the way projects are worked. I am looking for some tips that you feel might help me.
Please reply back with your ideas. I will research further on it and use it for my project.
Thank you,
Kavita