Geek Answers Handbook

Is there a DBI proxy that handles SQL constraints and transactions?

I am looking for a DBI proxy (or similar) that supports both SQL constraints and transactions. The two that I know of are the following:

  • DBD::Proxy
  • DBD::Gofer

DBD :: Proxy

The problem I discovered with the help DBD::Proxyis that its server DBI::ProxyServernot only restricts the requests coming over the network (what I need), but also limits the requests generated internally by the database driver. So, for example, with DBD::Oracle, ping no longer works, as well as many other requests that it issues.

I can't just resolve them because:

  • This is pretty little internal DBD :: Oracle knowledge and will be pretty fragile.
  • White list query_name => 'sql', where query_nameis the first word of what is being transmitted prepare. DBD :: Oracle has many internal queries, and the first word of many of them is select(duh).

So I can not use DBD::Proxy

DBD :: Gofer

I have not tried DBD :: Gofer because the docs seem to tell me that I cannot use transactions through it:

DIFFICULTIES

...

You cannot use transactions

AutoCommit only. Operations are supported.

So, before I write my own application-specific proxy (using RPC::PLServer?), Is there any code that solves this problem?

+5
source share
1 answer

DBI, dbi-users@perl.org. http://dbi.perl.org/

, DBD:: Proxy, . , , .

0

More articles:


All Articles