Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


html5 web sql transactions skipped without error when touch triggered in ios using -'javascript,iphone,sql,ios,html5'


html5 web sql transactions skipped without error when touch triggered in ios  using -'javascript,iphone,sql,ios,html5'

I'm experiencing problems making database transactions on IOS devices.
If the user doesn't touch the phone, everything works like expected.
If the user taps/scrolls/touches the screen, some transactions directly call their successCallback, without ever calling the actual transaction callback.

Simplified example here: http://jsfiddle.net/Tk9rv/

To test, just open http://jsfiddle.net/Tk9rv/embedded/result/ in your mobile safari on IOS and do not touch the device while loading. You will see a list of debug messages being generated looking like this:

database is running
table will be cleared
store method called for '10'.
about to insert '10'.
transaction successful for '10'
store method called for '9'.
about to insert '9'.
transaction successful for '9'
store method called for '8'.
about to insert '8'.
transaction successful for '8'
[...]


Now, reload the page and while loading, scroll and tap randomly.
You will see some "about to insert..." messages are missing.

database is running
table will be cleared
store method called for '10'.
about to insert '10'.
transaction successful for '10'
store method called for '9'.
about to insert '9'.
transaction successful for '9'
store method called for '8'.
transaction successful for '8' <-- WHERE IS MY "about to insert '8'." ???
store method called for '7'.
about to insert '7'.
transaction successful for '7'
[...]


This is because the transactionCallback is completely skipped! But WHY? And WHY does the successCallback fire instead of the errorCallback?

[This is a simplified example, please do not tell me not to do this setTimeout stuff. In the real world, there is data being loaded async and then being inserted... :) ]

I think there is a similar problem here HTML5 Web SQL transaction Missing In Action but there is no solution or hint either.

Any ideas? I'm stuck... Thanks!
    

asked Sep 7, 2015 by rajesh
0 votes
18 views



Related Hot Questions



Government Jobs Opening


...