Hi All,
I m getting a strange problem. I have a JDBC adapter for calling a stored procedure which returns nearly 32 fields in resultset. The order of the output parameters of the Adapter service is not same as the order in which the store procedure returns the values. Is it a problem? Do we need to maintain the order of the parameters when we are giving the names of the parameters same as declared in the Stored procedure?
My problem is even if the order is different, i m getting correct values in output in one server. While in another server same adapter service is not giving values in proper order. e.g. Expected is
Name = Sush
Age = 27
country = India
Actual is
Name = 27
Age = India
Country = Sush
Both the server runs WM 7.1.2
What I traced is, in the second server, some fixes are not there, those are present in the 1st server.
Does it matter or I am missing something else.
Below are the list of fixes in both the servers.
Server 1 :
IS_7-1-2_XA_Fix3
IS_7.1.2_Core_Fix24
IS_7.1.2_FlatFile_Fix5
IS_7.1.2_Flow_Fix7
IS_7.1.2_PubSub_Fix7
IS_7.1.2_SrvPrtcl_Fix19
IS_7.1.2_WebSvcsXML_Fix18
IS_7.1.2_PkgMgmt_Fix4
Server 2 :
IS_7.1.2_Core_Fix24
IS_7.1.2_FlatFile_Fix5
IS_7.1.2_PubSub_Fix7
IS_7.1.2_SrvPrtcl_Fix12
IS_7.1.2_WebSvcsXML_Fix11
IS_7.1.2_PkgMgmt_Fix4
Please help…:sad: