AutoCommit Does'nt working with postgres sql


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>

Post a Comment

Previous Post Next Post