B4J Question MySQL: com.mchange.v2.resourcepool.TimeoutException

[Mashiane]

Hi there

I am using Mysql 8.0.30.

I am getting this error sometimes when I try to connect

(TimeoutException) com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@7cc0cdad -- timeout at awaitAvailable()

Other settings

#AdditionalJar: mysql-connector-java-8.0.30.jar

Java 19.02

PS: I am testing this project

[Project Template] jRDC2 Server

Updates jRDC3 Server is available Version: 3.30 Project template based on jRDC2 version 2.23 with sample database. GitHub: https://github.com/pyhoon/jrdc2-server-template-b4j Template: JRDC Server (3.30).b4xtemplate Supported databases: SQLite MySQL MS SQL Firebird Postgresql DBF...

www.b4x.com

 

[EnriqueGonzalez]

Most likely there is conneciton Leak (a sql object that is not closed) hard to detect.

 

[aeric]

I am testing this project

May I know whether you get the same error with the original jRDC2?

Can you also verify this example?

jRDC2 server authentication + console client

Update Here is another example using session id https://www.b4x.com/android/forum/threads/jrdc2-server-with-login-session.166903/ Simple jRDC2 server authentication example with user name and password This example is based on this solved question for learning purpose. If user name and...

www.b4x.com