Android Question error with jRDC.exe

[Mostez]

I run jRDC2 from B4J in debug mode without any problems at all, I've made standalone package, but when I run it on the same B4J development computer, and try to test it from browser(http://192.168.1.138:17178/test) I get this error:

RemoteServer is running (06/09/2021 10:40:00)
Error fetching connection.

here is the everything displayed on screen (jrdc.exe):

Spoiler

2021-06-09 10:39:52.051:INFO::main: Logging initialized @186ms to org.eclipse.jetty.util.log.StdErrLog
Jun 09, 2021 10:39:52 AM com.mchange.v2.log.MLog
INFO: MLog clients using java 1.4+ standard logging.
Jun 09, 2021 10:39:52 AM com.mchange.v2.c3p0.C3P0Registry
INFO: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
2021-06-09 10:39:52.565:INFOejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 11.0.1+13
2021-06-09 10:39:52.592:WARNejh.MimeTypes:main: Missing mime-type resource: org/eclipse/jetty/http/mime.properties
2021-06-09 10:39:52.592:WARNejh.MimeTypes:main: Missing encoding resource: org/eclipse/jetty/http/encoding.properties
2021-06-09 10:39:52.595:INFOejs.session:main: DefaultSessionIdManager workerName=node0
2021-06-09 10:39:52.595:INFOejs.session:main: No SessionScavenger set, using defaults
2021-06-09 10:39:52.597:INFOejs.session:main: node0 Scavenging every 660000ms
2021-06-09 10:39:52.603:INFOejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@1f2586d6{/,file:///D:/Mostafa/Programs/B4J/jRDC/Objects/temp/build/bin/www,AVAILABLE}
2021-06-09 10:39:52.606:INFOejs.AbstractNCSARequestLog:main: Opened D:\Mostafa\Programs\B4J\jRDC\Objects\temp\build\bin\logs\b4j-2021_06_09.request.log
2021-06-09 10:39:52.623:INFOejs.AbstractConnector:main: Started ServerConnector@17f7cd29{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
2021-06-09 10:39:52.624:INFOejs.Server:main: Started @766ms
jRDC is running (version = 2.22)
Jun 09, 2021 10:40:00 AM 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 -> 2vvf6eah1ukkm0q1q123uo|587c290d, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> net.sourceforge.jtds.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 2vvf6eah1ukkm0q1q123uo|587c290d, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:jtds:sqlserver://127.0.0.1/e-trip, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 150, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {password=******, user=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> true, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
Jun 09, 2021 10:40:39 AM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@2f845d66 -- 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: Could not find a Java charset equivalent to DB charset Cp1252.
at b4j/net.sourceforge.jtds.jdbc.JtdsConnection.loadCharset(Unknown Source)
at b4j/net.sourceforge.jtds.jdbc.JtdsConnection.<init>(Unknown Source)
at b4j/net.sourceforge.jtds.jdbc.Driver.connect(Unknown Source)
at b4j/com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Unknown Source)
at b4j/com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(Unknown Source)
at b4j/com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(Unknown Source)
at b4j/com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(Unknown Source)
at b4j/com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(Unknown Source)
at b4j/com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(Unknown Source)
at b4j/com.mchange.v2.resourcepool.BasicResourcePool.access$700(Unknown Source)
at b4j/com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(Unknown Source)
at b4j/com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Unknown Source)

Jun 09, 2021 10:40:39 AM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@2edab60a is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
Jun 09, 2021 10:40:39 AM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1382bda8 -- 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: Could not find a Java charset equivalent to DB charset Cp1252.
at b4j/net.sourceforge.jtds.jdbc.JtdsConnection.loadCharset(Unknown Source)
at b4j/net.sourceforge.jtds.jdbc.JtdsConnection.<init>(Unknown Source)
at b4j/net.sourceforge.jtds.jdbc.Driver.connect(Unknown Source)
at b4j/com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Unknown Source)
at b4j/com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(Unknown Source)
at b4j/com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(Unknown Source)
at b4j/com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(Unknown Source)
at b4j/com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(Unknown Source)
at b4j/com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(Unknown Source)
at b4j/com.mchange.v2.resourcepool.BasicResourcePool.access$700(Unknown Source)
at b4j/com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(Unknown Source)
at b4j/com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Unknown Source)

Jun 09, 2021 10:40:39 AM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@2edab60a is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
Jun 09, 2021 10:40:39 AM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@e390e5f -- 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: Could not find a Java charset equivalent to DB charset Cp1252.
at b4j/net.sourceforge.jtds.jdbc.JtdsConnection.loadCharset(Unknown Source)
at b4j/net.sourceforge.jtds.jdbc.JtdsConnection.<init>(Unknown Source)
at b4j/net.sourceforge.jtds.jdbc.Driver.connect(Unknown Source)
at b4j/com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(Unknown Source)
at b4j/com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(Unknown Source)
at b4j/com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(Unknown Source)
at b4j/com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(Unknown Source)
at b4j/com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(Unknown Source)
at b4j/com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(Unknown Source)
at b4j/com.mchange.v2.resourcepool.BasicResourcePool.access$700(Unknown Source)
at b4j/com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(Unknown Source)
at b4j/com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Unknown Source)

Jun 09, 2021 10:40:39 AM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@2edab60a is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.

TIA

 

[Erel]

Is this thread different than this one: https://www.b4x.com/android/forum/threads/run-jrdc-exe-on-server.131464/ ?

 

[Mostez]

in this post, I get errors while running the jRDC, I'm not familiar with java and this is my real first try with B4J.
I just want to put the exe file in windows startup apps., and I don't know how to do that with jar, this why I'm trying with the exe solution

 

[josejad]

You can run a .jar file in windows too

How can i run my compiled jRDC.jar in my windows Server ? IF jRDC.jar isn't running

i want to connect Mysql with b4a app i try to run with differents javas , and i try too with java to exe software. Sending me this Error: Error: A JNI error has occurred, please check your installation and try again Exception in thread "main" java.lang.UnsupportedClassVersionError...

www.b4x.com

 

[Mostez]

thank you so much, it is working OK now on development computer, will try it on server

 

[Mostez]

it's OK too on server