OraFAQ Forum: General » DB LINK VS WEB SERVICE

Home » Other » General » DB LINK VS WEB SERVICE

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

DB LINK VS WEB SERVICE [message #578226]

Mon, 25 February 2013 23:55

xpact83
Messages: 203
Registered: October 2008
Location: philippines

Senior Member

Guys which approach is better in getting foreign exchange rates from another database?

Report message to a moderator

Re: DB LINK VS WEB SERVICE [message #578232 is a reply to message #578226]

Tue, 26 February 2013 00:37

Michel Cadot
Messages: 54124
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It depends on so many things and some are not technical ones that no one can tell you.

Regards
Michel

Report message to a moderator

Re: DB LINK VS WEB SERVICE [message #578237 is a reply to message #578232]

Tue, 26 February 2013 00:47

xpact83
Messages: 203
Registered: October 2008
Location: philippines

Senior Member

Because a java developer here insist that web service is better than db link

Report message to a moderator

Re: DB LINK VS WEB SERVICE [message #578240 is a reply to message #578237]

Tue, 26 February 2013 00:50

Michel Cadot
Messages: 54124
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Define "better".

Regards
Michel

Report message to a moderator

Re: DB LINK VS WEB SERVICE [message #578241 is a reply to message #578240]

Tue, 26 February 2013 00:55

xpact83
Messages: 203
Registered: October 2008
Location: philippines

Senior Member

He was talking about db down time issues. I prefer dblink because that's the one i'm familiar with.

Report message to a moderator

Re: DB LINK VS WEB SERVICE [message #578246 is a reply to message #578241]

Tue, 26 February 2013 01:18

Michel Cadot
Messages: 54124
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What is the relation between the choice and db downtime issues?

Regards
Michel

Report message to a moderator

Re: DB LINK VS WEB SERVICE [message #578274 is a reply to message #578246]

Tue, 26 February 2013 06:26

cookiemonster
Messages: 9135
Registered: September 2008
Location: Rainy Manchester

Senior Member

To put it another way - how is either approach going to work if the other DB is down?

Report message to a moderator

Re: DB LINK VS WEB SERVICE [message #578281 is a reply to message #578274]

Tue, 26 February 2013 08:49

BlackSwan
Messages: 20085
Registered: January 2009

Senior Member

> I prefer dblink because that's the one i'm familiar with.
I doubt that folks who own this other DB containing foreign exchange rates will give you username/password access into their DB that is required to make DBLINK succeed.

Report message to a moderator

Re: DB LINK VS WEB SERVICE [message #578313 is a reply to message #578274]

Tue, 26 February 2013 18:18

xpact83
Messages: 203
Registered: October 2008
Location: philippines

Senior Member

@cookiemonster

that's exactly what was in my mind when this guy was explaining to me about downtime issues regarding db link connections. But I did not say it because I have no idea about web service. hehe

@blackswan

Why not? if they will just limit my access into viewing their foreign exchange tables.

Report message to a moderator

Re: DB LINK VS WEB SERVICE [message #578316 is a reply to message #578313]

Tue, 26 February 2013 19:11

BlackSwan
Messages: 20085
Registered: January 2009

Senior Member

>if they will just limit my access into viewing their foreign exchange tables

will you give me a username & password to YOUR Production DB so I can monitor just the DB's performance?

Report message to a moderator

Previous Topic:	Need Explaination for fifth normal form
Next Topic:	Oracle L1 Support Activities

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 03:21:04 CDT 2013

Total time taken to generate the page: 0.11022 seconds