Android Question JdbcSQL InitializeAsync timeout

[Drago Bratko]

Is there a way to catch timeout on InitializeAsync method in JdbcSQL?

In this code:

    MSQL.InitializeAsync("mssql", driver, jdbcUrl, Username, Password)
    Wait For mssql_Ready (Success As Boolean)
    Return Success

I always get "true" when is OK connected, but never "false" (even if it can't connect) ... it looks to me as there is no timeout set for InitializeAsync (or I didn't set it up).

 

[teddybear]

There is a timeout set to 30 seconds here, when connection is failed Success is false. you can test it by changing jdbcURL or deploying a local mysql,
Check if there is a firewall in your network.

 

[Drago Bratko]

Hmm ... on my side, I receive or true if all is fine, or nothing (event mssql_Ready is not trigered) if it can't connect.

 

[Drago Bratko]

For the record, I did it in this way ... simulate Wait For with timeout:

Sub Connect As ResumableSub
    MSQL.InitializeAsync("mssql", driver, jdbcUrl, Username, Password)
    TimeoutImpl(8, "mssql_Ready")
    Wait For mssql_Ready (Success As Boolean)
    Return Success
End Sub

Sub TimeoutImpl(Duration As Int, EventName As String)
    Do While Duration > 0
        Sleep(1000)
        Duration = Duration - 1
    Loop
    CallSubDelayed2(Me, EventName, False)
End Sub

 

[josejad]

Maybe this post can help

Post in thread '[B4X][B4XLib] WaitForWithTimeout --> TimeoutHandler'
https://www.b4x.com/android/forum/t...withtimeout-timeouthandler.110703/post-690966

 

[Drago Bratko]

Exactly, my code is combination of great Erel's example.