B4J Question jRDC2 How to run and configure the connector to mysql

[Cassie]

Hi Guys,

This is my first time developing in B4J application and I read about the jRDC (remote database connector) which is good implementation.

Anyone who can post a detailed instruction how to run the server (middle-ware) and how to configure it to connect on mysql database. I tried running the jRDC2 and i have a missing library Byte Converter which i could not find a download link so instead I use the Byte Converter library of B4a (I don't know if its okey or not).

If you can upload any small sample db, config for jRDC2 and small client apps will be appreciated.

Thank you in advance for this great community.

 

[Erel]

so instead I use the Byte Converter library of B4a

This is the correct library.

The configuration file should include:

DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://localhost/test?characterEncoding=utf8

And this attribute in the main module:

#AdditionalJar: mysql-connector-java-5.1.27-bin

 

[Cassie]

Hi Erel,

I download the jRDC2.zip and extract it change the config.properties to

#DATABASE CONFIGURATION
DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://localhost/test?characterEncoding=utf8
User=a
Password=a
#Java server port
ServerPort=17178

I created a test database and created a user a with a password a.

I run the server and log jRDC is running (version = 2.1)

I go to browser and run http://localhost:17178/?method=test in url and i receive an error:

HTTP ERROR 404
Problem accessing /. Reason:

Not Found
Powered by Jetty:// 9.4.z-SNAPSHOT

Is there anything I missed or need to be done. Btw i put my
mysql-connector-java-5.1.43-bin instead on mysql-connector-java-5.1.27-bin since i could not found .27 version at the B4J Libraries folder.

Thanks in advance.

 

[Erel]

The test link is:
http://localhost:17178/test

 

[Cassie]

The test link is:
http://localhost:17178/test

Thank your for your quick response and it works. Maybe this must be updated to http://localhost:17178/test

 

[Cassie]

Hi Guys,

If i the remote server is running how do i stop this..

Any help is appreciated.

 

[EnriqueGonzalez]

hi Cassie

Kill java with the task manager to stop it.

 

[Cassie]

hi Cassie

Kill java with the task manager to stop it.

Thanks

 

[Erel]

Thank your for your quick response and it works. Maybe this must be updated t

I've added a note about the test link in jRDC2 thread.

 

[Cassie]

The test link is:
http://localhost:17178/test

Hi Erel,

I use this test link http://localhost:17178/test and it was successful bu when I use http://localhost:17178/rdc i get same error

HTTP ERROR 404
Problem accessing /. Reason:

Not Found
Powered by Jetty:// 9.4.z-SNAPSHOT

Thanks

 

[Erel]

The error message is strange as there is a rdc handler. However you don't need to test it from the browser.

Which client are you using?