Need an android mobile application for bidirectional data sync.
1 - to sync oracle data to sqllite database on android
2 - to sync sqlite data to oracle database on remote machine
A small group of people will enter instant servise data to their android mobile phone and android application will check internet in some period and when finds, it will connect to oracle database on remote machine and will send data on sqlite database on mobile phone to remote oracle database.
At the same time when mobile phone connect internet and then connect oracle database and after send data to remote oracle machine, also when some data inserted or updated on oracle database adroid application will update sqlite database with the oracle database data. In short, when mobile application finds internet and connect remote oracle database bidirectional sync will be done. There will be many people using mobile phone and entering their data. Around 40 people will use mobile phone.
Data types will be datetime, text, integer and decimal values.
Around 10 tables wil be used for bidirectional sync.
Also location information of user while entering data will be kept in dababase.
To do this android application will open GPS to learn location.
For an exapmpe aplication check the following link;
[url removed, login to view]
Also we need source code of android application