Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 6 of 6 total |
Transactions within the server |
Mon, Jul 27 2015 9:28 PM | Permanent Link |
Graham Mylne | Hi
We currently have some server side functions for updating user status and auditing which write to the table directly. But have found locking issues with this over the course and want to see if we can start a transaction on the data. So far from what i can tell i cannot do this correctly as you cannot run a remote connection from the database as the Engine is set to server so its limiting the sessions i can run. I tried just setting up a TThread with a TDBISAMDatabase and starting a transaction, which does start fine, but its not stopping other users from writing data so im assuming this is because my session is a local one and not remote is that correct? So i dont know if there is a way to write a transaction from within the database server to write data or not, any ideas? |
Tue, Jul 28 2015 7:47 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Graham,
<< We currently have some server side functions for updating user status and auditing which write to the table directly. But have found locking issues with this over the course and want to see if we can start a transaction on the data. So far from what i can tell i cannot do this correctly as you cannot run a remote connection from the database as the Engine is set to server so its limiting the sessions i can run. I tried just setting up a TThread with a TDBISAMDatabase and starting a transaction, which does start fine, but its not stopping other users from writing data so im assuming this is because my session is a local one and not remote is that correct? >> Could you post the code that you're using ? If it's confidential, you can email it to me using my email address to the left. I suspect that you're not using the ServerSession instance being passed in to the OnServerProcedure event handler properly. Tim Young Elevate Software www.elevatesoft.com |
Tue, Jul 28 2015 8:44 AM | Permanent Link |
Graham Mylne | Tim Young [Elevate Software] wrote:
Graham, << We currently have some server side functions for updating user status and auditing which write to the table directly. But have found locking issues with this over the course and want to see if we can start a transaction on the data. So far from what i can tell i cannot do this correctly as you cannot run a remote connection from the database as the Engine is set to server so its limiting the sessions i can run. I tried just setting up a TThread with a TDBISAMDatabase and starting a transaction, which does start fine, but its not stopping other users from writing data so im assuming this is because my session is a local one and not remote is that correct? >> Could you post the code that you're using ? If it's confidential, you can email it to me using my email address to the left. I suspect that you're not using the ServerSession instance being passed in to the OnServerProcedure event handler properly. Tim Young Elevate Software www.elevatesoft.com Hi tim This isnt actually in an OnServerProcedure. Its running within the server triggered using the OnServer connection events and also using the server data triggers. Dont know if that helps. Im out of the office at home at the moment ill look at packaging something for you. Thanx for the help |
Wed, Jul 29 2015 6:20 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Graham,
<< This isnt actually in an OnServerProcedure. Its running within the server triggered using the OnServer connection events and also using the server data triggers. Dont know if that helps. Im out of the office at home at the moment ill look at packaging something for you. Thanx for the help >> Are you working with Anthony on this ? He sent me an email indicating that this might be resolved, so I just need to confirm this with you. Tim Young Elevate Software www.elevatesoft.com |
Wed, Jul 29 2015 10:54 PM | Permanent Link |
Graham Mylne | Hi Tim
Its one and the same, i still had the 'company' login logged in from when i was downloading so used it to do the post, all good but. thanks - Anthony |
Fri, Jul 31 2015 8:03 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |