The first thing you should do is write an application on a desktop PC
to do the DB accesses you want (without using interfaces unavailable
on Android). Work it out there, and then figure out how to map it to
Android.
On Oct 19, 4:58 am, "goodwin" <weigoodw...@gmail.com> wrote:
> Hi Kumar
>
> I don’t think google will let people lay any other .jar file , unless you
> rebuild the source code of android.
>
> /////////////////////////////////////////////////////////////////////////////
>
> i will try using sqldroid library to my needs, i will try to connect
> to a remote mysql dabatabase, not sqlite and not local
>
> but im having some problems, plz can someone help me?
>
> - how can i add sqldroid-0.1.jar to my project (sorry but i am
> newbie and i can't find nothing about adding this to a project)
>
> - where i have to put these two lines?
> Class.forName("SQLite.JDBCDriver");
> DriverManager.getConnection("jdbc:sqlite:/data/data/your-package/
> db.sqlite");
>
> - in the connection code, wich lines i have to change to connect to my
> remote database? my database is on 81.111.190.170:3306
>
> thanks
>
> On 19 oct, 11:33, Kumar Bibek <coomar....@gmail.com> wrote:
>
>
>
> > As far as I can imagine, the whole concept of having a library that could
> > connect to a remote DB is not worth for a mobile platform. You are not
> > writing a desktop app anyway, which would require the whole DB with all it's
> > features exposed through a remote DB connection. It too much for a mobile
> > app I would say. Apart from the security issues, if at all you get a direct
> > connection to a remote DB, then there is no point in keeping a local DB,
> > which is bad in various situations (no network connectivity). In case you
> > are having a local DB as well, don't you think it's redundant duplication of
> > data, and also, don't you think that your code will also be more? Well, if
> > you have a webservice over your DB on your servers, you still have to write
> > extra bit of code, but then, you will only deal with functions that the
> > webservice exposes, and thus, you would be handling a subset of all possible
> > situations, if it would have been a direct DB connection.
>
> > Another issue I might think can come up very soon, is that you are looking
> > for a MySQL version library. If at all there are any for Android, I am sure,
> > they are not yet matured enough to use in an enterprise level setup. You
> > might want to change the DB to Oracle, or SQL server, are you sure that
> > these libraries can really handle that well? I personally don't think so.
> > May be in the future, they will be available,
>
> > BUT RIGHT NOW, Use a webservice and SQLite, I would suggest.
>
> > On Tue, Oct 19, 2010 at 2:50 PM, saex <elpablos...@gmail.com> wrote:
> > > i check that library and it's for LOCAL SQLITE databases!
>
> > > i am talking about remote mysql dabatabases, not sqlite and not local
>
> > > greets
>
> > > On 19 oct, 08:36, Miguel Morales <therevolti...@gmail.com> wrote:
> > > > There is nothing implemented into the standard SDK to directly connect
> > > > to a MySQL database.
> > > > Your best bet might be to use something like an external library such
> > > > as:http://code.google.com/p/sqldroid/
> > > > I've never used this myself though.
>
> > > > On Mon, Oct 18, 2010 at 11:29 PM, JonFHancock <jonfhanc...@gmail.com>
> > > wrote:
> > > > > Not that I'm aware of, but remember that any code executed on a
> > > > > machine you do not control is untrusted. It would be all too easy for
> > > > > someone to modify your code in a way that can make calls to your db
> > > > > that corrupt the db.
>
> > > > > Making a php or java server-side application that you can just send
> > > > > http post data to is way too easy to justify the risk.
>
> > > > > On Oct 18, 2:29 pm, saex <elpablos...@gmail.com> wrote:
> > > > >> Hi
>
> > > > >> can i do it? I just wanna make SELECT/INSERT into a remote database
> > > > >> with my android phone application, i think it have to be easy but i
> > > > >> can't find the way. I only find people that tell i have to make a
> > > > >> webservice os romething like that, but that is another world for me,
> > > > >> and i can't put a webservice in the database host...
>
> > > > >> ¿there is not a normal way to do it without a webservice?
>
> > > > >> thanks
>
> > > > > --
> > > > > You received this message because you are subscribed to the Google
> > > > > Groups "Android Developers" group.
> > > > > To post to this group, send email to
> > > android-developers@googlegroups.com
> > > > > To unsubscribe from this group, send email to
> > > > > android-developers+unsubscr...@googlegroups.com<android-developers%2bunsubscr...@googlegroups.com>
> > > > > For more options, visit this group at
> > > > >http://groups.google.com/group/android-developers?hl=en
>
> > > > --
> > > > ~ Jeremiah:9:23-24
> > > > Android 2D MMORPG:
> > >http://developingthedream.blogspot.com/,http://www.youtube.com/user/r...
>
> > > --
> > > You received this message because you are subscribed to the Google
> > > Groups "Android Developers" group.
> > > To post to this group, send email to android-developers@googlegroups.com
> > > To unsubscribe from this group, send email to
> > > android-developers+unsubscr...@googlegroups.com<android-developers%2bunsubscr...@googlegroups.com>
> > > For more options, visit this group at
> > >http://groups.google.com/group/android-developers?hl=en
>
> > --
> > Kumar Bibekhttp://techdroid.kbeanie.comhttp://www.kbeanie.com
>
> --
> You received this message because you are subscribed to the Google
> Groups "Android Developers" group.
> To post to this group, send email to android-developers@googlegroups.com
> To unsubscribe from this group, send email to
> android-developers+unsubscr...@googlegroups.com
> For more options, visit this group
> athttp://groups.google.com/group/android-developers?hl=en
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
