Android Question jRDC2 problems

[Alberto Michelis]

Hi
Ive downloaded RDCserver.zip
Unzip it into C:\RemoteDatabaseConnector
Download the MsSql jodbc driver from http://jtds.sourceforge.net/
Copy the jtds-1.3.1.jar to C:\RemoteDatabaseConnector\jdbc_driver
Modify config.properties to:

#DATABASE CONFIGURATION
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://ARM-VBOX-W7-32/SQLEXPRESS2012/Dap2
User=xxx
Password=yyyy
#Java server port
ServerPort=17178

//ARM-VBOX-W7-32/SQLEXPRESS2012 is a local MsSql server

Modify RunRLC.bat to point to my java.exe
Run RunRLC.bat getting a good STARTING (see image 1)

But when I try to test it via web with:
http://127.0.0.1:17178/?method=test
I allways get:
RemoteServer is running (Mon Apr 17 13:58:30 ART 2017)
java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.

In the CMD window I get a timeout error too
Please see Image 2

What am I doing wrong?

 

[Erel]

You are not using jRDC2. You are using the old RDC.

jRDC2 is available here: https://www.b4x.com/android/forum/t...-rdc-remote-database-connector.61801/#content

 

[Alberto Michelis]

Ok but I dont understand how to use it
There are a jrdc.zip but inside it has *.b4j files, I dont have b4j
And there are a FIles folder with the config but theres not a odbc folder
Please help

 

[DonManfred]

I dont have b4j

You can download it here: https://www.b4x.com/b4j.html

 

[Alberto Michelis]

Thanks Don... and now what?

 

[Erel]

Please start a new thread in B4J questions forum.

The steps required to configure jRDC2 are explained here: https://www.b4x.com/android/forum/t...-rdc-remote-database-connector.59251/#content

 

[DonManfred]

Install it and then use jRDC2 Source to compile a new jRDC2 for you.
Use the generated jar on your Server then.

 

[Alberto Michelis]

Erel, in that link theres nothing about compile the b4j
Thanks Don I get a compile error

Cannot find: C:\B4J\libraries\mysql-connector-java-5.1.27-bin.jar

What to use with MsSql?

 

[DonManfred]

mysql-connector-java-5.1.27-bin.jar

it must be inside your b4j additional libs folder

A similar connector you need to use for MsSQL. I cant help here

 

[Alberto Michelis]

Don, I manage to compile it with the sourceforge.net sql jar and I get what you can see in the attached image.
Is that ok?

 

[DonManfred]

Is that ok?

Did you get any error when connecting with an RDC Client?

 

[Alberto Michelis]

Sory the delay
Ive tried with a browser typing:
http://192.168.1.109:17178/?method=test
and I get the error on the attached image

 

[DonManfred]

Can you post the code of your server?
Don´t know but sounds like you have removed the testhandler?

 

[Alberto Michelis]

I manage to make it work, thanks Don