Sqlite Plugin Issue

[Duncan]

I'm building an app and it has gone very well however, on the first time being loaded the App populates its own local sqlite database from an XML file. On the simulator and on iPhone devices this works fine however when I deploy to any Android device the App wont do any inserts the first time it is run but if I force quit and rerun the app it works and does the database commands perfectly.

Does anyone have any idea what could possibly be the cause of this and how to solve it? I have tried delaying the sql functions in case the local storage wasn't yet initiated but that hasn't helped either.

Many Thanks
Duncan 

[Steve]

Hi Duncan,

We have the following questions/suggestions:

• does this problem occur if you deploy and run our sqlite sample (https://github.com/Icenium/sample-sqlite.git)? If not please compare the code in order to identify the culprit.
• does this problem occur on any Android device? What Android versions have you tried it on and on what device?
• what Cordova version does your project target? Open your project properties and make sure you're targeting Cordova 2.7, you would also need to change the Sqlite plug-in to v.0.3.

Regards,
Steve
Telerik

Looking for tips & tricks directly from the Icenium team? Check out our blog!
Missed our first webinar, watch it here.
Share feedback and vote for features on our Feedback Portal.

[Rehana]

Dear Steve,

 

I am using the sample -sqlite app but when i run it in simulator it works fine but when it is deployed on device by building .apk in build.phonegap.com, it doesnot support sqlite.

 

what is the issue. i am googling for 3 weeks but cannot find answer.

 

please help.

[Tina Stancheva]

Hello Hanna,

If you're using this SQLite sample app, then it should work in both the AppBuilder Device Simulator and when deployed on a device. However, note that this application is built within AppBuilder and in order to deploy it on a device, you should use AppBuilder's build services and follow the procedure outlined in our documentation.

Let me know if you have any questions on the above procedure.

Regards,
Tina Stancheva
Telerik

 

 

[Rehana]

Dear Tina,


Just this SQLite sample app works fine in simulator and device, all other apps i have developed are not working when deployed on device. although i have all the procedures followed. I am attaching the source code of one of my app. please help. I shall be thankful as i am stuck with this more than a month. googling is not helpful :(


Regards,


Rehana Baloch,

[Tina Stancheva]

Hi Rehana,

You won't be able to attach your solution in a forum post. Instead, you'll need to take advantage of our support ticketing system and submit a support ticket where you can attach your project and any additional information you find relevant. The support system assigns a response time for all of your questions, depending on your license and ensures that all questions will reach the respective technical support engineers. In addition, you will be able to review your support history at your leisure. In this way your issues will be managed more precisely.

Please have a look at our purchasing page for more information on the support packages included with every subscription.

Once we receive your ticket with the attached project, I will examine it and advise you how to proceed.

Regards,
Tina Stancheva
Telerik

 

 

[Rehana]

thanks for the instant reply. please tell where i can share the source code. 

[Tina Stancheva]

Hello Rehana,

You need to submit a support ticket - you can use this link to submit a ticket. Note that in order to access the support ticketing system you will have to log in Telerik with an account that is associated with an active support subscription for Telerik Platform.

Regards,
Tina Stancheva
Telerik