Sidh
Sidh

Reputation: 139

Mule 4 database connector taking more time to execute a stored procedure

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

Answers (0)

Related Questions