Application Programming Interface Guide > Server Actions > Server Actions Reference > ClearDataSourceConnectionPools
 
ClearDataSourceConnectionPools
Clear the connection pools of the specified data sources.
Argument
dataSourcePaths (STRING_ARRAY): Resource paths to the data sources for which the connection pools are to be cleared.
Sample Request
<ns1:performServerAction xmlns:ns1="http://www.compositesw.com/services/system/admin/server" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <ns1:actionName>ClearDataSourceConnectionPools</ns1:actionName>
 <ns1:attributes>
  <ns2:attribute xmlns:ns2="http://www.compositesw.com/services/system/util/common">
   <ns2:name>dataSourcePaths</ns2:name>
   <ns2:type>STRING_ARRAY</ns2:type>
   <ns2:valueArray>
    <ns2:item>/users/composite/admin/mysql</ns2:item>
   </ns2:valueArray>
  </ns2:attribute>
 </ns1:attributes>
</ns1:performServerAction>
Sample Response
<server:performServerActionResponse xmlns:server="http://www.compositesw.com/services/system/admin/server">
 <status>SUCCESS</status>
 <server:messages>
  <common:entry xmlns:common="http://www.compositesw.com/services/system/util/common">
   <common:code>9901130</common:code>
   <common:name>ClearDataSourceConnectionPools</common:name>
   <common:message>Data source connection pool(s) cleared</common:message>
  </common:entry>
 </server:messages>
</server:performServerActionResponse>
Fault
Security: If the caller does not have the ACCESS_TOOLS right and either the MODIFY_ALL_STATUS right or WRITE access to the specified data sources.