Getting started Community Training Tutorials Documentation APIs, AI & Tools
<sockets:listener-config name="Sockets_Listener_config" doc:name="Sockets Listener config">
<sockets:tcp-listener-connection host="localhost" port="8082" >
<sockets:protocol >
<sockets:direct-protocol />
</sockets:protocol>
</sockets:tcp-listener-connection>
</sockets:listener-config>
<db:config name="Database_Config" doc:name="Database Config">
<db:oracle-connection host="localhost" user="sys as sysdba" password="Oradoc_db1" serviceName="orclpdb1.localdomain" />
</db:config>
<sockets:request-config name="Sockets_Request_config" doc:name="Sockets Request config" >
<sockets:udp-requester-connection host="localhost" port="8085" />
</sockets:request-config>
<flow name="socketSearchDatabaseAndReturnResult">
<sockets:listener doc:name="Listener" config-ref="Sockets_Listener_config" outputMimeType="application/json"/>
<db:select doc:name="Select" config-ref="Database_Config">
<db:sql>#["SELECT first_name, last_name from SYSTEM.MUSICIANS where id = :id"]</db:sql>
<db:input-parameters><![CDATA[#[{ 'id': payload.id }]]]></db:input-parameters>
</db:select>
<logger level="INFO" doc:name="Logger" message="#[payload]" />
<sockets:send doc:name="Send" config-ref="Sockets_Request_config">
<sockets:content ><![CDATA[#[output application/json --- 'name': payload[0].FIRST_NAME as String ++ ' ' ++ payload[0].LAST_NAME as String]]]></sockets:content>
</sockets:send>
</flow>



