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

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

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

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 password are not matched, the query will show 0 row result or affected rows. I added a non-UI console app to connect to the server. Edit...

www.b4x.com