Remote Database Connector files

[Erel]

See the tutorial: http://www.b4x.com/android/forum/threads/remote-database-connector-connect-to-any-remote-db.31540/

The client requires Agraham's ByteConverter library: http://www.b4x.com/android/forum/threads/byteconverter-library.6787/#post-39339

The client component is attached (DBRequestManager class is in the project).

The server component is available here: www.b4x.com/android/files/RDC-Server.zip

 

[Erel]

The client code was updated to workaround an issue with the rapid debugger.

 

[JShankar]

I am a newbie to B4A and am getting a missing library reference error for ByteConverter while trying to compile the above RDC Client example. I have copied the ByteConverter JAR & XML to the Additional Libraries folder. So, how do I add a library reference?

 

[JShankar]

Got it - Lib Tab.

 

[mr4681]

Thank

 

[rpitts78242]

How do you suggest a production RDC Server environment be setup? I presently run the RLC batch file provided on a Windows 7 workstation, but really need RDC server to run as a unattended background service on a ms windows server.

 

[Erel]

You can schedule this batch file to start whenever the server is booted.

 

[Erel]

A bug in DBRequestManager related to sending booleans was fixed.

 

[merlin2049er]

hmm, I'm missing something. I get, "Could not find or load main class anywheresoftware.b4a...."

ok, I got it working.

 

[Mirco Crepaldi]

Hi , Is there a way to protect the connection Client-Server ?
I need that the server reply only if the client give the correct password in the request.

Thanks.

 

[Erel]

Do you want to add the password as a URL parameter?

RDC doesn't look for such parameters. However you can implement a custom solution similar to RDC with B4J and then send whichever data you like.

 

[gapi]

Hi
I'm a new user, and I'm also a newbie to B4A. I have a mysql db called "agenzia" with a table "utenti".
My java server has these config.properties:
DriverClass= com.mysql.jdbc.driver
JdbcUrl= jdbc:mysql://localhost/agenzia?characterEnconding=utf8

I am getting this error: table "test.utenti" doesn't exist
Where do I find this "test"?
Thanks

 

[Erel]

Please start a new thread for this question and make sure to post the queries from config.properties file.

 

[Greg Shearer]

Hi ... and apologies for referencing this old thread ... but I need an answer to a question raised above briefly by Merlin2049er.
I am trying to run the server under Linux, but get this error:

Error: Could not find or load main class anywheresoftware.b4a.remotedatabase.RemoteServer

I can't find any reference to the class anywhere.
Can anyone offer some slightly more detailed instructions on the configuration steps required for Linux?

Any advice appreciated.

Regards,
Greg Shearer

 

[Erel]

You shouldn't use RDC 1. Use jRDC2 instead: https://www.b4x.com/android/forum/threads/61801/#content