[android-developers] Re: Accessing External Database

2010-03-25 Thread uday kiran
Thanks for correcting me bob.. I saw so many mails regarding this JDBC drivers in stackoverflow.. I finally decided to use RESTful webservice instead of JDBC drivers.. I've gone through one example code at http://senior.ceng.metu.edu.tr/2009/praeda/2009/01/11/a-simple-restful-client-at-android/

Re: [android-developers] Re: Accessing External Database

2010-03-25 Thread Mark Murphy
uday kiran wrote: Thanks for correcting me bob.. I saw so many mails regarding this JDBC drivers in stackoverflow.. I finally decided to use RESTful webservice instead of JDBC drivers.. I've gone through one example code at

[android-developers] Re: Accessing External Database

2010-03-25 Thread Bob Kerns
I'll second Mark's advice about where to go for REST help. I've done my job here by pointing you away from JDBC on Android. Going to more appropriate sources of information for REST will help you a lot, because you'll get answers to questions you don't even know how to ask right now. Seriously,

[android-developers] Re: Accessing External Database

2010-03-24 Thread Bob Kerns
Brion gave some good suggestions, so let me address this from a more architectural standpoint. You don't WANT to access the tables direction. A web service acts as an intermediary -- it sits between your application and the database. This allows more control over how the application can access

[android-developers] Re: Accessing External Database

2010-03-22 Thread uday kiran
So, if we r using RESTful webservice is it possible to access the Tables present in the database??? and doing some operations on the database i.e) Adding/Deleting a row/ column into the database table?? I saw one example which uses JSON Object for getting the stream.. So if i want to access

[android-developers] Re: Accessing External Database

2010-03-22 Thread Brion Emde
I recommend that you take a look at an existing RESTful implementation and see how that works and you may be able to see how to do what you are doing. I think a beautiful example of RESTful architecture is that provided by Twitter. You can browse the Twitter API WIKI at:

[android-developers] Re: Accessing External Database

2010-03-19 Thread uday kiran
Hey Bob,, Tell me one thing...instead of using Webservices,it is easy if we r using Drivers.. If we know which type of database they r using on server side,then we can access that database using related driver...so that the headache willl be reduced am i right??? what is the difference of using

[android-developers] Re: Accessing External Database

2010-03-19 Thread Bob Kerns
No, you get a different set of headaches. Drivers (e.g. JDBC drivers) are not intended for this sort of application. You will have reliability problems, security problems, performance problems, problems upgrading your server once you have clients talking to it, because you can't upgrade all your

[android-developers] Re: Accessing External Database

2010-03-18 Thread Bob Kerns
OK, it seems there's several things going on here. From your URL, it looks like you can download a copy of a sqllite database file. If this is just static content, that you're treating as a document -- then you don't need any of what I've been talking about so far. At this level, you have a

[android-developers] Re: Accessing External Database

2010-03-18 Thread uday kiran
On Mar 18, 11:49 am, Bob Kerns r...@acm.org wrote: OK, it seems there's several things going on here. From your URL, it looks like you can download a copy of a sqllitedatabasefile. If this is just static content, that you're treating as a document -- then you don't need any of what I've

[android-developers] Re: Accessing External Database

2010-03-18 Thread cellurl
Look at line 395 of this sql access. It hits a php file I can send you if you go this route. Good Luck. jp http://code.google.com/p/speedlimit/source/browse/BackSeatDriverV-X-Ship-Pulp/src/org/wikispeedia/backseatdriverV/TranslateTask.java -- You received this message because you are subscribed

[android-developers] Re: Accessing External Database

2010-03-18 Thread Bob Kerns
On Mar 18, 2:37 am, uday kiran uday.pic...@gmail.com wrote: - So for communicating database(On remote server)  from our application - it is compulsory to write a driver like odbc??? No, ODBC (or JDBC) is at the wrong level. You do not want to be doing SQL over the network. Instead, you want to

[android-developers] Re: Accessing External Database

2010-03-17 Thread uday kiran
Thanks for ur quick reply jim.. I want to access an existing database which is present on some server.. Cheers Uday On Mar 17, 6:51 pm, Jim Blackler jimblack...@gmail.com wrote: Hi Uday Is there an existing, specific external database that you wish to access? Or do you wish to set up a new

Re: [android-developers] Re: Accessing External Database

2010-03-17 Thread Jim Blackler
OK what can you tell us about this database. Is it on the internet? What software is it running? On 17 March 2010 13:54, uday kiran uday.pic...@gmail.com wrote: Thanks for ur quick reply jim.. I want to access an existing database which is present on some server.. Cheers Uday On Mar 17,

[android-developers] Re: Accessing External Database

2010-03-17 Thread uday kiran
YES..The database is present on the internet only.. The database should be in SQLite..OS is windows.. On Mar 17, 6:59 pm, Jim Blackler jimblack...@gmail.com wrote: OK what can you tell us about this database. Is it on the internet? What software is it running? On 17 March 2010 13:54, uday

[android-developers] Re: Accessing External Database

2010-03-17 Thread uday kiran
As of my knowledge in android we use HttpURLConnection to connect to the database in the internet.. am i right Jim?? On Mar 17, 7:05 pm, uday kiran uday.pic...@gmail.com wrote: YES..The database is present on the internet only.. The database should be in SQLite..OS is windows.. On Mar 17,

Re: [android-developers] Re: Accessing External Database

2010-03-17 Thread Jim Blackler
Provided the database exposes an HTTP-based API, yes. On 17 March 2010 14:09, uday kiran uday.pic...@gmail.com wrote: As of my knowledge in android we use HttpURLConnection to connect to the database in the internet.. am i right Jim?? On Mar 17, 7:05 pm, uday kiran uday.pic...@gmail.com

[android-developers] Re: Accessing External Database

2010-03-17 Thread uday kiran
OK... u have any example code which is used to work on this concept?? On Mar 17, 7:11 pm, Jim Blackler jimblack...@gmail.com wrote: Provided the database exposes an HTTP-based API, yes. On 17 March 2010 14:09, uday kiran uday.pic...@gmail.com wrote: As of my knowledge in android we use

Re: [android-developers] Re: Accessing External Database

2010-03-17 Thread Jim Blackler
Hi Uday, I have to bow out here because this is too general a question for this list really. There are a great many ways to do what you are describing. I'd recommend getting a textbook or two on the topic. On 17 March 2010 14:13, uday kiran uday.pic...@gmail.com wrote: OK... u have any example

[android-developers] Re: Accessing External Database

2010-03-17 Thread uday kiran
okk. i may get the quick reference if i go to http://developer.android.com site?? Where this funtionality is to be added in android code?? in onCreate() method? On Mar 17, 7:16 pm, Jim Blackler jimblack...@gmail.com wrote: Hi Uday, I have to bow out here because this is too general a question

[android-developers] Re: Accessing External Database

2010-03-17 Thread Bob Kerns
Please don't do this. You really, really don't want to do this. I've written about this before -- it's the wrong way for a lot of reasons -- security, interoperability, performance, maintainability, upgradability, compatibility with firewalls... What you want to do instead, is to build a web

[android-developers] Re: Accessing External Database

2010-03-17 Thread uday kiran
Thanks Bob, I got very good information from this... Let me explain thing i want to do.. There is a database present at some IP http://10.117.23.45/databases/database.db I want to access this database from my android application.. for this im using HttpURLConnection interface.. The way that im