Home » Other » General » DB LINK VS WEB SERVICE
DB LINK VS WEB SERVICE [message #578226] Mon, 25 February 2013 23:55 Go to next message
xpact83
Messages: 218
Registered: October 2008
Location: philippines
Senior Member
Guys which approach is better in getting foreign exchange rates from another database?
Re: DB LINK VS WEB SERVICE [message #578232 is a reply to message #578226] Tue, 26 February 2013 00:37 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
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
Re: DB LINK VS WEB SERVICE [message #578237 is a reply to message #578232] Tue, 26 February 2013 00:47 Go to previous messageGo to next message
xpact83
Messages: 218
Registered: October 2008
Location: philippines
Senior Member
Because a java developer here insist that web service is better than db link
Re: DB LINK VS WEB SERVICE [message #578240 is a reply to message #578237] Tue, 26 February 2013 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Define "better".

Regards
Michel
Re: DB LINK VS WEB SERVICE [message #578241 is a reply to message #578240] Tue, 26 February 2013 00:55 Go to previous messageGo to next message
xpact83
Messages: 218
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.
Re: DB LINK VS WEB SERVICE [message #578246 is a reply to message #578241] Tue, 26 February 2013 01:18 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the relation between the choice and db downtime issues?

Regards
Michel
Re: DB LINK VS WEB SERVICE [message #578274 is a reply to message #578246] Tue, 26 February 2013 06:26 Go to previous messageGo to next message
cookiemonster
Messages: 10961
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?
Re: DB LINK VS WEB SERVICE [message #578281 is a reply to message #578274] Tue, 26 February 2013 08:49 Go to previous messageGo to next message
BlackSwan
Messages: 22790
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.
Re: DB LINK VS WEB SERVICE [message #578313 is a reply to message #578274] Tue, 26 February 2013 18:18 Go to previous messageGo to next message
xpact83
Messages: 218
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.
Re: DB LINK VS WEB SERVICE [message #578316 is a reply to message #578313] Tue, 26 February 2013 19:11 Go to previous message
BlackSwan
Messages: 22790
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?
Previous Topic: Need Explaination for fifth normal form
Next Topic: Oracle L1 Support Activities
Goto Forum:
  


Current Time: Fri Sep 19 05:10:30 CDT 2014

Total time taken to generate the page: 0.12637 seconds