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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]>
> > 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 <[email protected]> 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
> > [email protected]
> > > > To unsubscribe from this group, send email to
> > > > [email protected]<android-developers%[email protected]>
> > > > 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 [email protected]
> > To unsubscribe from this group, send email to
> > [email protected]<android-developers%[email protected]>
> > 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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
