Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
joanne
Starting Member
46 Posts |
 Posted - 2004-08-22 : 09:23:50
|
| Hello, I am in charge with the administration of a sql database (I am in charge since a few days and I’ll start a course in a couple of weeks).Presently they make tests and we have a problem. I do not know if it’s an application related problem or a sql setup problem. There are several users who work at the same time, simultaneously. If one user makes changes in the data base (adding or retrieving data) and then leaves, when the other users wants to make changes as well they are not able to do so as the table is locked. It’s like the first user ``commit`` command, is not done and something is waiting after this. Do you have any idea where the problem is? Thank you in advance for your kind help, I wait for your advice.I forgot to tell you that we have a web application and we use a connection pooling with IIS.joanne |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-23 : 12:23:06
|
| The problem is in the design of the application. The application should not start a transaction and then wait for a user's input.Tara |
 |
|
|
joanne
Starting Member
46 Posts |
Posted - 2004-08-24 : 08:34:49
|
| Hi,Just to say you that I solved the problem. They changed the MS sql driver with a BEA's WebLogic Driver and now all work very well.Thanks anyway.Joanne |
|
|
|
|
|
|
lock problem