Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Transactions within the server
Mon, Jul 27 2015 9:28 PMPermanent 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 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent 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 Wink
Fri, Jul 31 2015 8:03 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Anthony,

Great, thanks. Smile

Tim Young
Elevate Software
www.elevatesoft.com
Image