B4J Question jRDC2 - Error fetching connection

[andyr00d]

Hi,

Continued from this thread: https://www.b4x.com/android/forum/threads/help-jrdc2-mssql-server.71638/

I'm trying to run jRDC2 on my QNAP NAS (linux). I have compiled the jRDC.jar from B4J and run it successfully through SSH. My Database is "SQL server - MariaDB" so I am using net.sourceforge.jtds.jdbc.Driver, I also tried to use the MariaDB driver but was unsure of how it should be referenced in the config.properties file?

If I type the IP address of my server (which runs the SQL DB + jRDC2) from another local machine, I can see that ports 17178 and 3306 are open. I get the following two pages for each URL typed:

http://192.168.1.251:17178/rdc
Problem accessing /rdc. Reason:
com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@1360b7b -- timeout at awaitAvailable()

http://192.168.1.251:17178/test
RemoteServer is running (10/05/2016 03:54:40)
Error fetching connection.

config.properties:
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://127.0.0.1:3306/test

I've read about allowing all connections and creating a new user account which I have done, however I am using phpMyAdmin, I'm not sure how I can allow all connections from that?

 

[Erel]

1. You are using the incorrect JDBC driver. jtds is for MS SQL Server.
You need to download the correct one: https://mariadb.com/kb/en/mariadb/about-mariadb-connector-j/

DriverClass=org.mariadb.jdbc.Driver
JdbcUrl=jdbc:mariadb://localhost:3306/test

2. If it still doesn't work then check jRDC2 server logs.

 

[andyr00d]

Thanks Erel, seems to be looking alot better now as I am getting "Connection successful". Will play around with it a bit more