• ADF
    May 17, 2013

See the ADF Mobile local database in action

Guest Author

ADF Insider recordings are probable one of the best parts of my job. They are a lot of work, sure. But they are lots of fun to do and join so many members of the ADF Community... 

My latest recording is on the ADF Mobile local database. In it, I explore the various aspect of the feature and devote a healthy chunk of time to the management of the database file. The slides contain a few selected code snippets, but I thought it would be better to build a sample application to fully illustrate the concepts. In particular, I wanted to show how it is possible to retrieve data from either a web service or the local database while binding the UI to a POJO Data Control. 

My sample application  is made is made of two distinct components: 

   - A simple SOAP web service (SDO view object) built on the top of the HR database schema. 

   - The ADF Mobile application itself, that demonstrates local database techniques and calls the web service when a network is available. Data is fetched from the local database when their is no connectivity.

I contributed the application to the ADF Enterprise Methodology Group samples repository. It is not listed on the web pages right now, but you can download it from the following location:


My recording is available on our YouTube channel here: http://www.youtube.com/watch?v=-XzE1n_j5Nc

Join the discussion

Comments ( 3 )
  • guest Saturday, June 1, 2013

    Thanks, this is a very good info.

    I think an even more useful information would be how to do the write operation. When there is connectivity, use the web service to update the master database. When there is no connectivity, do the update in local database, changes are highlighted. As soon as the device comes in network, and gets connected, alert the user, and provide a mechanism where he can push the data from local database to master database.

    There are numerous real world cases, one of them could be how SRs or Service Requests are managed -

    If a customer has any complaint regarding product, he calls at the call center and a SR gets created. Everyday, Service Engineers are assigned a few SRs and they visit customer's site. Each Service Engineer has a mobile application with local database. Before leaving, they sync the application data with master database, as they may go to places where there is no network. When they visit the customer's place, they update the SR on their mobile. If they are within network coverage, this update is replicated in master database, and mobile application data is also synced with master database immediately. If not in network, the update will take place in local database, and as soon as they enter network, they can push it to master database with the click of a button.

    If we can get some sample on this, it will be very useful.

  • Blueberry Coder Monday, June 3, 2013

    Hi « guest ».

    Thanks for your comment. You raise a very important issue. I will try to answer your question through a blog entry in the next few days.

    Best Regards,


  • guest Wednesday, June 26, 2013

    Thanks for share very usefull information.


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.