Reputation: 139
I am trying to create a simple flow where i need to execute a procedure and return the data to a client application via mule. The flow is build in mule4 , but unfortunately the database connector(1.14.3) is taking more time and looks like its stuck . Did anyone encountered this scenario. I tried downgrading the connector but no luck . Is it something to do with JDK version to ?
Please feel free to answer.
<?xml version="1.0" encoding="UTF-8"?>
<mule xmlns:http="http://www.mulesoft.org/schema/mule/http" xmlns:db="http://www.mulesoft.org/schema/mule/db"
xmlns="http://www.mulesoft.org/schema/mule/core"
xmlns:doc="http://www.mulesoft.org/schema/mule/documentation" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/current/mule.xsd
http://www.mulesoft.org/schema/mule/db http://www.mulesoft.org/schema/mule/db/current/mule-db.xsd
http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/current/mule-http.xsd">
<db:config name="Database_Config" doc:name="Database Config" doc:id="aeaca3b3-daa8-4cfd-b61b-127bf9052392" >
<db:oracle-connection host="ldap://ldap-ldprd.xxxxx.com" port="5000" user="xxxx" password="xxxxxxx" serviceName="cn=OracleContext,dc=xxxxx,dc=com/xxxxx" />
</db:config>
<http:listener-config name="HTTP_Listener_config" doc:name="HTTP Listener config" doc:id="387b0736-3bd4-42c4-b8c3-6f2f1be1a9f7" >
<http:listener-connection host="0.0.0.0" port="8081" />
</http:listener-config>
<flow name="mytestFlow" doc:id="ccb8fc91-17a4-44d0-a4b1-c1c09338299f" >
<http:listener doc:name="Listener" doc:id="4484ad0c-90f5-4ac3-ad34-32671f94662e" config-ref="HTTP_Listener_config" path="/getdetails"/>
<db:stored-procedure doc:name="Stored procedure" doc:id="33ec085e-0156-457d-be1c-cacba672f643" config-ref="Database_Config" queryTimeout="10">
<non-repeatable-stream />
<reconnect-forever />
<db:sql ><![CDATA[{call APPS.GET_USER_BANNER_MSG (:bannerMessage, :P_ERROR_MESSAGE)}]]></db:sql>
<db:output-parameters >
<db:output-parameter key="bannerMessage" customType="CURSOR" type="LONGVARCHAR"/>
<db:output-parameter key="P_ERROR_MESSAGE" type="VARCHAR" />
</db:output-parameters>
</db:stored-procedure>
</flow>
</mule>
Thanks,
SID
Upvotes: 1
Views: 395