MySQL Forums
Forum List  »  Router & Proxy

Transaction
Posted by: Christopher Hubrich
Date: September 17, 2007 09:28AM

Hi,

ive tried the last svn version. i use the rw-splitting.lua for testing a transaction.

Now i send 3 commands through the proxy:
START TRANSACTION;
SELECT * FROM test;
SHOW TABLES FROM testdb LIKE 'test';
...
COMMIT;

The third statement doesnt go through the same backend connection! Its the same backend (because its a show statement), but not the same connection. So the third connection response doesnt have the "in_trans" flaq anymore.

do you have any work around for this problem?

Chris

Options: ReplyQuote


Subject
Views
Written By
Posted
Transaction
3357
September 17, 2007 09:28AM
2456
September 20, 2007 08:04AM
2368
October 04, 2007 01:34AM
2415
October 05, 2007 11:28AM
2405
October 10, 2007 03:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.