Disabling Transactions

Some applications start transactions inadvertently. Starting transactions when is not needed puts unnecessary strain on the Virtual DataPort server.

You can configure the ODBC interface of Virtual DataPort to prevent that the ODBC clients start transactions. To do this, follow these steps:

  1. Open the Virtual DataPort administration tool.
  2. Log in as an administrator user.
  3. Open the VQL Shell and execute this statement:
SET 'com.denodo.vdb.vdbinterface.server.odbc.ignoreTransactions' = 'true';

The change is applied immediately; restarting the Virtual DataPort server is not necessary.

After these steps, the ODBC interface will ignore the following statements:

  • BEGIN
  • COMMIT
  • ROLLBACK
  • SAVEPOINT
  • RELEASE

These are the statements that ODBC applications send to start and finish transactions.

This change affects all the clients that connect to the ODBC interface. It does not affect clients that connect to Virtual DataPort through its other interfaces (JDBC clients, published web services, etc.)

To revert to the previous behavior, execute the following:

SET 'com.denodo.vdb.vdbinterface.server.odbc.ignoreTransactions' = 'false';