aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Jdbc & Web Environment Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Storm Applied this week in the Other Open Source APIs forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Reply locked New topic

Jdbc & Web Environment

Mujir Shaikh

Joined: May 18, 2002
Posts: 10
Hi Folks,
Sorry for repeating the post here, but this is for the DB Guys esp.
I have a requirement that I acquire locks on Rows while a user is updating some fields on a Web Page (Intranet). Now the Issue is that this DB Lock should be removed only after he finishes his operations on 5-6 pages i.e. I acquire Locks on DB thru setting Transaction Isolation Levels and my DB Transaction is spread across 5-6 HTTP Requests!! How do I go about this?
One idea is to put the Connection Object in HttpSession and commit the Transaction after the 5-6 Pages. But Connection Object is not Serializable, so in case of Server Failure, safe fail-Over is not possible.
Any ideas on this guys?
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

there's a good reply by Kyle here in the Servlet forum, so I'm going to close this thread so we don't get duplicate conversations.
It is sorta covered in the JavaRanch Style Guide.
subject: Jdbc & Web Environment