8. BPs used in the web application
- SOMU_webapp_selectUser.bp – run in jsp2.jsp
<process name="default">
<sequence name="Sequence Start">
<operation name="Lightweight JDBC Adapter">
<participant name="LightweightJDBCAdapterQuery"/>
<output message="LightweightJDBCAdapterTypeInputMessage">
<assign to="." from="*"/>
<assign to="pool">mysqlPool</assign>
<assign to="query_type">SELECT</assign>
<assign to="result_name">RESULT</assign>
<assign to="row_name">ROW</assign>
<assign to="sql">select yfs_user.USERNAME, yfs_user.BILLINGADDRESS_KEY, yfs_user.SESSION_TIMEOUT, yfs_person_info.FIRST_NAME, yfs_person_info.LAST_NAME, yfs_person_info.EMAILID, yfs_person_info.PERSON_INFO_KEY from yfs_user, yfs_person_info where yfs_user.BILLINGADDRESS_KEY = yfs_person_info.PERSON_INFO_KEY</assign>
</output>
<input message="inmsg">
<assign to="." from="*"/>
</input>
</operation>
<operation name="Business Process Response Service Type">
<participant name="BusinessProcessResponseService"/>
<output message="BusinessProcessResponseServiceTypeInputMessage">
<assign to="." from="*"/>
</output>
<input message="inmsg">
<assign to="." from="*"/>
</input>
</operation>
</sequence>
</process>
- SOMU_webapp_selectUserAuditDetails.bp – run in jsp3.jsp
<process name="default">
<sequence name="Sequence Start">
<operation name="Lightweight JDBC Adapter">
<participant name="LightweightJDBCAdapterQuery"/>
<output message="LightweightJDBCAdapterTypeInputMessage">
<assign to="." from="*"/>
<assign to="param1" from="userParam/text()"/>
<assign to="paramtype1">String</assign>
<assign to="pool">mysqlPool</assign>
<assign to="query_type">SELECT</assign>
<assign to="result_name">RESULT</assign>
<assign to="row_name">ROW</assign>
<assign to="sql">select OBJECT_TYPE, OBJECT_NAME, ACTION_TYPE, ACTION_VALUE, TIME from admin_audit where PRINCIPAL = ?</assign>
</output>
<input message="inmsg">
<assign to="." from="*"/>
</input>
</operation>
<operation name="Business Process Response Service Type">
<participant name="BusinessProcessResponseService"/>
<output message="BusinessProcessResponseServiceTypeInputMessage">
<assign to="." from="*"/>
</output>
<input message="inmsg">
<assign to="." from="*"/>
</input>
</operation>
</sequence>
</process>
