Android Question Remote server connection how to port B4J code (working) to B4A (SQL.InitializeAsync)

[Diego Marcelo Croatto]

Hi to all programmers.
I have a MariaDB server working in a Rasberry Pi (all Ok)
I tested the folow code to get data over Wifi from my PC in B4J and works fine.
I need port it to Android and I have problems with the connection and some libraries can ayone help me?.... Thank's a lot

The log Result is:

The working code in B4J its simple as....

'Non-UI application (console / server application)
#Region Project Attributes
    #CommandLineArgs:
    #MergeLibraries: True
#End Region

    'MariaDB Connector/J Driver
    #AdditionalJar: mariadb-java-client-2.4.2.jar

Sub Process_Globals
    Private SQL As SQL
    Dim RS As ResultSet
    
#Region Database Location
    Private DBLocation As String = "192.168.xxx.xxx:1818" '<-- IP address
    Private DBUsername As String = "user" '<-- DB user name
    Private DBPassword As String = "123456" '<-- DB password
    Private SQLCommand As String            '<-- Auxiliar string to see the text
    
#End Region
End Sub

Sub AppStart (Args() As String)

    LogError("---------- NorthWind Database (MariaDB) ----------")
    SQLCommand=$"jdbc:mariadb://${DBLocation}:3306/"$                         
    SQL.InitializeAsync("MariaDB", "org.mariadb.jdbc.Driver",SQLCommand , DBUsername, DBPassword)
    SQL.Close
    StartMessageLoop 'only required in a console app

End Sub

'Return true to allow the default exceptions handler to handle the uncaught exception.
Sub Application_Error (Error As Exception, StackTrace As String) As Boolean
    Return True
End Sub

'Connected to MariaDB SQL Server
Sub MariaDB_Ready (Success As Boolean)
    
    If Success Then
        RS = SQL.ExecQuery("SELECT x.* FROM TabletsDB.Calibracion x")
        
        Do While RS.NextRow
            Log(RS.GetString2(0)) 'First register
            Log(RS.GetString2(1))
            Log(RS.GetString2(2))
            Log(RS.GetString2(3))
            Log(RS.GetString2(4))
            Log(RS.GetString2(5))
            Log(RS.GetString2(6))
            Log(RS.GetString2(7)) 'Last register
        Loop
        
        RS.Close
        
    End If
    StopMessageLoop 'only required in a console app
End Sub

 

[Erel]

If mariadb-java-client-2.4.2.jar is compatible with Android then you can use the JdbcSQL library. It is identical to B4J jSQL library.

However a better solution is to run a middleware such as jRDC2.

 

[Diego Marcelo Croatto]

Well... I try a lot of time and nothing.... in left monitor I test the B4A code with JdbcSQL (not working) and in the right monitor the B4J code with JSQL library (the reference working OK)

Both (B4A and B4J) are the same additional line

#AdditionalJar: mariadb-java-client-2.4.2.jar

The B4J Connection code (working)

    SQLCommand="jdbc:mariadb://192.168.1.59:3306/"                         
    SQL.InitializeAsync("MariaDB", "org.mariadb.jdbc.Driver",SQLCommand , DBUsername, DBPassword)
    SQL.Close

And the B4A Connection code (not working)

    SQLCommand="jdbc:mariadb://192.168.1.59:3306/"                        
    sql1.InitializeAsync("MariaDB", "org.mariadb.jdbc.Driver",SQLCommand , DBUsername, DBPassword)
    sql1.Close

And the same Sub for read one row with 8 columns

'Connected to MariaDB SQL Server
Sub MariaDB_Ready (Success As Boolean)
    If Success Then
        RS = sql1.ExecQuery("SELECT x.* FROM TabletsDB.Calibracion x")
        Do While RS.NextRow
            Log(RS.GetString2(0))
            Log(RS.GetString2(1))
            Log(RS.GetString2(2))
            Log(RS.GetString2(3))
            Log(RS.GetString2(4))
            Log(RS.GetString2(5))
            Log(RS.GetString2(6))
            Log(RS.GetString2(7))
        Loop
        RS.Close
    End If
End Sub

This is the connection results (Debugging) of B4A in sql1 --> Connection is null (all is null)

This is the connection results (Debugging) of B4J in SQL --> Connection is with data

What I do wrong?.... what is the error in the Android platform? The WiFi connection its Ok between the android device and the DB server.
Thank's a lot for the help.

 

[Erel]

What is the purpose of this strange code:

SQLCommand="jdbc:mariadb://192.168.1.59:3306/"                        
    sql1.InitializeAsync("MariaDB", "org.mariadb.jdbc.Driver",SQLCommand , DBUsername, DBPassword)
    sql1.Close

?

Post the output of this code:

sql1.InitializeAsync("MariaDB", "org.mariadb.jdbc.Driver",SQLCommand , DBUsername, DBPassword)
 Wait For MariaDB_Ready (Success As Boolean)
 Log(Success & ": " & LastException)
sql1.Close