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
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 :
Server 2 :