Suppose I want to fetch records from remote database located somewhere on server.
And I want JDBC to use.Can we use JDBC ?
However I know that it is not standard way to go. We can use SOAP kind of webservice too. But somehow I want to use JDBC only.
Please help ?
Any tutorial will be a great help.
Tim Moores
Rancher
Joined: Sep 21, 2011
Posts: 2407
posted
0
JDBC does not exist for Android. You shouldn't use JDBC across the Internet anyway. I wouldn't use SOAP instead - REST should be the first approach these days.
Hardik Trivedi
Ranch Hand
Joined: Jan 30, 2010
Posts: 252
posted
0
Tim Moores wrote:JDBC does not exist for Android. You shouldn't use JDBC across the Internet anyway. I wouldn't use SOAP instead - REST should be the first approach these days.
I suggest you to use Awake SQL, a virtual JDBC Driver that is supported on Android with a dedicated packaging. Awake SQL is Open Source (LGPL v2.1).
Disclaimer: I'm the author of Awake SQL.
Awake SQL allows you to code JDBC calls in Android. The JDBC calls are routed through HTTP and executed on the remote server. The result is sent back using JSON.
The database is not accessed directly: the JDBC calls are filtered by a (configurable) Servlet on the remote server.
Awake SQL supports all major Open Source and commercial databases.