Android Question jRDC2 problems

Alberto Michelis

Well-Known Member
Licensed User
Longtime User
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?
 

Attachments

  • 2017-04-17_1408.png
    2017-04-17_1408.png
    30.2 KB · Views: 132
  • 2017-04-17_1412.png
    2017-04-17_1412.png
    94.7 KB · Views: 129

Alberto Michelis

Well-Known Member
Licensed User
Longtime User
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
 
Upvote 0

Alberto Michelis

Well-Known Member
Licensed User
Longtime User
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?
 
Upvote 0

Alberto Michelis

Well-Known Member
Licensed User
Longtime User
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?
 

Attachments

  • 2017-04-18_1210.png
    2017-04-18_1210.png
    115.9 KB · Views: 139
Upvote 0
Top