Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interactive Grid - Disappearing Hamburger Column when using jQuery IG api

Matt McGeeAug 25 2021 — edited Aug 27 2021

I have built out a proof of concept interactive grid where we allow users to edit data in configuration tables. I'm utilizing the plsql return function query source and am renaming and sorting the columns on the fly with jQuery. I have pretty much accounted for everything however, when I execute the jQuery, the APEX$ROW_ACTION (hamburger menu column) disappears and I cannot seem to keep it once the jQuery fires. Anyone have a solution?
We are running APEX 20.2
This is what I am firing after the page loads. It is generated by PL/SQL via AJAX call.

$(document).ready(function () {
    var Grid_1 = apex.region("aaGridEdit").widget().interactiveGrid("getViews").grid;
    Grid_1.view$.grid({
        "editable": true,
        "columns": [{
                "VC1": {
                    "heading": "Batch Mask",
                    "seq": 1
                },
                "VC2": {
                    "heading": "Autobatch Method",
                    "seq": 2
                },
                "VC3": {
                    "heading": "Descr",
                    "seq": 3
                },
                "VC4": {
                    "heading": "User Id",
                    "seq": 4
                },
                "LOV1": {
                    "heading": "Setofbooks",
                    "seq": 5
                },
                "LOV2": {
                    "heading": "Auto Close",
                    "seq": 6
                },
                "LOV3": {
                    "heading": "Auto Settle",
                    "seq": 7
                },
                "VC5": {
                    "heading": "Email Address",
                    "seq": 8
                },
                "LOV4": {
                    "heading": "Batch Type",
                    "seq": 9
                }
            }
        ]
    });
    Grid_1.view$.grid("refreshColumns").grid("refresh");
});
This post has been answered by Oleh Tyshchenko on Aug 28 2021
Jump to Answer

Comments

Answer

You want to use MySQL Router as the load balancer for the cluster.  If you are running a load balancer to get to the application that is fine but bot for InnoDb Cluster traffic.

Marked as Answer by user619241 · Sep 27 2020
lefred-MySQL-Oracle

Hello,

Putting MySQL Router on a dedicated server (or more) is OK, but I really don't understand the benetifs to put it on cluster nodes !

Maybe your loadbalancer doesn't close connections ? Like that it's difficult to answer. Check the connectio status and variables in MySQL and check the connections in the router.

Regards,

Place Router on the application nodes not on the InnoDB cluster nodes.  See https://dev.mysql.com/doc/mysql-router/8.0/en/

user619241

Hello,

I agree with all the answers. I still don't understand this statement:

"You want to use MySQL Router as the load balancer for the cluster."

Is MySQL Router a load balancer by itself? Then does the Router itself have HA capability?

Thanks,

- Xinhuan

MySQL Router will load balance the queries to innoDB Cluster or ReplciaSet.

user619241

In my test environment, I installed multiple mysqlrouter and start them. I'm testing if one of mysqlrouter process stop, can client connection be failed over to another mysqlrouter instance automatically. I tested with Keepalived. So far it wasn't successful. It looks like mysqlrouter is Single-Point-of-Failure.

- Xinhuan

1 - 6

Post Details

Added on Aug 25 2021
4 comments
96 views