If you are try to use AutoCommit feature in wso2 IS530 Its doesn't working and given following error.
WARN
{org.wso2.andes.store.rdbms.RDBMSAndesContextStoreImpl} - Rollback failed on removing node information node id: NODEu3irhu10.ir.su1/172.21.160.4 {org.wso2.andes.store.rdbms.RDBMSAndesContextStoreImpl}Because. AutoCommit won't work with postgres. You need to modify your master-datasources.xml as follows. For example,
<datasource> <name>WSO2AM_DB</name> <description>The datasource used for registry and user manager</description> <jndiConfig> <name>jdbc/WSO2AM_DB</name> </jndiConfig> <definition type="RDBMS"> <configuration> <url>jdbc:postgresql://localhost:5432/WSO2AM_DB</url> <defaultAutoCommit>false</defaultAutoCommit> <username>postgres</username> <password>postgres</password> <driverClassName>org.postgresql.Driver</driverClassName> <maxActive>50</maxActive> <maxWait>60000</maxWait> <testOnBorrow>true</testOnBorrow> <validationQuery>SELECT 1</validationQuery> <validationInterval>30000</validationInterval> </configuration> </definition> </datasource>