Android Question Use service module to execute database routines

Discussion in 'Android Questions' started by Anser, Mar 14, 2015.

  1. Anser

    Anser Well-Known Member Licensed User

    Hi all,

    I am looking for a basic sample that uses 2 activities and a service module. The activities will request the service module to:-

    1. return the results of queries
    2. do the inserts new records to the database
    3. updates the records in the database etc etc.

    I don't want each activity to have individual database connection objects, because when switching from one activity to another I will have to close the connection with the database, then on the new activity I will have to create a new connection object and then connect to the database. All these will slow down the apps performance.

    What I am looking for is that when my app starts the service module should also start and will connect to the database and will be ready to serve the requests from other activity modules of my app. When my app quits, the service would close the connection to the databse and the service should also be destroyed. So the connection to the database is established only once (I may have to handle connection timeout too), the database connection is closed once I quit the app.

    I don't know whether the above said is the right approach or not OR whether this can be achieved using B4A.

    I understand that, from the activities I should use Result = CallSubDelayed2(ServiceModuleName, SubNameToBeCalled,ParameterToBePassed). It will return the data as a list/list of Maps etc

    I searched the forum but could not locate anything similar to what I need when it comes to a service module and database.

    A basic skeleton of a service module would be fine. A push in the right direction will be appreciated. This will be useful for newbies like me.

    Regards
    Anser
     
  2. Reviewnow

    Reviewnow Active Member Licensed User

  3. Anser

    Anser Well-Known Member Licensed User

    I understand that DButils is for managing SqLite database. I am using MySQL.
     
  4. edgar_ortiz

    edgar_ortiz Active Member Licensed User

    You can not "run" MySql on android device.

    If your database is in a server you must use "Web Service" to access the data.

    Regards,

    Edgar
     
  5. Anser

    Anser Well-Known Member Licensed User

    Edgar,

    My B4A app will be connecting to a remote MySQL database available on the Internet cloud.

    I am aware about the different solutions available here to connect to a remote MySQL for eg php, RDC, MySQL lib etc.

    Regards
    Anser
     
  6. edgar_ortiz

    edgar_ortiz Active Member Licensed User

    Hi,

    You can check:

    http://www.b4x.com/android/forum/threads/connect-android-to-mysql-database-tutorial.8339/

    http://www.b4x.com/android/forum/th...connector-rdc-connect-to-any-remote-db.31540/

    http://www.b4x.com/android/forum/threads/connect-android-to-mysql-database-tutorial.8339/#content

    I have few apps that use My-Sql in the server and Sqlite in the phone and I'm using a web service in PHP that only send the information to the database and then process the response.

    And everything runs fine.

    Regards,

    Edgar
     
  7. Anser

    Anser Well-Known Member Licensed User

    Edgar,

    Really appreciate your effort to help me.:)

    I am looking for a sample or some inputs/advices from the fellow members here on how to use the database via a service module in the app.

    I was able to locate a file downloading service sample. May be I can use that as a base to start off with my Service module coding.

    Regards
    Anser
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice