从iOS App连接到Oracle [英] Connecting to Oracle from iOS App

问题描述

我知道这个问题已经被问过几次了，但是似乎没有明确的答案……过去3天或更长的时间里我一直在搜索这个问题.

似乎有两种方法可以从iOS应用连接到Oracle数据库:

1. ODBC客户端 我需要使用ARM的gcj编译ODBC(哪个ODBC?).我认为这是艰难的方法，有很多错误，但是要付出很大的努力才有可能.

2. 使用Web服务 从App连接到Web服务，从Web服务连接到Oracle DB.

这两种方法是否可用?

关于这两种方法的几个问题: 一种.哪个更安全? b.我公司的安全部门会反对上述任何一项吗? C.哪个表现更好? d.一个人通常会使用以上哪个?

解决方案

Web服务就是答案，您不希望人们从移动设备直接连接到数据库. Web服务器将增加一层额外的安全性，并具有在不直接向数据库施加压力的情况下处理并发请求的能力

a.哪个更安全? 如上所述的Web服务

b.我公司的安全部门会反对上述任何一项吗? 是的，安全部门将坚持不打开oracle端口直接连接，除非他们已经打开了该端口.

c.哪个表现更好? Web服务，在Web服务器中设置正确的缓存策略可以将资源保存到数据库中.

d.一个人通常使用以上哪个? Web服务，因为它们在安全性和性能上为您提供了巨大的优势，不仅因为Web服务具有可重用性，而且可以被许多不同的平台访问，所以考虑一下将来您可能希望稍后在Android设备上为您的应用程序提供服务，而Web服务将为您节省很多时间.大量的开发时间.

当今市场上许多顶级应用程序都在使用Web服务，请仔细考虑.

Google Maps是一个强大的网络服务的很好的例子！

I know this has been asked a few times, but there seems to be no clear answer ... am searching on this for the past 3 days or more.

There seem to be 2 ways to connect to an Oracle database from an iOS App :

1. ODBC Client I need to compile ODBC (which ODBC?) using gcj for ARM. I think this is the hard way, wrought with errors, but possible with quite an effort.

2. USING WEB SERVICE Connect from App to webservice and from web service to Oracle DB.

Are these the 2 methods available or any other?

Few questions on the two methods: a. Which is more secure? b. Will my company's security department oppose to any of the above? c. Which is more performant? d. Which of the above does one normally use?

解决方案

Webservices are the answer, you do not want people connecting directly to the database from a mobile device. A Webserver will add one extra layer of security as well as the ability to handle simultaneous request without stressing the database directly

a. Which is more secure? Webservices as explained above

b. Will my company's security department oppose to any of the above? Yes, security department will insist not to open the oracle port to connect directly, unless they have it already open.

c. Which is more performant? Webservices, setting up the right cache policies in a webserver can save resources to the database.

d. Which of the above does one normally use? Webservices, because they offer you great advantages in security and performance, not only that, webservices are reusable and can be accessed by many different platforms, think on the future you might want to serve your application later on Android devices and Webservices will save you a lot of development time.

Many of today's top applications in the market use webservices, think about it.

Google Maps is a great example of how powerful webservices are!

这篇关于从iOS App连接到Oracle的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！