Android Question jRDC2

aLya121314 · Nov 16, 2020

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 · Nov 16, 2020

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

aeric · Nov 16, 2020

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

aLya121314 · Nov 17, 2020

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

Thanks, here's the zip file.

aLya121314 · Nov 17, 2020

aeric said:
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 · Nov 17, 2020

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 · Nov 17, 2020

aLya121314 said:
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 · Nov 17, 2020

Erel said:
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 · Nov 17, 2020

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

aLya121314 · Nov 17, 2020

Erel said:
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 · Nov 17, 2020

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 · Nov 17, 2020

1)

aLya121314 said:
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

B4X:

DriverClass=com.mysql.dbc.Driver

change it to

B4X:

DriverClass=com.mysql.cj.jdbc.Driver

and that warning message will go away.

2)

aLya121314 said:
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)

aLya121314 said:
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

B4X:

req.PrintTable(res)

4)

B4X:

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

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

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

We need this to help you more

aLya121314 · Nov 17, 2020

OliverA said:
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

B4X:

DriverClass=com.mysql.dbc.Driver

change it to

B4X:

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

B4X:

req.PrintTable(res)

4)

B4X:

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 · Nov 17, 2020

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 · Nov 20, 2020

Thank you guys for the answers. Its now working.

Android Question jRDC2

aLya121314

Member

Attachments

DonManfred

Expert

aeric

Expert

aLya121314

Member

Attachments

aLya121314

Member

aLya121314

Member

Erel

B4X founder

aLya121314

Member

Erel

B4X founder

aLya121314

Member

Attachments

Erel

B4X founder

OliverA

Expert

aLya121314

Member

Attachments

aeric

Expert

CLEARTEXT communication to 192.168.0.101 not permitted by network security policy

aLya121314

Member

Similar Threads

Android Question jRDC2

Member

Attachments

Expert

Expert

Member

Attachments

Member

Member

B4X founder

Member

B4X founder

Member

Attachments

B4X founder

Expert

Member

Attachments

Expert

Member

Similar Threads

Privacy & Transparency

Privacy & Transparency