#8 Transaction Completion Options

[Andrew McMillan]

One thought I had today was that it would be nice for
DBBalancer to have some options for completing
transactions.

If I fail to COMMIT my transaction I have written a bad
application, but when switching an application from a
non-persistent connection model to a connection-pooled
model a person might have to cope with this sort of error.

To assist identification of the issue, and to get
things running faster, DBBalancer might offer a new option:

daemon.autocommit=(true|false)

This option (if true) would mean that when the client
closed the connection to DBBalancer, DBBalancer would
send a final "COMMIT; ROLLBACK;" to the server.
This should achieve similar (or possibly better)
behaviour to that found with non-persistent connections.