B4J Question Result Set close on error

[Philip Prins]

Hello,

Do you need to close the resultset or cursor when you use Try Catch ?

Example

Try

        Dim RS As ResultSet =
        
        Do While
        
        Loop
        
        
        RS.close
        
Catch
        RS.close 'Is this neccesary?
End Try

 

[DonManfred]

Try Dim RS As ResultSet = Do While Loop RS.close

the rs.close is never reached after the loop as it never ends....

Dim RS As ResultSet =
Do While rs.NextRow
Loop
RS.close

 

[Erel]

It is probably an overkill.

Note that you can write it like this:

Try

        Dim RS As ResultSet =
        
        Do While
        
        Loop
        
        
        
Catch
    Log(LastException)
End Try
  RS.close

Assuming that it is a local SQLite db then there is no real reason for an unexpected error to happen. If it is a remote db then you should use a pool and make sure to close the connection (which will close other resources as well).