Android Question jRDC2: How to make it work on B4A?

Daniel44 said:

JRDC2 really seems to be made only to run on B4A

Click to expand...

Public mysql As JdbcSQL

Public mysql As SQL

Wait For (sf) mysql_QueryComplete (Success As Boolean, Crsr As JdbcResultSet)

Wait For (sf) mysql_QueryComplete (Success As Boolean, Crsr As ResultSet)

Log($"Id: ${Crsr.GetInt("id")}, Name: ${Crsr.GetString("name")}"$)

OliverA said:

Actually, jRDC2 is designed to be compiled with B4J, not B4A. It can be accessed via B4A/B4i and B4J (B4R via a MQQT gateway). If you want to access your DB directly from your Android device, then you need to check out jSQL. jSQL previously (before becoming an internal lib) was called JdbcSQL. The post announcing JdbcSQL (https://www.b4x.com/android/forum/threads/jdbcsql-directly-connect-to-remote-databases.84016/) has a demo program included that needs a couple of modifications to be able to work.
0) Include/enable the jSQL library in the library tab
1) In the Starter service change (line 6)

B4X:

Public mysql As JdbcSQL

to

B4X:

Public mysql As SQL

2) In the Starter service change (line 53)

B4X:

Wait For (sf) mysql_QueryComplete (Success As Boolean, Crsr As JdbcResultSet)

to

B4X:

Wait For (sf) mysql_QueryComplete (Success As Boolean, Crsr As ResultSet)

3) Change the Starter service global variables jdbcUrl, Username and Password to work with your installed MySQL DB.
4) If you use the SQL statement of that program, make sure you have a table set up in you DB that can handle the query or change the query and the

B4X:

Log($"Id: ${Crsr.GetInt("id")}, Name: ${Crsr.GetString("name")}"$)

to display the data retrieved with your query

Click to expand...

José J. Aguilar said:

Hi Daniel44, just to clarify:

- jRDC2 is a B4J program, you compile it in B4J as OliverA told you, and you need a VPS where you can host the .jar. It will act as a server.
- The jRDC2 server, will connect with your database
- Then, you can access the jRDC2 server from another B4J client program, or from a B4A or B4I app.

So, jRDC2 is a server between your app and and your database

Click to expand...