wso2esb - Issue in getting response back while connecting to Oracle DB in WSO2 esb -
i working on sample application in wso2 esb connects oracle database , return response of query. below mentioned service. issue facing not getting response after execution of service.however able see value returned query response, not able render in response document.
can suggest, missing? db credentials fields have been hashed.
proxy :
<?xml version="1.0" encoding="utf-8"?> <proxy xmlns="http://ws.apache.org/ns/synapse" name="getemployeedetails" transports="https,http" statistics="disable" trace="disable" startonload="true"> <target> <insequence> <property name="out_only" value="true" scope="default" type="boolean"/> <log level="full" category="debug"/> <dblookup> <connection> <pool> <password>****</password> <user>****</user> <url>****</url> <driver>oracle.jdbc.xa.client.oraclexadatasource</driver> </pool> </connection> <statement> <sql>select firstname employee lastname = 'pawar'</sql> <result name="firstname" column="firstname"/> </statement> </dblookup> <log level="custom"> <property name="firstname" expression="get-property('firstname')"/> </log> <payloadfactory media-type="xml"> <format> <getemployeedetailsresponse xmlns=""> <out>$1</out> </getemployeedetailsresponse> </format> <args> <arg evaluator="xml" expression="get-property('firstname')"/> </args> </payloadfactory> </insequence> <outsequence> <log level="full" category="debug"/> </outsequence> </target> <publishwsdl uri="file:/development/data/wso2/wsdl/employee.wsdl"/> <description/> </proxy>
you have send message generated payloadfactory in insequence :
<header name="to" action="remove"/> <property name="response" value="true" scope="default" type="string"/> <property name="no_entity_body" scope="axis2" action="remove"/> <send/>
your mediation "out_only", so, outsequence never been executed
Comments
Post a Comment