Android Question App hanging

[gbzrope]

Help?

I have a data collection app connecting to a remote MySQL database using JDBC.
It connects to the server and downloads any new jobs, and uploads any new data previously collected.

It was working fine - until a week ago when the user reported that when they pressed the [Update Jobs] button the app showed the Please Wait message and then after w minute or so a system message pops up "Roads4Android Has Stopped Working."

I ran it on my own tablet and it was fine. Mine is an older Galaxy than theirs, so I ran the emulator on the samve Android version as theirs, it worked fine here, but when installed on their tablet it did the same thing.

Today on my own tablet I tried the app - and it did the same thing! -- crashed.

So I hooked up my tablet to B4A Bridge and ran in debug - worked fine! Compiled and installed Release and it crashes.

I note I now get an error if I remove breakpoints:

Error occurred on line: 295 (Starter)
java.lang.NullPointerException
at RoadsForRiggots.b4a.mainoptions$ResumableSub_cmdUpdateDB_Click.resume(mainoptions.java:1155)
at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resumeAsUserSub(DebugResumableSub.java:48)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:515)
at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:733)
at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:355)
at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:515)
at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
at anywheresoftware.b4a.BA.raiseEvent(BA.java:171)
at anywheresoftware.b4a.shell.DebugResumableSub$DelegatableResumableSub.resume(DebugResumableSub.java:43)
at anywheresoftware.b4a.BA.checkAndRunWaitForEvent(BA.java:245)
at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:137)
at anywheresoftware.b4a.BA.raiseEvent(BA.java:171)
at anywheresoftware.b4a.keywords.Common$14.run(Common.java:1736)
at android.os.Handler.handleCallback(Handler.java:733)
at android.os.Handler.dispatchMessage(Handler.java:95)
at android.os.Looper.loop(Looper.java:136)
at android.app.ActivityThread.main(ActivityThread.java:5479)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:515)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1283)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1099)
at dalvik.system.NativeStart.main(Native Method)

 

[Erel]

Which library are you using to connect to the database? Can you post the relevant code?

 

[gbzrope]

Which library are you using to connect to the database? Can you post the relevant code?

Using the jdbcSql 1.5 library

I think I have sorted it - there was a Resumable Sub that was not returning a value (success)

 

[Erel]

Make sure to only make async calls. Synchronous calls will cause your app to hang.