My requirement is once i issue a request from my
jsp (the request is a sql query) it has to hit the database and should
return the number of affected row but should not commit it . In the next request from jsp the user will either hit
commit button or rollback button and based on the request it will either commit or rollback .In order to acheive this i
believe i have use the same connection object for both request.
I know http is stateless and i have to use the same connection object for both the request . Is it good to have connection object in session
1) How can i use the same connectionobject in both request.?
2) What if the user did not click commit or rollback button . How can i expire the connection object that was opened during first request