This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Servlets and the fly likes database access & request dipatcher Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Java » Servlets
Bookmark "database access & request dipatcher " Watch "database access & request dipatcher " New topic

database access & request dipatcher

manish ahuja
Ranch Hand

Joined: Oct 23, 2003
Posts: 312
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?

manish ahuja
Ranch Hand

Joined: Oct 23, 2003
Posts: 312
Hey guys
Can anyone take a shot at this
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

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.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: database access & request dipatcher
It's not a secret anymore!