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
3343
September 17, 2007 09:28AM
2447
September 20, 2007 08:04AM
2353
October 04, 2007 01:34AM
2400
October 05, 2007 11:28AM
2397
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.