B4J Question [SOLVED] Error after updating B4J to 9.80

[Alejandro Viera]

It is not connecting to the JRDC server, has there been any change in the connection line? it worked perfectly.

2023-04-25 19:49:04.226:INFO :cmvci.AbstractPoolBackedDataSource:qtp1663411182-16: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1b60yueav1fry7mptrfhrn|7692d9cc, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1b60yueav1fry7mptrfhrn|7692d9cc, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/nexxges?characterEncoding=utf8&useSSL=true, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 150, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {password=******, user=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> true, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]

 

[aeric]

com.mysql.jdbc.Driver

Are you using the correct MySQL connector?

 

[Alejandro Viera]

Are you using the correct MySQL connector?

don't change anything, just update B4J. If it was correct.


#AdditionalJar: mysql-connector-java-5.1.44-bin

 

[Alejandro Viera]

HTTP ERROR 500 com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@22a48519 -- timeout at awaitAvailable()​

URI:	/rdc
STATUS:	500
MESSAGE:	com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@22a48519 -- timeout at awaitAvailable()
SERVLET:	anywheresoftware.b4j.object.JServlet-68c9133c

 

[aeric]

Before update, were you using jServer version 3?

 

[Alejandro Viera]

Before update, were you using jServer version 3?

aeric I don't remember, it could be. Now the version is 4.

 

[aeric]

aeric I don't remember, it could be. Now the version is 4.

Try uncheck and recheck the jServer library and compile again. Do you use other libraries? Make sure user name and password are correct and connection to database has no problem.

 

[Erel]

I don't the error in these logs.

jRDC2 works properly with jServer (4). I do recommend you to upgrade the MySQL driver and make sure to use Java 11+.