aspose file tools*
The moose likes JDBC and the fly likes Jdbc & Web Environment Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic
Author

Jdbc & Web Environment

Mujir Shaikh
Greenhorn

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
Rancher

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.
Dave
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Jdbc & Web Environment