IBM Worklight retrieving data from SQLite to MySQL

Question

I am developing a Worklight Android native app. I have a local database - SQLite to store some data and I want to transfer the data to server-side MySQL database. I am using Worklight SQL Adapter for communication with MySQL but as long as I know the adapter is not usable for retrieving local data. How can I make the transfer from the local database to the remote one? Thanks in advance

Answer 1

You cant use adapters for accessing local DB. however you can fetch the data using native way and send the same to SQL adapter to save it in MySQL database.

For more info

• If you are using Hybrid use Coredova API
• SO Answer
• if you are only using native code see this Article get the data and send it to WL adapter by invoke procedure

AFAIK there is no way to send data's from SQLite to backend DB. you can do the above workaround.