1

I am working on an android app and have to use remote database for data storage.I have two options, first create a REST API using php.Second option is connect directly to mysql db with JDBC using mysql-connector-java-5.1.18-bin.jar. I am not familiar with second one but i want to confirm which method will be feasible and why?.

Improve this question

2 Answers 2

Reset to default
2

You can't use second (jdbc) method with android application (SO Reference thread). You have to use REST API.

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

can you say why it is not possible?. I think we have JDBC driver in android.
Thanks for your reference link and suggestion
I'm using JDBC in my android studio, I had to do lot of work to make it work, but it does work
1

You cannot use normal JDBC connection method to a remote to a db server from your android phone as you do normally in a Java application. This is because Java application normally runs a machine which is either on a network or can connect to a network or has the mysql database on it which is not the case with your android phone.

The alternatives you have are

  1. Create webservice (REST or SOAP) and invoke it from your device // As you mentioned

  2. Create a Servlet which can service a POST or GET request, and invoke it from your device.

Cheers, RJ

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.