• Post Reply Bookmark Topic Watch Topic
  • New Topic

table locks, static connection  RSS feed

Ranch Hand
Posts: 455
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello. I think I have a problem, and don't know what to do about it. We have an application we created that connects to a DB2/400 database. When a user keys in an order number, the app retrieves the data from the db back to the user.
I've recently noticed, that after the user has the data back, there is still an object lock on the table that the data was retrieved from.
Also, if the user logs out of the application, and then gets back in again, it shows the time the job entered the system, the same as the first time they got on. I am using a static conneciton object, is that bad? Could someone explain the do's and don'ts of using a static connection.
Also, why is there still a lock on my table after the user got the data back.
Apparently I still have a lot to learn!
Thanks for any help!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!