[unixODBC-support] Problem with achieving Serialization mode with unixODBC inspite it is working with Postgres

Nick Gorham nick at lurcher.org
Tue Jun 25 21:05:40 BST 2013


On 25/06/13 11:17, Aditi mittal wrote:
> Hi,
>
> 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, 
> (SQLPOINTER)SQL_TXN_SERIALIZABLE,SQL_NTS);
> res = SQLSetConnectOption( 
> phdbc,SQL_TXN_ISOLATION,SQL_TXN_REPEATABLE_READ );

Hi,

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.

-- 
Nick


More information about the unixODBC-support mailing list