B4X is a set of simple and powerful cross platform RAD tools:
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

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

ejs.session:main: DefaultSessionIdManager workerNa
me=node0
2021-09-14 20:10:00.662:INFO

ejs.session:main: No SessionScavenger set, using d
efaults
2021-09-14 20:10:00.666:INFO

ejs.session:main: node0 Scavenging every 600000ms
2021-09-14 20:10:00.680:INFO

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

ejs.AbstractNCSARequestLog:main: Opened C:\JAVA\bi
n\logs\b4j-2021_09_14.request.log
2021-09-14 20:10:00.729:INFO

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

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)
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.