Information générale
Titre:
Insert leaving row locked
Hi All
I have an app that is using Sybase Adaptive Server Anywhere as the database. I am using vfp8.0 and Sql Pass through. This app is just now going into production and I am running into a very strange problem. The app is an automated weigh station so the truckers can weigh their own trucks. I this process, I am beginning a transaction, updating and inserting rows and if all data is valid, doing a commit or a rollback if data is not valid. This all works fine. My problem is during this process I am logging different events using a second connection that I want to post even if the transaction is rolled back. Logging these events is leaving the row locked in the log table and that causes replication to fail. If I close down the application then replication works fine and it appears there is no data loss.
I am using automatic transactions on the second connection and I recently started sending a begin transaction and commit on each side of my insert statement. This has not helped. I did not notice this problem using vfp7 but I was not in production with that version either. I am wondering if the new shared connection feature is some how getting mixed up having an open transaction on one connection and having automatic transactions on another. Any ideas would be appreciated.
Thanks.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement