jRDC version 2 is available here: https://www.b4x.com/android/forum/t...ation-of-rdc-remote-database-connector.61801/
Please start with this thread if you are not familiar with RDC: Remote Database Connector (RDC) - Connect to any remote DB
RDC was implemented before B4J was available. It was implemented in Java.
jRDC is a port of RDC server to B4J.
The main advantage of jRDC over RDC is that you can modify the source code. For example you can easily add support for SSL or connect to multiple databases.
The performance of both servers is the same.
Note that B4J creates executable jars so you can start the server with a double click or from the command line with:
There are some differences between the behavior and configuration of jRDC and RDC:
There is another difference related to the way nulls are handled. It shouldn't be a problem with new jdbc drivers.
jRDC v1.00 is attached. It fixes an issue related to blobs.
Please start with this thread if you are not familiar with RDC: Remote Database Connector (RDC) - Connect to any remote DB
RDC was implemented before B4J was available. It was implemented in Java.
jRDC is a port of RDC server to B4J.
The main advantage of jRDC over RDC is that you can modify the source code. For example you can easily add support for SSL or connect to multiple databases.
The performance of both servers is the same.
Note that B4J creates executable jars so you can start the server with a double click or from the command line with:
B4X:
java -jar jRDC.jar
There are some differences between the behavior and configuration of jRDC and RDC:
- On the client, the server link should end with /rdc. For example:
B4X:reqManager.Initialize(Me, "http://192.168.0.6:17178/rdc")
- You need to set the jdbc jar with the #AdditionalJar attribute (on the server). There is no jdbc_driver folder.
- jRDC always returns 0 for the affected rows fields in batch requests.
There is another difference related to the way nulls are handled. It shouldn't be a problem with new jdbc drivers.
jRDC v1.00 is attached. It fixes an issue related to blobs.
Attachments
Last edited: