Skip to content

Instantly share code, notes, and snippets.

@fjunior87
Created February 4, 2018 01:24
Show Gist options
  • Save fjunior87/22a8b00460af9a1bfec63363619bad74 to your computer and use it in GitHub Desktop.
Save fjunior87/22a8b00460af9a1bfec63363619bad74 to your computer and use it in GitHub Desktop.
SOAP Request to add a new datasource to WSO2
<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsd="http://org.apache.axis2/xsd" xmlns:xsd1="http://services.core.ndatasource.carbon.wso2.org/xsd" xmlns:xsd2="http://core.ndatasource.carbon.wso2.org/xsd">
<soap:Header/>
<soap:Body>
<xsd:addDataSource>
<!--Optional:-->
<xsd:dsmInfo>
<!--Optional:-->
<xsd1:definition>
<!--Optional:-->
<xsd1:dsXMLConfiguration>
<![CDATA[<configuration>
<url>${jdbcUrl}</url>
<username>${jdbcUsername}</username>
<password>${jdbcPassword}</password>
<driverClassName>${jdbcDriverClassName}</driverClassName>
<testOnBorrow>true</testOnBorrow>
<validationInterval>60000</validationInterval>
<maxActive>${jdbcMaxActive}</maxActive>
<minIdle>0</minIdle>
<maxIdle>0</maxIdle>
<maxWait>30000</maxWait>
<testWhileIdle>true</testWhileIdle>
<timeBetweenEvictionRunsMillis>5000</timeBetweenEvictionRunsMillis>
<minEvictableIdleTimeMillis>60000</minEvictableIdleTimeMillis>
<removeAbandoned>true</removeAbandoned>
<removeAbandonedTimeout>9000</removeAbandonedTimeout>
<logAbandoned>true</logAbandoned>
<abandonWhenPercentageFull>0</abandonWhenPercentageFull>
<maxAge>1800000</maxAge>
<suspectTimeout>8940</suspectTimeout>
<validationQueryTimeout>10</validationQueryTimeout>
<initialSize>0</initialSize>
<testOnBorrow>true</testOnBorrow>
<validationQuery>${jdbcTestQuery}</validationQuery>
</configuration>]]>
</xsd1:dsXMLConfiguration>
<!--Optional:-->
<xsd1:type>RDBMS</xsd1:type>
</xsd1:definition>
<!--Optional:-->
<xsd1:description>${description}</xsd1:description>
<!--Optional:-->
<xsd1:jndiConfig>
<!--Optional:-->
<xsd2:name>${jndiName}</xsd2:name>
<!--Optional:-->
<xsd2:useDataSourceFactory>${useDataSourceFactory}</xsd2:useDataSourceFactory>
</xsd1:jndiConfig>
<!--Optional:-->
<xsd1:name>${dataSourceName}</xsd1:name>
<!--Optional:-->
<xsd1:system>false</xsd1:system>
</xsd:dsmInfo>
</xsd:addDataSource>
</soap:Body>
</soap:Envelope>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment