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

[Alejandro Viera]

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:INFOejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018
-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 11.0.1+
13
2021-09-14 20:10:00.660:INFOejs.session:main: DefaultSessionIdManager workerNa
me=node0
2021-09-14 20:10:00.662:INFOejs.session:main: No SessionScavenger set, using d
efaults
2021-09-14 20:10:00.666:INFOejs.session:main: node0 Scavenging every 600000ms
2021-09-14 20:10:00.680:INFOejsh.ContextHandler:main: Started o.e.j.s.ServletC
ontextHandler@36804139{/,file:///C:/JAVA/bin/www,AVAILABLE}
2021-09-14 20:10:00.693:INFOejs.AbstractNCSARequestLog:main: Opened C:\JAVA\bi
n\logs\b4j-2021_09_14.request.log
2021-09-14 20:10:00.729:INFOejs.AbstractConnector:main: Started ServerConnecto
r@6531a794{HTTP/1.1,[http/1.1]}{0.0.0.0:2930}
2021-09-14 20:10:00.734:INFOejs.Server:main: Started @1720ms
jRDC is running (version = 2.22)
sep. 14, 2021 8:10:16 P. M. com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSourc
e
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
235)
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:
490)
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
235)
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:
490)
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
235)
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:
490)
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.

 

[josejad]

Hola Alejandro:

esto ocurre en la PC de la oficina donde la quiero instalar

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,

 

[Alejandro Viera]

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

 

[Alejandro Viera]

Jose, creo que segun esta tabla, no hay chances de que funcione en un Mysql 5.1.30 verdad?

 

[josejad]

Pues parece que no, que soporta a partir de la version 5.6

 

[Situ LLC]

Usa maria DB

 

[Alejandro Viera]

Se soluciono actualizando Mysql!
Gracias a todos