[unixODBC-support] Problem with achieving Serialization mode with unixODBC inspite it is working with Postgres
nick at lurcher.org
Tue Jun 25 21:05:40 BST 2013
On 25/06/13 11:17, Aditi mittal wrote:
> I have an Application using unixodbc to access postgres server. Since,
> our system is multithreaded environment where in multiple threads can
> access the DB server simultaneuosly.
> Hence for consistency issue, I need to set isolation mode to
> Serializable for a given transaction.
> I tried to by setting connection attribute by following two commands:
> res = SQLSetConnectAttr(*phdbc,SQL_ATTR_TXN_ISOLATION,
> res = SQLSetConnectOption(
> phdbc,SQL_TXN_ISOLATION,SQL_TXN_REPEATABLE_READ );
All of those calls are passed to the driver, I think this is less likely
to be a unixODBC issue, and more likely a driver one.
More information about the unixODBC-support