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!

Difference between Service Name and SID.

PsystecMay 26 2017 — edited Jun 2 2017

Hello Fellow Earthlings

I'm a bit new when it comes to creating Oracle drivers and I was the lucky winner assigned to make an oracle driver.

My driver works but, the connection string that the driver creates bypasses TNSnames, meaning its a bit of a manual string creation.

Currently my driver only replaces the SID variable and does not cater for Service_Names.

I know that Service Names are used in Cluster's and SID is a unique DB name usually, but beyond this is know nothing more.

Questions:

What is the difference between a Service Name and SID in the TNSnames? (technical answer if possible)

Can I use both in the TNSnames?

Kind Regards and thanks in advance.
This post has been answered by ddf_dba on May 26 2017
Jump to Answer

Comments

John JB Brock-Oracle

You can do an Internet search on Oracle JET GraphQL and find a few blog posts. It really doesn't make any different to JET how you get your data. We are purely client-side. Install the Apollo client and go for it. JET will work with the returning JSON data the same way. You can not use the Common Model API with GraphQL as it's written over the top of AJAX itself, but you can definitely do anything you like with GraphQL and just pass the results to the JET DataProviders, or components.

1 person found this helpful
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 30 2017
Added on May 26 2017
#connection, #general-database-discussions
24 comments
60,716 views