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

Alejandro Viera

Member
Licensed User
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+
13
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
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

Expert
Licensed User
Longtime User
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

Member
Licensed User
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
 

Situ LLC

Active Member
Licensed User
Usa maria DB
 
Top