Hi 1) How to handle multiple concurrent database requests/updates when using JDBC with servlets? 2)When using a dispatcher and calling .forward(), will doGet() or doPost() be called in the target servlet?
Firstly these are two questions, it would be better to hava separate thread for each. Database access in a J2EE application should be managed through a DataSource configured in the application server. This allows the server to manage distributed transactions (if the database and drivers support this). It makes database access much easier since you can go (pseudo code only ):
It is important to note that the database code does not have to be in the Servlet (you can delegate the responisility to another class that just returns objects). I'll have to check on the other, I only ever forward to a JSP, and the _jspService takes care of both. I believe it will be whatever the initial request was ie GET -> forward -> doGet, POST -> forward -> doPost, but I'll have to double check. Dave