Transactions via http tunnel

[IanSa]

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

[Pinturiccio]

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.