B4J Question JRDC2 - can't get it to work

[derez]

I am trying to get it working but there are too many links and I get confused. I use the jrdc2 server example after changing the config.properties file to deal with animals (comment and uncomment the existing code). Used the attached code from another link for b4a client:

Sub Activity_Create(FirstTime As Boolean)
    If FirstTime Then
        reqManager.Initialize(Me, "http://192.168.0.180:54025/rdc")
    End If
    Activity.LoadLayout("1")
'    Dim cmd As DBCommand
'    cmd.Initialize
'    cmd.Name = "create_table"
'    reqManager.ExecuteCommand(cmd,"create")
End Sub

Sub btnSelect_Click
    Dim cmd As DBCommand
    cmd.Initialize
    cmd.Name = "select_animal"
    reqManager.ExecuteQuery(cmd, 0, Null)
End Sub


Sub JobDone(Job As HttpJob)
    If Job.Success = False Then
        Log("Error: " & Job.ErrorMessage)
    Else
        If Job.JobName = "DBRequest" Then
            reqManager.HandleJobAsync(Job, "ReqManager")
        End If
    End If
    Job.Release
End Sub

Sub ReqManager_Result(result As DBResult)
    reqManager.PrintTable(result)
End Sub

There was no table creation code so I added it but I get:

Class not found: b4a.example.main$_dbcommand, trying: b4j.example.main$_dbcommand
Class not found: b4j.example.main$_dbresult, trying: b4a.example.main$_dbresult

in B4j and B4a programs.
I don't understand what is missing.
Is my code correct ?
Can I have one example that is closed on itself with MySQL that works on my PC ?
Thanks.

 

[derez]

Thanks Erel and Cableguy, I'll check it tonight.

 

[derez]

I don't understand how it works. If I set the collation in phpmyadmin to utf8_bin, does it overrides what is written in config.properties file ? Do I have to create the table from there or alter the existing table ?
Edit: After I deleted the reference to character set in the config.properties it does not send errors but I changed both DB and table to utf8_bin but I get ????? instead of Hebrew letters. Tried many other but they all show ????? (?)

Another problem - DBRequestManager is initialized with an address. If there is no communication there is no event to show it until the program crashes. I'd like to keep it alive and use it with its internal DB instead, how to do it ?

 

[Erel]

Edit: After I deleted the reference to character set in the config.properties it does not send errors but I changed both DB and table to utf8_bin but I get ????? instead of Hebrew letters. Tried many other but they all show ????? (?)

Try to create a new database with a new table and make sure to set the collate to utf8.

Another problem - DBRequestManager is initialized with an address. If there is no communication there is no event to show it until the program crashes. I'd like to keep it alive and use it with its internal DB instead, how to do it ?

Please start a new thread for this.

 

[derez]

A new DB and table defined but the result is the same .
I'm working with a b4j client, is it possible that the output to the server is not correct ? It works fine with a SQLITE DB.

 

[Erel]

There are two collations that need to be set. One for the database and one for the table.

Try to get the value in the client. Maybe the problem is in phpmyadmin.

 

[derez]

There are two collations that need to be set. One for the database and one for the table.

Try to get the value in the client. Maybe the problem is in phpmyadmin.

the top picture is of the database, the second of the table.
It is not a problem of the phpmyadmin because I get the same in my logs.
I can't get the text from the DBrequestmanager.

 

[Erel]

Have you set the characterEncoding parameter in the config file?

JdbcUrl=jdbc:mysql://localhost/test?characterEncoding=utf8

 

[derez]

Have you set the characterEncoding parameter in the config file?

JdbcUrl=jdbc:mysql://localhost/test?characterEncoding=utf8

Yes, with it I get errors, without it I get ????? as text.

 

[Erel]

Which errors?

 

[derez]

Which errors?

No errors any more and it works with Hebrew. I guess all the previous tests were done with some definition missing.
Thank you for the trouble and big help