B4X is a set of simple and powerful cross platform RAD tools:
  • B4A (free) - Android development
  • B4J (free) - Desktop and Server development
  • B4i - iOS development
  • B4R (free) - Arduino, ESP8266 and ESP32 development
  • All developers, with any skill level, are welcome to join the B4X community .

    Spanish [SOLUCIONADO ]Error al ejecutar jRDC.jar - Error-fetching-connection

    En mi PC funciona perfectamente, esto ocurre en la PC de la oficina donde la quiero instalar.
    Hay que copiar y ejecutar algo mas que el jrdc.jar ?
    Gracias de antemano!
    #DATABASE CONFIGURATION (properties file)
    DriverClass=com.mysql.jdbc.Driver
    JdbcUrl=jdbc:mysql://localhost:3306/nexxges?characterEncoding=utf8&useSSL=false
    User=gestion
    Password=gestionpass
    #Java server port
    ServerPort=2930
    C:\JAVA\bin>java -jar jrdc.jar
    2021-09-14 20:09:59.400:INFO::main: Logging initialized @374ms to org.eclipse.je
    tty.util.log.StdErrLog
    sep. 14, 2021 8:09:59 P. M. com.mchange.v2.log.MLog
    INFO: MLog clients using java 1.4+ standard logging.
    sep. 14, 2021 8:10:00 P. M. com.mchange.v2.c3p0.C3P0Registry
    INFO: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? t
    rue; trace: 10]
    2021-09-14 20:10:00.577:INFO :eek: ejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018
    -05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 11.0.1+
    2021-09-14 20:10:00.660:INFO :eek: ejs.session:main: DefaultSessionIdManager workerNa
    me=node0
    2021-09-14 20:10:00.662:INFO :eek: ejs.session:main: No SessionScavenger set, using d
    efaults
    2021-09-14 20:10:00.666:INFO :eek: ejs.session:main: node0 Scavenging every 600000ms
    2021-09-14 20:10:00.680:INFO :eek: ejsh.ContextHandler:main: Started o.e.j.s.ServletC
    ontextHandler@36804139{/,file:///C:/JAVA/bin/www,AVAILABLE}
    2021-09-14 20:10:00.693:INFO :eek: ejs.AbstractNCSARequestLog:main: Opened C:\JAVA\bi
    n\logs\b4j-2021_09_14.request.log
    2021-09-14 20:10:00.729:INFO :eek: ejs.AbstractConnector:main: Started ServerConnecto
    r@6531a794{HTTP/1.1,[http/1.1]}{0.0.0.0:2930}
    2021-09-14 20:10:00.734:INFO :eek: ejs.Server:main: Started @1720ms
    jRDC is running (version = 2.22)
    sep. 14, 2021 8:10:16 P. M. com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSourc
    INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acqu
    ireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCo
    mmitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> fa
    lse, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connection
    TesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClas
    sLoaderSource -> caller, dataSourceName -> 1hge15yaj1rz54epcr0i9t|778d1062, debu
    gUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> c
    om.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnor
    eUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNam
    edDriverClass -> false, identityToken -> 1hge15yaj1rz54epcr0i9t|778d1062, idleCo
    nnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localho
    st:3306/nexxges?characterEncoding=utf8&useSSL=false, maxAdministrativeTaskTime -
    > 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections ->
    0, maxPoolSize -> 15, maxStatements -> 150, maxStatementsPerConnection -> 0, mi
    nPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpaw
    nedThreads -> false, properties -> {password=******, user=******}, propertyCycle
    -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> fa
    lse, testConnectionOnCheckout -> true, unreturnedConnectionTimeout -> 0, userOve
    rrides -> {}, usesTraditionalReflectiveProxies -> false ]
    sep. 14, 2021 8:10:47 P. M. com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1482
    d6e0 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to
    acquire a needed new resource, we failed to succeed more than the maximum numbe
    r of allowed acquisition attempts (30). Last acquisition attempt exception:
    java.sql.SQLException: Unknown system variable 'language'
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2483)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2441)
    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
    at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java
    :3790)
    at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImp
    l.java:3227)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2017)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at jdk.internal.reflect.GeneratedConstructorAccessor6.newInstance(Unknow
    n Source)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newI
    nstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
    :330)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
    erDataSource.java:175)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
    on(WrapperConnectionPoolDataSource.java:220)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
    on(WrapperConnectionPoolDataSource.java:206)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe
    sourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResource
    Pool.java:1138)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPe
    ndingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourc
    ePool.java:44)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.ru
    n(BasicResourcePool.java:1870)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Thre
    adPoolAsynchronousRunner.java:696)
    sep. 14, 2021 8:10:47 P. M. com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicR
    esourcePool@213e643b is interrupting all Threads waiting on a resource to check
    out. Will try again in response to new client requests.
    sep. 14, 2021 8:10:47 P. M. com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@510e
    f391 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to
    acquire a needed new resource, we failed to succeed more than the maximum numbe
    r of allowed acquisition attempts (30). Last acquisition attempt exception:
    java.sql.SQLException: Unknown system variable 'language'
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2483)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2441)
    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
    at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java
    :3790)
    at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImp
    l.java:3227)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2017)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at jdk.internal.reflect.GeneratedConstructorAccessor6.newInstance(Unknow
    n Source)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newI
    nstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
    :330)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
    erDataSource.java:175)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
    on(WrapperConnectionPoolDataSource.java:220)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
    on(WrapperConnectionPoolDataSource.java:206)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe
    sourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResource
    Pool.java:1138)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPe
    ndingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourc
    ePool.java:44)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.ru
    n(BasicResourcePool.java:1870)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Thre
    adPoolAsynchronousRunner.java:696)
    sep. 14, 2021 8:10:47 P. M. com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicR
    esourcePool@213e643b is interrupting all Threads waiting on a resource to check
    out. Will try again in response to new client requests.
    sep. 14, 2021 8:10:47 P. M. com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@f594
    3f0 -- 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: Unknown system variable 'language'
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2483)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2441)
    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
    at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java
    :3790)
    at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImp
    l.java:3227)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2017)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at jdk.internal.reflect.GeneratedConstructorAccessor6.newInstance(Unknow
    n Source)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newI
    nstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
    :330)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
    erDataSource.java:175)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
    on(WrapperConnectionPoolDataSource.java:220)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
    on(WrapperConnectionPoolDataSource.java:206)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe
    sourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResource
    Pool.java:1138)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPe
    ndingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourc
    ePool.java:44)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.ru
    n(BasicResourcePool.java:1870)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Thre
    adPoolAsynchronousRunner.java:696)
    sep. 14, 2021 8:10:47 P. M. com.mchange.v2.resourcepool.BasicResourcePool
    WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicR
    esourcePool@213e643b is interrupting all Threads waiting on a resource to check
    out. Will try again in response to new client requests.
    El servidor jRDC2 se está ejecutando bien, el problema es que hay algún cambio entre la base de datos de tu PC y la de la oficina. De ahí el error: "Error-fetching-connection". Es decir, el servidor jRDC2 no se está pudiendo conectar a tu base de datos por alguna razón.
    El problema parece ser este: "java.sql.SQLException: Unknown system variable 'language'"
    Buscando ese error en google, parece que hay alguna incompatibilidad entre la versión de mysql que tienes en la oficina, y el conector que estás usando (por ejemplo: mysql-connector-java-5.1.27-bin)
    Prueba a descargar algún otro de la versión 5 de este enlace (por ejemplo la versión 5.1.49, o a actualizar tu versión de mysql.
    saludos,
    Ahí comprobé las versiones y si, yo tengo en mi maquina la 8 y en la oficina esta instalada la 5.1.30.
    Antes de actualizar el Mysql voy a intentar hacerlo andar en esta versión, asique me bajo el conector para esa versión desde el enlace que me diste y lo instalo en la oficina?
    Gracias
    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. Accept Learn more…