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
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.
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 .
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.
You have (at least) two options:
Use Oracle Database Mobile Server. (Best, safest bet)
Download the JDBC Drivers and connect that way. (Not recommended, unsafe - especially for over-the-air connectivity)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With