Hi Team,
we are facing issue with perform JDBC query result, in the result the columns order got shuffled.
select statement result with JAVA application.
"referral_details": [
{
"CalendarYear": 2021,
"CalendarMonth": 1,
"NumberOfReferrals": 205,
"NumberOfRegistrations": 59,
"NumberOfTradedAccounts": 23
}
same select statement result with gateway perform JDBC query .
"referral_details": [
{
"calendaryear": "2021",
"numberofregistrations": "59",
"numberofreferrals": "205",
"calendarmonth": "1",
"numberoftradedaccounts": "23"
}
as per the both result the gateway result columns are shuffling, so why the columns order shuffling ? is there any workaround to strict the columns order with irrespective of values?
Thanks
Madhu