I need to execute mysql queries on the client side (Win32 c++ app) aginst a mysql database. I could connect directly to the database using standard mysql libraies executing queries, and then process the resulting recordset on the client as usual.



But I need some blocking behavoiur to some queries, eg. one query inititated from a client should wait to finish another query inititated from another one.



To achieve this insted of 2 tier architecture I need a 3 tier architecture, in other worlds I need a so called lockproxy between the client and the database...

Each query intantiated from the client against the lockproxy will have a lockid(int32), and before executing each query the lockproxy will check it's internal list of the actually running querries and if one found with the same lockid, it waits to finish it before executing other querries



I've found Poco (http://www.appinf.com/docs/poco/) libriary is ideal for the server side locking architecture using it's built in remoting mechnism and database classes.

So the client app will use poco to connect to the server and passing an sql query string to together with a lockid. The server is also implemented using poco, checks for lockid, and if no other running process found with the same lockid, it executes the query against the database and returns the resulting recordset to the client using remoting...