Hello all,
I am using a JSP/JDBC which is having a select statement. The query refers to a VIEW created based on a join between 2 tables.
The
JSP page displays the records which are fetched as a result of the query executed on the VIEW.
Problem faced :
The VIEW gets locked and the JSP page doesnt display any records.
Only when I release the lock on the view, I am able to see only a fraction of the records which are queried by the same VIEW.
BTW, There are no inserts or any other operations perfomed on these 2 tables from any other client/JSP pages.
Any idea what is going wrong.
Rgds,
Seetesh