Layer7 API Management

 View Only

Perform JDBC query results columns are shuffle

  • 1.  Perform JDBC query results columns are shuffle

    Posted Apr 27, 2021 01:13 PM
    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