Re: [Dev] [IS] Global database configurations for secondary custom user store

2015-12-11 Thread Thilini Cooray
Hi Tharindu, Thanks a lot for your input. Indeed there can be issues of setting autocommit to true when it comes to write operations and composite database operations. In a use case of READ-ONLY custom secondary user store, is *changing autocommit settings from source code* it

Re: [Dev] [IS] Global database configurations for secondary custom user store

2015-12-11 Thread Tharindu Edirisinghe
Hi Thilini, For primary userstore, this is configurable by adding as mentioned in [1] and [2]. But according to [3] it seems this is not configurable for secondary userstores. However setting autocommit to true can cause problems sometimes as we cannot roll back a transaction with multiple S

[Dev] [IS] Global database configurations for secondary custom user store

2015-12-11 Thread Thilini Cooray
Hi, How can we set *autoCommit* value in a* global configuration for a secondary custom user store database* ? Following are some of our findings about user store database handling related implementation - When we analyze getDBConnection() method in org.wso2.carbon.user.core. jdbc.JDBCUse