Thanks for your reply. They are indeed in different servers, and I also pointed to the external IP of the database, the port of the database should be open, because I can connect to my cloud database using Navicat, but I can't connect to my cloud database using JRDC, I don't know what the problem is.
So I want to ask you if my format is correct:
http://XXX (database external IP) : 17178 (this Java server port number does not change?) /test
Hello
@pengbm
jRDC2 is a millware that runs on Java.
So to make it work there are several possibilities which are:
1.
Local Service: Both your database and jRDC2 run locally on your PC or on your LAN or WIFI network. It is possible to convert your PC or your local server into a remote one, for that you must ask your ISP (Internet Service Provider) for a public internet IP.
2.
Remote Service: You can have jRDC2 and your database running on a
VPS service, there are several that I like such as DigitalOcean, Google Cloud and VPS Mart.
Remember that in a
VPS service they give you a virtual server with only the operating system in linux or Windows, you must install everything else, that is, the database, the JRE, the FTP and run jRDC2.
Shared hosting services like Hostinger, GoDaddy, Hostgator, Wix and others are NOT working as it cannot run Java applications like jRDC2
My recommendation and surely that of many colleagues is that you use jRDC2 in a VPS service, I personally recommend DigitalOcean since you can start from 5 dollars a month.
https://www.digitalocean.com/
If you have a shared hosting I recommend that you make your own
WebServices and consume it in B4A.
Any other questions will be gladly answered