B4J Question RDC timeout

[derez]

An error in the test hander of my rdc app , at this line :

Dim con As SQL = Main.rdcConnector1.GetConnection

java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.

What to do ?

 

[TILogistic]

ConnectionPool ?
The wait time depends on the JDBC driver you use and how you configure the connection URL.

"jdbc:mysql://localhost:3306/miBD?connectTimeout=30000&socketTimeout=60000"

"jdbc:sqlserver://localhost:1433;databaseName=miBD;loginTimeout=60"

 

[derez]

I don't think that it is a matter of timeout but that the connection is not established for other reason. The response I get in the browser is :
RemoteServer is running (01/02/2026 11:29:21)
Error fetching connection.
The logs in the server are :

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure||The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)

Maybe some file is missing, it worked in the past.

 

[Erel]

No file is missing. The MySQL server is probably not running. Have you started WAMP (if you are using it)?

 

[derez]

Since I use local sqlite db I changed to UsePool = False and the connection is established.