1. I am writing a web application

hm, you mean I should pass the Connection object to page2?
hmmm... u want to write a web application?!!! Heard of Connection pooling?!
thx~ Then, consider another case, if the application executes a "select...for update" statement, and wait for user's input before it executes the "commit" command. Will the rows/tables be locked up forever, until the user makes his move?
Yes, will do(As a result of bad design/deployment) until you have a DB profile associated which will expire the connection or a client implementation which will Timeout the connection.

- Nandu