How to get the MySQL database connection in android emulator? I try to connect using java.sql.* package like this
I get the exception: java.sql.SQLException:no suitable drive
How can I use sql packages in android mobile?
views:
2938answers:
3
+3
A:
Never never never use a database driver across an Internet connection, for any database, for any platform, for any client, anywhere. That goes double for mobile. Database drivers are designed for LAN operations and are not designed for flaky/intermittent connections or high latency.
CommonsWare
2010-02-13 11:27:52
ok thanks. do u know how to get the value from mysql database using web service an android mobile. please give some example.
saravanan
2010-02-13 12:44:08
To access REST Web services from Android, I recommend HttpClient -- you can find sample code on the Apache HttpClient site (http://hc.apache.org).
CommonsWare
2010-02-13 23:10:00
A:
The way I got around this was writing all the server side code in PHP and inventing my own XML schema for sending and receiving data. You just use POST or GET and send using the default HTTP classes that come with android. You can then translate the response XML from the PHP page to do what you want by using one of the three XML parsers that come with android.
jax
2010-02-14 08:56:04
A:
You would not typically want to connect directly to a database over the web on your mobile device.
Instead of connecting directly to a database over the web you might look at creating an interface for whatever data it is you want to access and exposing it as a service:
- SOAP (ksoap2 )
- REST
Then you can use Java APIs to access your data.
Layne
2010-02-14 09:35:20