1. *** New version of B4J is available ***
    B4J v7.8
    Dismiss Notice

B4J Question [SOLVED] Fail to connect to mysql with jdbc2 [timezone problem]

Discussion in 'B4J Questions' started by yfleury, Aug 9, 2019.

  1. yfleury

    yfleury Active Member Licensed User

    Hi! all
    I run phpmyadmin and I can create table without problem.
    I am starting a jdbc2 server. But I have not able to connect on mysql.

    Start jdbc2 server look good.
    Code:
    Waiting for debugger to connect...
    Program started.
    2019-08-08 21:14:40.515:INFO::main: Logging initialized @614ms to org.eclipse.jetty.util.log.StdErrLog
    août 
    082019 9:14:40 P.M. com.mchange.v2.log.MLog
    INFO: MLog clients using java 
    1.4+ standard logging.
    août 
    082019 9:14:40 P.M. com.mchange.v2.c3p0.C3P0Registry
    INFO: Initializing c3p0-
    0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
    2019-08-08 21:14:40.925:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 11.0.1+13
    2019-08-08 21:14:40.963:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
    2019-08-08 21:14:40.963:INFO:oejs.session:main: No SessionScavenger set, using defaults
    2019-08-08 21:14:40.965:INFO:oejs.session:main: node0 Scavenging every 600000ms
    2019-08-08 21:14:40.971:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@13df2a8c{/,file:///C:/Users/Yves/Downloads/jRDC2/jRDC/Objects/www,AVAILABLE}
    2019-08-08 21:14:40.974:INFO:oejs.AbstractNCSARequestLog:main: Opened C:\Users\Yves\Downloads\jRDC2\jRDC\Objects\logs\b4j-2019_08_09.request.log
    2019-08-08 21:14:40.989:INFO:oejs.AbstractConnector:main: Started ServerConnector@264e9a1b{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
    2019-08-08 21:14:40.990:INFO:oejs.Server:main: Started @1094ms
    Emulated network latency: 100ms
    jRDC is running (version = 2.22)
    I use mysql jdbc driver : mysql-connector-java-8.0.17.jar in the additionnal library folder.
    Code:
    #AdditionalJar: mysql-connector-java-8.0.17
    In config.properties
    Code:
    #DATABASE CONFIGURATION
    DriverClass=com.mysql.cj.jdbc.Driver
    JdbcUrl=jdbc:mysql://localhost/routemap?characterEncoding=utf8
    User=root
    Password=
    #Java server port
    ServerPort=
    17178
    But I don't have connection to database named "routmap"
    I mistake someting?

    Waiting for debugger to connect...
    Program started.
    2019-08-08 21:14:40.515:INFO::main: Logging initialized @614ms to org.eclipse.jetty.util.log.StdErrLog
    août 08, 2019 9:14:40 P.M. com.mchange.v2.log.MLog
    INFO: MLog clients using java 1.4+ standard logging.
    août 08, 2019 9:14:40 P.M. com.mchange.v2.c3p0.C3P0Registry
    INFO: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
    2019-08-08 21:14:40.925:INFO:eek:ejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 11.0.1+13
    2019-08-08 21:14:40.963:INFO:eek:ejs.session:main: DefaultSessionIdManager workerName=node0
    2019-08-08 21:14:40.963:INFO:eek:ejs.session:main: No SessionScavenger set, using defaults
    2019-08-08 21:14:40.965:INFO:eek:ejs.session:main: node0 Scavenging every 600000ms
    2019-08-08 21:14:40.971:INFO:eek:ejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@13df2a8c{/,file:///C:/Users/Yves/Downloads/jRDC2/jRDC/Objects/www,AVAILABLE}
    2019-08-08 21:14:40.974:INFO:eek:ejs.AbstractNCSARequestLog:main: Opened C:\Users\Yves\Downloads\jRDC2\jRDC\Objects\logs\b4j-2019_08_09.request.log
    2019-08-08 21:14:40.989:INFO:eek:ejs.AbstractConnector:main: Started ServerConnector@264e9a1b{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
    2019-08-08 21:14:40.990:INFO:eek:ejs.Server:main: Started @1094ms
    Emulated network latency: 100ms
    jRDC is running (version = 2.22)
    août 08, 2019 9:15:22 P.M. 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 -> 1hge179a4w642b113rymve|654f0d9c, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.cj.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge179a4w642b113rymve|654f0d9c, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost/routemap?characterEncoding=utf8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxId...
    août 08, 2019 9:15:53 P.M. com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@56e56fe4 -- 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 'Est (heure d��t�)' 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.
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:827)
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:447)
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
    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)
    Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'Est (heure d��t�)' 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.
    at jdk.internal.reflect.GeneratedConstructorAccessor4.newInstance(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
    at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
    at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2139)
    at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2163)
    at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1301)
    at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:958)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:817)
    ... 12 more
    août 08, 2019 9:15:53 P.M. com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@60b4beb4 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
    août 08, 2019 9:15:53 P.M. com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@6180e101 -- 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 'Est (heure d��t�)' 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.
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:827)
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:447)
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
    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)
    Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'Est (heure d��t�)' 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.
    at jdk.internal.reflect.GeneratedConstructorAccessor4.newInstance(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
    at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
    at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2139)
    at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2163)
    at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1301)
    at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:958)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:817)
    ... 12 more
    août 08, 2019 9:15:53 P.M. com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@353ac534 -- 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 'Est (heure d��t�)' 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.
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:827)
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:447)
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
    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)
    Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'Est (heure d��t�)' 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.
    at jdk.internal.reflect.GeneratedConstructorAccessor4.newInstance(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
    at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
    at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2139)
    at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2163)
    at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1301)
    at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:958)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:817)
    ... 12 more
    août 08, 2019 9:15:53 P.M. com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@60b4beb4 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
    août 08, 2019 9:15:53 P.M. com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@60b4beb4 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
     
  2. OliverA

    OliverA Expert Licensed User

    Looking at your error log and seeing a complaint about timezones, I'll wager that your problem is similar to this problem for JRDC2
     
    yfleury, José J. Aguilar and Erel like this.
  3. yfleury

    yfleury Active Member Licensed User

    Thanks OliverA.

    It SOLVED.

    In wamp server (php.ini) I change timezone from UTC to America/New_York
    Code:
    date.timezone ="America/New_York"
    In config.properties file, I add timezone like this
    Code:
    JdbcUrl=jdbc:mysql://localhost/routemap?characterEncoding=utf8&useTimezone=true&serverTimezone=America/New_York
    And boom I have connection to database
    RemoteServer is running (08/09/2019 06:45:15)
    Connection successful.
     
    Erel, jimmyF and José J. Aguilar like this.
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice