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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
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
 
Don't get me started about those stupid light bulbs.
 
subject: Jdbc & Web Environment