Skip to Main Content
Forums

Oracle Database Discussions

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!

Reg: Oracle to mysql server connection

chandra_1986Oct 14 2021

Hi experts,

I have to create db link from oracle db to gateway mysql server, how can i create the db link.

I have addedd the listener entry from Gateway server to tnsnames.ora file in oracle db server, ,and tnsping is working fine.
after this i need to create the dblink to connect from oracle to mysql server db, but i dont' have username and password to create db link.

Any suggestions.

Comments

Philip Sommer
Answer

Hi Yogesh,

Take a look at the Cookbook example for the router at https://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=corerouter&demo=module
Setting up the new router should be fairly similar to the old one.
I implemented the login screen in my application as follows. (Don't know if this is best practise, but it works.) This is also very similar to the router example above.
Create a oj-module element in your main/index HTML to switch between login and content screens/modules.
During application startup - e.g. in your root viewmodel constructor - configure the router paths for login and content. Default should be login.
Check the login status of the user. If login is valid, directly navigate to content; Else stay on the login page.
(Optional) If you have more than one content-screen/module you may want to return your user to the one he last visited (if the login is still valid). In this case, I made a simple extension to the OJ CoreRouter which keeps track of the last routing state in the SessionStorage. I then simply restore the cached state.

image.png
Obviously, you will need to change this for the GoogleAPI, e.g. the validateToken() call would need to be replaced/changed.

Kind Regards,
Philip

Marked as Answer by user525840 · Sep 1 2022
John JB Brock-Oracle

As usual, Philip is correct. The CoreRouter is not that much different from the older ojRouter, and the methods used for actual Login integration are the same.

user525840

Thank you John and Philip.
I will try to implement this logic in my application.

1 - 3

Post Details

Added on Oct 14 2021
#general-database-discussions
1 comment
94 views