<!-- One way of implementation in WSO2 Integrator -->
In Eclipse, create: WSO2 > Extensions > Project Types > Mediator Project
Code fragment:
import org.apache.synapse.mediators.AbstractMediator;
import java.sql.CallableStatement;
import java.sql.DriverManager;
public class CustomMediatorClass extends AbstractMediator {
public boolean mediate(MessageContext msgCtxt) {
...
Connection con =
DriverManager.getConnection(dbURL, dbUsr, dbPswd);
CallableStatement cs = null;
…
cs = con.prepareCall("{call yourSP(?, ?)}");
cs.setString(1, spParm01); // spParms from
msgCtxt
cs.setString(2, spParm02);
...
cs.execute();
if (con != null && !con.isClosed()) {
con.close();
con = null;
}
...
return true;
}
}
Build your jar, copy to WSO2_HOME\lib\ - restart Integrator
Include in your Sequence, REST API: <class
name="org.your-org.mediator.CustomMediatorClass"/>
ReDeploy your CompositeApp to Integrator
<!-- Hope this helps for your requirement -->
Regards
Eldrid
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
