Android Question jRDC2

[aLya121314]

Why the log(res.Columns) says "object converted to string. This is probably a programming mistake." And everytime i Debug the program, supposedly it will display the items the data stored in the database, but it didn't. What could be the problem? Can anyone here could help me. Thanks a lot.

i used jRD2 to connect it to mySql xammp. For the database. I used phpMyAdmin.

 

[DonManfred]

Please use File-Export as ZIP in the IDE to export a Project.

 

[aeric]

Are you following exactly like in tutorial with same database name?

 

[aLya121314]

Please use File-Export as ZIP in the IDE to export a Project.

Thanks, here's the zip file.

 

[aLya121314]

Are you following exactly like in tutorial with same database name?

Yes. I found a video tutorial in youtube and just follow everything it said. But then, when I tried to debug the program, it wont display the data from the database which is phpMyAdmin

 

[aLya121314]

Im actually a student. And trying to learn B4a for as a requirement in our course, we need to create a program. And our group decided to create a mobile application, specifically an online e-commerce app and it should have a database. Also an administrator will handle the app to post some products to sell. Then I found this tutorial in youtube and follow everything it says. But then when I debug the program, I encounter that problem.

Is there any recommendation database that is suitable to the project I am creating? It would be a great help for me though. Thank you so much

 

[Erel]

Why the log(res.Columns) says "object converted to string. This is probably a programming mistake."

Ignore it. It is just a warning on a Log line.

What do you see when you run the program?

 

[aLya121314]

Ignore it. It is just a warning on a Log line.

What do you see when you run the program?

Thank you.

Supposedly, the data from phpMyAdmin(tha database im using) will appear in the list view. But it didnt.

 

[Erel]

What is the output of this line: req.PrintTable(res) ?

 

[aLya121314]

What is the output of this line: req.PrintTable(res) ?

There is no output too.

I view the jRDC in b4j, then I found an error message.

 

[Erel]

There is no error message here.

You need to do some debugging. Check the server logs while sending a query.

Check your config file.

 

[OliverA]

1)

I view the jRDC in b4j, then I found an error message.

Even though you are using a newer driver (8.0.17) for MySQL, you still are using an old DriverClass configuration in your config.properties of the jRDC2 server. So instead of

DriverClass=com.mysql.dbc.Driver

change it to

DriverClass=com.mysql.cj.jdbc.Driver

and that warning message will go away.

2)

Why the log(res.Columns) says "object converted to string. This is probably a programming mistake." And everytime i Debug the program, supposedly it will display the items the data stored in the database, but it didn't

res.Columns will not contain the data returned for the jRDC2 server. It is a map of columns and their corresponding position that are returned on a successful query.

3)

There is no output too.

What does this mean? At minimum, you should see something like

Tag: (null), Columns: 0, Rows: 0

in the B4A log window when doing a

req.PrintTable(res)

4)

Dim cmd As DBCommand = CreateCommand("selectAllItem", Null)

How is selectAllItem set up in your config.properties file?

You need to do some debugging. Check the server logs while sending a query.

We need this to help you more

 

[aLya121314]

1)
Even though you are using a newer driver (8.0.17) for MySQL, you still are using an old DriverClass configuration in your config.properties of the jRDC2 server. So instead of

DriverClass=com.mysql.dbc.Driver

change it to

DriverClass=com.mysql.cj.jdbc.Driver

and that warning message will go away.

2)
res.Columns will not contain the data returned for the jRDC2 server. It is a map of columns and their corresponding position that are returned on a successful query.

3)
What does this mean? At minimum, you should see something like

in the B4A log window when doing a

req.PrintTable(res)

4)

Dim cmd As DBCommand = CreateCommand("selectAllItem", Null)

How is selectAllItem set up in your config.properties file?

We need this to help you more

Jrdc2 doesn't have problem anymore, also i test its connection with the server using its IP(127.0.0.1:17178/test) and the connection is successful.

The only problem I have now is that in the log of b4a, it says ResponceError. Just like in the image I attached

 

[aeric]

Always rightclick the error line in the log, copy and paste the text then post your error log instead of screen capture the errors. It will help the forum search engine.
Read this to solve the error:

CLEARTEXT communication to 192.168.0.101 not permitted by network security policy

Hi All, I tried to implement the JRDC2 implementation of Erel in one program. The implementation of Erel is in the below URL: https://www.b4x.com/android/forum/threads/b4x-jrdc2-b4j-implementation-of-rdc-remote-database-connector.61801/ I get the following error: ResponseError. Reason...

www.b4x.com

 

[aLya121314]

Thank you guys for the answers. Its now working.