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.
May I recommend maven and appfuse. You have a basic application running in about 5 minutes. After that you can start setting up controllers and wiring them through xml. Takes a while to figure out how the page decoration and menus work and a bit of other details, but it saves you a lot of work and scales pretty well.
Joined: Aug 14, 2009
Bear and Gerardo , Thanks a lot for your suggestions.
@Gerardo, I have not worked on spring or maven before, but I did a self study long ago on spring framework. So I might go with spring framework as I dont have time to upgrade myself right now. But definitely I shall investigate on maven appfuse to help myself with this or the later projects.
@Bear, I did have a look at the Front Man and downloaded it. I shall try a sample application, if it sounds easy and quick I will use it.
Thank you once again. You both have been a great help.