Android Question For / next cycle with JobDone

Status
Not open for further replies.
M

marcos

Member
Licensed User
Longtime User
I need to retrieve the records from a db sqlite and pass them to a web service through job.PostString.
only the last record is passed to the web service, also If cursor1.RowCount> 0. where am I wrong? how can i pass all the records?

B4X: 
Job.Initialize("Job", Me)

    cursor = SQL1.ExecQuery("SELECT * FROM nome")
                      
    If cursor.RowCount > 0 Then
        For i = 0 To cursor.RowCount - 1
            cursor.Position = i
          
       Job.PostString(WS,"nome="&cursor.GetString("nome")&" ")
    Next
 
Sort by date Sort by votes
M

marcos

Member
Licensed User
Longtime User
Sorry it's perfect for sdkVersion <17, but with Android 9 it always goes wrong.
B4X: 
If cursor1.RowCount > 0 Then
        For i = 0 To cursor1.RowCount - 1
            cursor1.Position = i

                j.Initialize("", Me)
                    j.PostString(WS,"a="&cursor1.GetString("name")&"")
                Wait For (j) JobDone(j As HttpJob)
                Log(j.GetString)
                            If j.Success = True Then
                
                Msgbox("ok")
            End If
            j.Release
        Next

mistake :
Log(j.GetString) = java.io.FileNotFoundException: /data/user/0/xxxxxxxxxxxxxx/cache/1 (No such file or directory).


what can it be ? the data in cursor1.GetString ("name") is present :-(
 
Upvote 0

OliverA

Expert
Licensed User
Longtime User
You’re logging j.GetString before testing if j.Success is true. If j.Success happens to be false, j.GetString will have no content and throw this error. Also you are not logging j.ErrorMessage in case j.Success is false, so it’s hard to tell what is going on.
 
Upvote 0

Computersmith64

Well-Known Member
Licensed User
Longtime User
B4X: 
If j.Success = True Then
    Msgbox("ok")
End If

Don't use Msgbox for logging. Use Log("ok") instead & you won't interrupt your loop.

- Colin.
 
Upvote 0
M

marcos

Member
Licensed User
Longtime User
ok. I ran Log( j.ErrorMessage) is receive error : javax.net.ssl.SSLHandshakeException: Connection closed by peer...... for sdk version 28, while it is ok for sdk version 23 why ? help me :-(
 
Upvote 0
Status
Not open for further replies.

Similar Threads

  • Question
Android Question CloudKVS: waiting for events from another module?
Replies
6
Views
928
Dave O
  • Question
Android Question Upload to Play Store failed
Replies
6
Views
1K
Tjitte Dijkstra
M
  • Question
Android Question Button_Down, Button_Up events fire twice
Replies
2
Views
2K
MartinR
M
G
  • Question
Android Question CustomView: EditText border color
Replies
11
Views
3K
netsistemas
  • Question
Android Question Get your current position : geo lat,long and address
Replies
4
Views
2K
imbault
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…