Transactions via http tunnel

Transactions via http tunnel

Postby IanSa » Fri 05 May 2017 16:12

I'm interested in the dotConnect for MySQL (With the http tunnel)

But, with direct connections, I often use transactions where the client will update more than one table and the client receives result of the update(s) and, based on the result of those updates, will Commit or Rollback the the transaction.

Can the php tunnel handle that? I mean how does the connection persist when the client is sending more than one query to the php script.

Is it all handled locally by dotconnect or is there something in the php at the server that allows the client to reuse the same connection through multiple posts?

Thanks
Ian
IanSa
 
Posts: 1
Joined: Fri 05 May 2017 16:04

Re: Transactions via http tunnel

Postby Pinturiccio » Wed 10 May 2017 12:39

The tunnel.php script is just a mediator. It doesn’t modify data in any way, it just passes them from the client application to the database server and vice versa unmodified. Thus, the behaviour of a transaction will be the same with tunnel.php script or without it. If you commit a transaction, then all updates are applied. If you rollback a transaction, then no updates are applied.
Pinturiccio
Devart Team
 
Posts: 1891
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for MySQL