See the ADF Mobile local database in action

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:

https://svn.java.net/svn/smuenchadf~samples/ADFMobileLocalDatabase.zip

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

Comments:

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.

Posted by guest on June 01, 2013 at 12:56 AM EDT #

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,

Frédéric.

Posted by Blueberry Coder on June 03, 2013 at 01:17 PM EDT #

Thanks for share very usefull information.

Regards,

Posted by guest on June 26, 2013 at 01:26 AM EDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Frédéric Desbiens

The musings of a member of the ADF Product Management team.

I focus here on my favorite development framework but also have a strong interest in Mobile Development, Oracle WebCenter and Oracle SOA Suite.

Attentive readers will even find posts about IT Strategy from time to time, an interest of mine since I completed my MBA in 2006.

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today