Android Question DB MySQL with jRDC2

[Anderson Linhares]

Dear,
I tried to use the example given by Erel of how to use DB MySQL with jRDC2, but as I did not master English in the video, I was left with some doubts.
I just need details on how to mount the jRDC2 Server, where to do the download and configure, the rest I can follow.
I already downloaded WAMP and MySQL-Connector and installed only.
Can you help me?
Att.
Anderson Linhares
(Brazil)

 

[DonManfred]

I just need details on how to mount the jRDC2 Server, where to do the download and configure, the rest I can follow.

https://www.b4x.com/android/forum/threads/61801

 

[Bladimir Silva Toro]

Here I leave the steps you must follow, I did it to connect to MySQL and MS SQL Server and it works correctly:


1. create the database and the table in PhpMyAdmin in Wamp Server, in my case create a database called Prueba and a table called Empleados with the fields identificacion, nombre, salario.

2. Download the Java connector for MySQL and unzip the JAR file in the Library folder within the B4J application (https://downloads.mysql.com/archives/c-j/)

3. Download the project jRDC2.zip unzip and open in B4J (https://www.b4x.com/android/forum/t...-rdc-remote-database-connector.61801/#content)

4. Change #AdditionalJar: mysql-connector-java-5.1.27-bin if your connector is more updated, in my case #AdditionalJar: mysql-connector-java-5.1.45-bin

5. Go to the config file in File Manager and double-click to make the necessary changes

6. Change where it says #DATABASE CONFIGURATION, JdbcUrl, User and Password as necessary, in my case it would be:

7. Project jRDC2 is executed in B4J

8. A test is performed to verify the operation of jRDC2, you must write in the internet browser the ip address: port / test (http://192.168.1. 11:17178/test)

Attached project jRDC2

I hope this help can help you