Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the best way to connect between android and oracle database?

Tags:

android

oracle

I need to access data from an external oracle database from my application android to update the local database application, but I don't know what would be the best way to do it. Would I need to create a web service to access to the oracle database or there is another simple way?

Thanks

like image 525
isramartinez Avatar asked Jan 17 '12 12:01

isramartinez


People also ask

What database can be used with Android?

SQLite is a opensource SQL database that stores data to a text file on a device. Android comes in with built in SQLite database implementation.

How do I connect an Android app and website with same database?

Originally Answered: How do I link the same database with the web and an Android application? Write an API/Rest layer for the database and let both the web and android app connect to the API/Rest layer. android cannot connect to sql connection string same as webapp .

How do I connect to an Oracle Database remotely?

Connecting remotely means running the SQL Command Line (or any other Oracle command-line utility) on a computer other than the Oracle Database XE host computer, and then initiating a database connection from the SQL Command Line (or other utility) over the network.


1 Answers

You have (at least) two options:

  1. Use Oracle Database Mobile Server. (Best, safest bet)

  2. Download the JDBC Drivers and connect that way. (Not recommended, unsafe - especially for over-the-air connectivity)

like image 186
Chris Cashwell Avatar answered Nov 16 '22 02:11

Chris Cashwell