Skip to Main Content

Java Development Tools

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!

Calling Jdeveloper ADF Application from Oracle Forms

640822Aug 27 2008 — edited Aug 28 2008
Hallo All,

i want to call an ADF Application from Jdeveloper in Oracle Forms. I followed the exapmple here(http://www.oracle.com/technology/obe/obe11jdev/11/dvt/gant_chart_pivot_table.htm) and created the master-detail page, guage,gantts chart,pivot table . Now i am looking at the opportunity of calling this application in Forms Builder, so that when i click on a buttoun i can see the Gantt chart or Map or Pivot table i created in Jdeveloper.
Does anyone have any idea? Pls can you give me a step by step know-how of the solution?

Thanks..

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
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 25 2008
Added on Aug 27 2008
3 comments
445 views