467,169 Members | 1,023 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,169 developers. It's quick & easy.

how to find out a locak level set for a table. Strange problem

Hi All,

i am using mssql 2005 and i am facing a strange problem.

i have two databases A , B.When i try to insert one row in A from my application it is inserting the row but after that it is giving page not found exception when i try to retrieve the data to display form the same table.
When i do the same operation on B from my applciation it is not throwing any error.

1)Is it to do with the lock levels set on the data base.
can you give me query to find out lock level set on the table and query to set the lock levels.
2) How to compare the two data bases to find out the difference in the settings..
second problem:

when i access the data base from my application
a session opened against a database . The connection was made via the jdbc driver so I believe that the session was precipitated by the front-end application.

the session initiated a page lock against a table with the intention of doing something to it (insert/update/delete). For some reason, the session remained inactive for the past 5 days but maintained the page lock on the table. The result of this was that any activity requiring access to the records contained within that page were blocked, pending the release of the lock.

Is there any way to prevent this by imposing the lock level setting form my front end application. I am using spring MVC frame work with Spring jbdc to connect to my data base.

Please help me , its very urgent........

Thanks for any help

Oct 18 '07 #1
  • viewed: 1010

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

12 posts views Thread by pillepop2003 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.