B4J Question MySQL connector issues... again

Cableguy

Expert
Licensed User
Longtime User
Hi guys,

I installed the latest MySQL dev version, which includes the server, workbench, etc, etc...

I had done this before I got my SSD installed and recall having the same issues... I just can't seem to find the proper "working" jdbc connector..
MySQL is V8 and I already tried 5.1.48 bin, with no luck.
I'm trying to find the 5.1.37 bin but I just can't find it anywhere!
Can anyone share it with "me"?
 

Jorge M A

Well-Known Member
Licensed User
Hi!
I have used this link: https://downloads.mysql.com/archives/c-j/
But I think is very old for V8.
upload_2019-9-28_7-32-28.png
 
Upvote 0

Cableguy

Expert
Licensed User
Longtime User
Again… No Luck!!!

I used the link you provided and downloaded a few connectors… Its like russian roulette!!!

My SQL version is 8.0.17, if anyone can shed a bit of light on this, PLEASE HELP!!!!!!
 
Upvote 0

Cableguy

Expert
Licensed User
Longtime User
Using #AdditionalJar: mysql-connector-java-5.1.47-bin

B4X:
Waiting for debugger to connect...
Program started.
init mysql
...
...
sept. 29, 2019 12:23:25 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource
INFO: 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 -> 1hge13pa5yk1sbyf1me4l|27c86f2d, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge13pa5yk1sbyf1me4l|27c86f2d, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> localhost, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 100, ...
sept. 29, 2019 12:23:55 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@38a41152 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: No suitable driver
    at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)
    at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
sept. 29, 2019 12:23:55 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@66ce957f is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
sept. 29, 2019 12:23:55 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@5fa62623 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: No suitable driver
    
    ... 60 more

Using #AdditionalJar: mysql-connector-java-8.0.17

B4X:
Waiting for debugger to connect...
Program started.
init mysql
sept. 29, 2019 12:36:27 PM com.mchange.v2.log.MLog
INFO: MLog clients using java 1.4+ standard logging.
sept. 29, 2019 12:36:28 PM com.mchange.v2.c3p0.C3P0Registry
INFO: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
...
...
sept. 29, 2019 12:36:39 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource
INFO: 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 -> 1hge13pa5ykiwyl1hb4kqx|501edcf1, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge13pa5ykiwyl1hb4kqx|501edcf1, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> localhost, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 100...
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Error occurred on line: 29 (MyDataBaseManager)
java.lang.reflect.InvocationTargetException
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at anywheresoftware.b4a.keywords.Common.CallSubDebug2(Common.java:460)
 at com.ab.template.abmapplication._page_parseevent(abmapplication.java:560)
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:632)
 at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:237)
 at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:167)
 at jdk.internal.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at anywheresoftware.b4a.BA.raiseEvent2(BA.java:91)
 at anywheresoftware.b4a.shell.ShellBA.raiseEvent2(ShellBA.java:98)
 at anywheresoftware.b4a.BA.raiseEvent(BA.java:78)
 at anywheresoftware.b4j.object.WebSocketModule$Adapter$1.run(WebSocketModule.java:126)
 at anywheresoftware.b4a.keywords.SimpleMessageLoop.runMessageLoop(SimpleMessageLoop.java:30)
 at anywheresoftware.b4a.StandardBA.startMessageLoop(StandardBA.java:26)
 at anywheresoftware.b4a.shell.ShellBA.startMessageLoop(ShellBA.java:119)
 at anywheresoftware.b4a.keywords.Common.StartMessageLoop(Common.java:153)
 at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:309)
 at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:167)
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at anywheresoftware.b4a.BA.raiseEvent2(BA.java:91)
 at anywheresoftware.b4a.shell.ShellBA.raiseEvent2(ShellBA.java:98)
 at anywheresoftware.b4a.BA.raiseEvent(BA.java:78)
 at anywheresoftware.b4j.object.JServlet.createInstance(JServlet.java:65)
 at anywheresoftware.b4j.object.BackgroundWorkersManager$1.run(BackgroundWorkersManager.java:21)
 at anywheresoftware.b4a.keywords.SimpleMessageLoop.runMessageLoop(SimpleMessageLoop.java:30)
 at anywheresoftware.b4a.StandardBA.startMessageLoop(StandardBA.java:26)
 at anywheresoftware.b4a.shell.ShellBA.startMessageLoop(ShellBA.java:119)
 at anywheresoftware.b4a.keywords.Common.StartMessageLoop(Common.java:153)
 at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:309)
 at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:167)
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at anywheresoftware.b4a.BA.raiseEvent2(BA.java:91)
 at anywheresoftware.b4a.shell.ShellBA.raiseEvent2(ShellBA.java:98)
 at anywheresoftware.b4a.BA.raiseEvent(BA.java:78)
 at com.ab.template.main.main(main.java:29)
Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
 at anywheresoftware.b4a.debug.Debug.CallSub4(Debug.java:134)
 at anywheresoftware.b4a.debug.Debug.CallSubNew2(Debug.java:81)
 ... 49 more
Caused by: java.lang.reflect.InvocationTargetException
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at anywheresoftware.b4a.debug.Debug.CallSub4(Debug.java:115)
 ... 50 more
Caused by: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
 at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
 at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:690)
 at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
 at anywheresoftware.b4j.object.ConnectionPool.GetConnection(ConnectionPool.java:45)
 at com.ab.template.mydatabasemanager._getsql(mydatabasemanager.java:450)
 at com.ab.template.mydatabasemanager._insert_user(mydatabasemanager.java:86)
 at com.ab.template.abmapplication._msbtn1_clicked(abmapplication.java:478)
 ... 55 more
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@13e3c1c7 -- timeout at awaitAvailable()
 at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1467)
 at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
 at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
 ... 60 more
sept. 29, 2019 12:37:09 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1fc08cf2 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: No suitable driver
 at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)
 at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
 at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
 at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
sept. 29, 2019 12:37:09 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@63e1a9 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: No suitable driver
 at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)
 at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
 at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
 at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
sept. 29, 2019 12:37:09 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@530c2f30 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: No suitable driver
 at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)
 at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
 at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
 at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
sept. 29, 2019 12:37:09 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@13e3c1c7 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
sept. 29, 2019 12:37:09 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@13e3c1c7 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
sept. 29, 2019 12:37:09 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@13e3c1c7 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
 
Upvote 0

keirS

Well-Known Member
Licensed User
Longtime User
That error for 8.0.17 is self explanatory. The driver class for your connection pool needs to be "com.mysql.cj.jdbc.Driver" rather than "com.mysql.jdbc.Driver"
 
Upvote 0

Cableguy

Expert
Licensed User
Longtime User
Ok, but the only jar present on the 8.0.17 connector is that one...
Again, I had this issue before, but changed HDD since that and I can't find it anymore...
 
Upvote 0

Jorge M A

Well-Known Member
Licensed User
Have you checked the connection string parameters?
These have worked for me, with mysql-connector-java-8.0.17.jar
B4X:
Private driverClass As String="com.mysql.cj.jdbc.Driver"
   
Private connectionString As String="jdbc:mysql://{SERVER}:{PORT}/{DATABASE}?characterEncoding=utf8&autoReconnect=true&useTimezone=true&&serverTimezone=UTC&Pooling=True"

What is in your line: 29 (MyDataBaseManager) ?
 
Upvote 0

Cableguy

Expert
Licensed User
Longtime User
This project is an ABMaterial based project, and the SQL connecton is "managed" by a code module, as seen in the picture.

upload_2019-9-29_17-36-55.png
 
Upvote 0

EnriqueGonzalez

Well-Known Member
Licensed User
Longtime User
This project is an ABMaterial based project, and the SQL connecton is "managed" by a code module, as seen in the picture.

i suppose you are going to change as per @Jorge M A instruction from

B4X:
"com.mysql.jdbc.Driver"

to
B4X:
"com.mysql.cj.jdbc.Driver"

on line 17 ?
 
Upvote 0

Cableguy

Expert
Licensed User
Longtime User
B4X:
Waiting for debugger to connect...
Program started.
init mysql
sept. 29, 2019 8:10:12 PM com.mchange.v2.log.MLog
INFO: MLog clients using java 1.4+ standard logging.
sept. 29, 2019 8:10:14 PM com.mchange.v2.c3p0.C3P0Registry
INFO: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
Start B4J Analyse!
When an error occurs, check the B4JAnalyse.log file in the Objects folder to see the last B4J line it was working on.
Collecting data from B4J source files... (1/2)
ABMShared.bas
DBM.bas
MyDataBaseManager.bas
ABMCacheControl.bas
ABMErrorHandler.bas
ABMUploadHandler.bas
ABMCacheScavenger.bas
ABMRootFilter.bas
ABMApplication.bas
DashBoard.bas
iFTTH.b4j
Analysing data from B4J source files... (2/2)
Number of icons needed: 56
loading C:\B4X-SU~1\Projects\B4JPRO~1\ABMATE~1\iFTTH\Objects: copymewithjar.needs...
Using cache system: 3.0
Current App version: 1569780612426
Needs material/awesome icons
Building C:\B4X-SU~1\Projects\B4JPRO~1\ABMATE~1\iFTTH\Objects\copymewithjar.js.needs
Building core.min.1569780612426.css...
2019-09-29 20:10:16.550:INFO::main: Logging initialized @9720ms to org.eclipse.jetty.util.log.StdErrLog
2019-09-29 20:10:16.951:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 11.0.1+13
2019-09-29 20:10:17.119:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2019-09-29 20:10:17.119:INFO:oejs.session:main: No SessionScavenger set, using defaults
2019-09-29 20:10:17.126:INFO:oejs.session:main: node0 Scavenging every 600000ms
2019-09-29 20:10:17.210:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@3abada5a{/,file:///C:/B4X-Suite/Projects/B4J%20Projects/ABMaterial/iFTTH/Objects/www/,AVAILABLE}
2019-09-29 20:10:17.219:INFO:oejs.AbstractNCSARequestLog:main: Opened C:\B4X-Suite\Projects\B4J Projects\ABMaterial\iFTTH\Objects\logs\b4j-2019_09_29.request.log
2019-09-29 20:10:17.395:INFO:oejs.AbstractConnector:main: Started ServerConnector@19e4fcac{HTTP/1.1,[http/1.1]}{0.0.0.0:51042}
2019-09-29 20:10:17.397:INFO:oejs.Server:main: Started @10568ms
Emulated network latency: 100ms
2019-09-29 20:10:17.423:INFO:oejs.AbstractConnector:main: Stopped ServerConnector@19e4fcac{HTTP/1.1,[http/1.1]}{0.0.0.0:51042}
2019-09-29 20:10:17.429:INFO:oejs.session:main: node0 Stopped scavenging
2019-09-29 20:10:17.434:INFO:oejsh.ContextHandler:main: Stopped o.e.j.s.ServletContextHandler@3abada5a{/,file:///C:/B4X-Suite/Projects/B4J%20Projects/ABMaterial/iFTTH/Objects/www/,UNAVAILABLE}
2019-09-29 20:10:17.465:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 11.0.1+13
2019-09-29 20:10:17.479:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@3abada5a{/,file:///C:/B4X-Suite/Projects/B4J%20Projects/ABMaterial/iFTTH/Objects/www/,AVAILABLE}
2019-09-29 20:10:17.484:INFO:oejs.AbstractNCSARequestLog:main: Opened C:\B4X-Suite\Projects\B4J Projects\ABMaterial\iFTTH\Objects\logs\b4j-2019_09_29.request.log
2019-09-29 20:10:17.485:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2019-09-29 20:10:17.486:INFO:oejs.session:main: No SessionScavenger set, using defaults
2019-09-29 20:10:17.487:INFO:oejs.session:main: node0 Scavenging every 660000ms
2019-09-29 20:10:17.490:INFO:oejs.AbstractConnector:main: Started ServerConnector@19e4fcac{HTTP/1.1,[http/1.1]}{0.0.0.0:51042}
2019-09-29 20:10:17.494:INFO:oejs.Server:main: Started @10664ms
2019-09-29 20:10:17.506:INFO:oejs.session:main: node0 Scavenging every 990000ms
Viewer running on os: windows 10
Trying to open: http://localhost:51042/iFTTH/
Connected
Waiting for value (104 ms)
Waiting for value (135 ms)
Waiting for value (122 ms)
Waiting for value (100 ms)
sept. 29, 2019 8:10:27 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource
INFO: 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 -> 1hge13pa5z0qg911kdllvf|197d671, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.cj.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge13pa5z0qg911kdllvf|197d671, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> localhost, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 10...
Error occurred on line: 29 (MyDataBaseManager)
java.lang.reflect.InvocationTargetException
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at anywheresoftware.b4a.keywords.Common.CallSubDebug2(Common.java:460)
    at com.ab.template.abmapplication._page_parseevent(abmapplication.java:560)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:632)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:237)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:167)
    at jdk.internal.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:91)
    at anywheresoftware.b4a.shell.ShellBA.raiseEvent2(ShellBA.java:98)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:78)
    at anywheresoftware.b4j.object.WebSocketModule$Adapter$1.run(WebSocketModule.java:126)
    at anywheresoftware.b4a.keywords.SimpleMessageLoop.runMessageLoop(SimpleMessageLoop.java:30)
    at anywheresoftware.b4a.StandardBA.startMessageLoop(StandardBA.java:26)
    at anywheresoftware.b4a.shell.ShellBA.startMessageLoop(ShellBA.java:119)
    at anywheresoftware.b4a.keywords.Common.StartMessageLoop(Common.java:153)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:309)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:167)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:91)
    at anywheresoftware.b4a.shell.ShellBA.raiseEvent2(ShellBA.java:98)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:78)
    at anywheresoftware.b4j.object.JServlet.createInstance(JServlet.java:65)
    at anywheresoftware.b4j.object.BackgroundWorkersManager$1.run(BackgroundWorkersManager.java:21)
    at anywheresoftware.b4a.keywords.SimpleMessageLoop.runMessageLoop(SimpleMessageLoop.java:30)
    at anywheresoftware.b4a.StandardBA.startMessageLoop(StandardBA.java:26)
    at anywheresoftware.b4a.shell.ShellBA.startMessageLoop(ShellBA.java:119)
    at anywheresoftware.b4a.keywords.Common.StartMessageLoop(Common.java:153)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:309)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:167)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:91)
    at anywheresoftware.b4a.shell.ShellBA.raiseEvent2(ShellBA.java:98)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:78)
    at com.ab.template.main.main(main.java:29)
Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
    at anywheresoftware.b4a.debug.Debug.CallSub4(Debug.java:134)
    at anywheresoftware.b4a.debug.Debug.CallSubNew2(Debug.java:81)
    ... 49 more
Caused by: java.lang.reflect.InvocationTargetException
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at anywheresoftware.b4a.debug.Debug.CallSub4(Debug.java:115)
    ... 50 more
Caused by: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:690)
    at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
    at anywheresoftware.b4j.object.ConnectionPool.GetConnection(ConnectionPool.java:45)
    at com.ab.template.mydatabasemanager._getsql(mydatabasemanager.java:437)
    at com.ab.template.mydatabasemanager._insert_user(mydatabasemanager.java:76)
    at com.ab.template.abmapplication._msbtn1_clicked(abmapplication.java:478)
    ... 55 more
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@75ed9710 -- timeout at awaitAvailable()
    at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1467)
    at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
    at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
    ... 60 more
sept. 29, 2019 8:10:58 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@20551615 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: No suitable driver
    at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)
    at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
sept. 29, 2019 8:10:58 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@34c75da2 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: No suitable driver
    at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)
    at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
sept. 29, 2019 8:10:58 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@5ab68e0f -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: No suitable driver
    at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)
    at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
sept. 29, 2019 8:10:58 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@75ed9710 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
sept. 29, 2019 8:10:58 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@75ed9710 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
sept. 29, 2019 8:10:58 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@75ed9710 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
 
Upvote 0

OliverA

Expert
Licensed User
Longtime User
Ok. I've installed MySQL 8.0.17 on my Windows 10 Pro test machine. It also has 5.7.26. I downloaded the Connector/J file linked to by @Erel. I cobbled together a little test program and I have no issues connecting to either 5.7.26 or 8.0.17. I even use the "old" style of JDBC driver string of
com.mysql.jdbc.Driver
and the only thing is that the driver issues the following warning
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
My test client computer is another Win 10 Pro machine. The test program was ran with both JDK 11 provided by Anywhere Software and Amazon's JDK 8 (v212). Both worked. I then noticed that I'm behind on my latest B4J update. The initial tests were ran with 7.51, but I repeated the tests successfully with 7.80. I'm attaching the demo program and a database dump of the schema I accessed for the purpose of this test. The export was done via MySQL Workbench, which can also perform the import. The computer name, port, username and password needs to be adjusted as per your requirement. A user needs to be either created or assigned rights to the test schema attached.
Full log output of my test run:
Using mysql-connector-java-8.0.17
Trying 5.7.26 w/o Pool
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
50
Trying 5.7.26 with Pool
init mysql
Sep 30, 2019 3:01:58 PM com.mchange.v2.log.MLog
INFO: MLog clients using java 1.4+ standard logging.
Sep 30, 2019 3:01:58 PM com.mchange.v2.c3p0.C3P0Registry
INFO: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
Sep 30, 2019 3:01:58 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource
INFO: 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 -> 1hge17ya510i0v0dhgjk27|2286778, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge17ya510i0v0dhgjk27|2286778, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://asus01/dbutils?characterEncoding=utf8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExc...
50
Trying 8.0.17 w/o Pool
50
Trying 8.0.17 with Pool
init mysql
Sep 30, 2019 3:01:59 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource
INFO: 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 -> 1hge17ya510i0v0dhgjk27|49c43f4e, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge17ya510i0v0dhgjk27|49c43f4e, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://asus01:3307/dbutils?characterEncoding=utf8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdle...
50
 

Attachments

  • mysql8test.zip
    2.7 KB · Views: 230
  • Dump20190930.zip
    5.3 KB · Views: 192
Upvote 0

Cableguy

Expert
Licensed User
Longtime User
@OliverA , thanks for the test project, I will take a look at it, probably by the end of the week, as my internet/laptop access is very limited this week

Still, I have something "new" to report… a different error….
B4X:
Waiting for debugger to connect...
Program started.
init mysql
sept. 30, 2019 9:47:30 PM com.mchange.v2.log.MLog
INFO: MLog clients using java 1.4+ standard logging.
sept. 30, 2019 9:47:32 PM com.mchange.v2.c3p0.C3P0Registry
INFO: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
sept. 30, 2019 9:47:32 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource
INFO: 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 -> z8kflta510jnflr1dy9qy7|501edcf1, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.cj.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> z8kflta510jnflr1dy9qy7|501edcf1, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/iFTTH, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnectio...
sept. 30, 2019 9:48:05 PM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@e31bf73 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: The server time zone value 'Romance Summer Time' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
 
Upvote 0

Cableguy

Expert
Licensed User
Longtime User
So I got it working, with both 8.0.17 (adding the timezone prop) and 5.1.37 connector.

I used Heidi and deleted all users and recreated just one...

I guess SQL just dont give very clear info at times...

Thank you all for the patience and efforts to help me
 
Upvote 0
Top