B4J Question rdc2 not working thread locked

Discussion in 'B4J Questions' started by John Decowski, Jun 3, 2019.

  1. John Decowski

    John Decowski Member Licensed User

    trying to get rdc2 working on b4j. keep getting the following errors:

    Waiting for debugger to connect...
    Program started.
    2019-06-02 20:57:46.628:INFO::main: Logging initialized @665ms to org.eclipse.jetty.util.log.StdErrLog
    Jun 02, 2019 8:57:47 PM com.mchange.v2.log.MLog
    INFO: MLog clients using java 1.4+ standard logging.
    Jun 02, 2019 8:57:47 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]
    2019-06-02 20:57:47.532:INFO:eek:ejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 1.8.0_211-b12
    2019-06-02 20:57:47.612:INFO:eek:ejs.session:main: DefaultSessionIdManager workerName=node0
    2019-06-02 20:57:47.612:INFO:eek:ejs.session:main: No SessionScavenger set, using defaults
    2019-06-02 20:57:47.614:INFO:eek:ejs.session:main: node0 Scavenging every 600000ms
    2019-06-02 20:57:47.619:INFO:eek:ejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@45820e51{/,file:///C:/Users/john/Desktop/jRDC/Objects/www,AVAILABLE}
    2019-06-02 20:57:47.622:INFO:eek:ejs.AbstractNCSARequestLog:main: Opened C:\Users\john\Desktop\jRDC\Objects\logs\b4j-2019_06_03.request.log
    2019-06-02 20:57:47.641:INFO:eek:ejs.AbstractConnector:main: Started ServerConnector@18459bd1{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
    2019-06-02 20:57:47.641:INFO:eek:ejs.Server:main: Started @1680ms
    Emulated network latency: 100ms
    jRDC is running (version = 2.22)
    Jun 02, 2019 8:57:55 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 -> 2rvy8fa37g4bin10eiy4r|6adca536, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 2rvy8fa37g4bin10eiy4r|6adca536, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://decowski.com/stocks?characterEncoding=utf8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTi...
    Jun 02, 2019 8:58:34 PM com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1c90ea27 -- 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: Access denied for user 'johndecowski'@'c-75-67-218-230.hsd1.nh.comcast.net' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2230)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2025)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at sun.reflect.GeneratedConstructorAccessor3.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
    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)
    Jun 02, 2019 8:58:34 PM com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@6dde5c8c is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
    Jun 02, 2019 8:58:34 PM com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@363c5581 -- 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: Access denied for user 'johndecowski'@'c-75-67-218-230.hsd1.nh.comcast.net' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2230)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2025)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at sun.reflect.GeneratedConstructorAccessor3.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
    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)
    Jun 02, 2019 8:58:34 PM com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@6dde5c8c is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
    Jun 02, 2019 8:58:34 PM com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@419ff01c -- 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: Access denied for user 'johndecowski'@'c-75-67-218-230.hsd1.nh.comcast.net' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2230)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2025)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at sun.reflect.GeneratedConstructorAccessor3.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
    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)
    Jun 02, 2019 8:58:34 PM com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@6dde5c8c is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.


    says access denied in there somewhere? but i know my password and username is correct.
     
  2. José J. Aguilar

    José J. Aguilar Active Member Licensed User

    Maybe the user and pass are correct, but the user is not allowed to access from outside. Is the jRDC2 server running in the same computer as mysql server?
    If it's in another computer, try to access i.e. with phpMyAdmin from a remote computer. Maybe you see some message like: "#1698 Access denied for user 'johndecowski'@'c-75-67-218-230.hsd1.nh.comcast.net'

    Google something like: "Allow remote connection to mysql" or something like that.
     
    Last edited: Jun 3, 2019
    Erel likes this.
  3. John Decowski

    John Decowski Member Licensed User

    No. I can log in on same computer fine using MySQL tools
     
  4. Erel

    Erel Administrator Staff Member Licensed User

  5. OliverA

    OliverA Well-Known Member Licensed User

    You could look at MySQL's log files and compare your successful login using MySQL tools vs the failed attempt to login via jRDC.
     
    José J. Aguilar likes this.
  6. John Decowski

    John Decowski Member Licensed User

    I have checked my schemeas for user permissions, and user domain permissions all have % in mysql. I have even tried intentionally typing in wrong url to verify the error migrated from access denied to a connection error. So I know I am making a connection to my server. My server crashed a little while ago and I lost all my data . I was running rdc the original version flawlessly without any issues. I have lost the files for the original version. I was thinking maybe I could get a copy of that version to try and see if my problem is strictly due to something with the new rdc version as I believe it is. Thanks erel.
     
  7. Erel

    Erel Administrator Staff Member Licensed User

  8. John Decowski

    John Decowski Member Licensed User

    I know it doesnt seem like a jrdc2 problem, but I just downloaded the link you just sent me and it worked perfectly the first time. Has to be something on the jrdc2 i dont have set up right.
     
  9. Erel

    Erel Administrator Staff Member Licensed User

    You should compare the configuration files. Maybe there is an extra space or something like that.
     
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