I have a modified B4J server that compiles and runs fine.
Thought I would try the new ability non-ui programs as a standalone package.
I ran "Build Standalone Package" I copied my 'config.properties' file to .....\Objects\temp\build\bin.
I go back to .....\Objects\temp\build and run the executable and I get the following errors.
Compiling normally and running run_debug.bat yields the following:
They look identical to me except one fails and one does not.
Any help appreciated.
Thought I would try the new ability non-ui programs as a standalone package.
I ran "Build Standalone Package" I copied my 'config.properties' file to .....\Objects\temp\build\bin.
I go back to .....\Objects\temp\build and run the executable and I get the following errors.
B4X:
2021-06-11 03:12:43.074:INFO::main: Logging initialized @234ms to org.eclipse.jetty.util.log.StdErrLog
Jun 11, 2021 3:12:43 AM com.mchange.v2.log.MLog
INFO: MLog clients using java 1.4+ standard logging.
Jun 11, 2021 3:12:43 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]
Jun 11, 2021 3:12:43 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 -> 1hge0wdah1xirq0t6cjafa|4516af24, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> net.sourceforge.jtds.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge0wdah1xirq0t6cjafa|4516af24, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:jtds:sqlserver://localhost:1433/SkDataDemo44;useLOBs=false, 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 ]
Unable to Connect try 1 of 20.
Make sure your config.properties file is correct and your SQL instance is running!
Unable to Connect try 2 of 20.
Make sure your config.properties file is correct and your SQL instance is running!
Jun 11, 2021 3:13:28 AM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@6f8d74a7 -- 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 11, 2021 3:13:28 AM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@38c6f217 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
Unable to Connect try 3 of 20.
Make sure your config.properties file is correct and your SQL instance is running!
Jun 11, 2021 3:13:28 AM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@5019b94c -- 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 11, 2021 3:13:28 AM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@38c6f217 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
Unable to Connect try 4 of 20.
Make sure your config.properties file is correct and your SQL instance is running!
Jun 11, 2021 3:13:28 AM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@5437f2fd -- 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 11, 2021 3:13:28 AM com.mchange.v2.resourcepool.BasicResourcePool
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@38c6f217 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
Unable to Connect try 5 of 20.
Make sure your config.properties file is correct and your SQL instance is running!
Unable to Connect try 6 of 20.
Make sure your config.properties file is correct and your SQL instance is running!
Unable to Connect try 7 of 20.
Make sure your config.properties file is correct and your SQL instance is running!
Compiling normally and running run_debug.bat yields the following:
B4X:
D:\Android\B4X\DBConnector\SKDBServer\SKDBServer\Objects>C:\Java\jdk-11.0.1\bin\java.exe -jar SKDBServer.jar
2021-06-11 04:07:25.647:INFO::main: Logging initialized @388ms to org.eclipse.jetty.util.log.StdErrLog
Jun 11, 2021 4:07:25 AM com.mchange.v2.log.MLog
INFO: MLog clients using java 1.4+ standard logging.
Jun 11, 2021 4:07:26 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]
Jun 11, 2021 4:07:26 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 -> 1hge0wdah1xkq2w81959on2|1e802ef9, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> net.sourceforge.jtds.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge0wdah1xkq2w81959on2|1e802ef9, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:jtds:sqlserver://localhost:1433/SkDataDemo44;useLOBs=false, 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 ]
MaxFileSize
2021-06-11 04:07:27.301:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 11.0.1+13
2021-06-11 04:07:27.343:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2021-06-11 04:07:27.343:INFO:oejs.session:main: No SessionScavenger set, using defaults
2021-06-11 04:07:27.347:INFO:oejs.session:main: node0 Scavenging every 660000ms
2021-06-11 04:07:27.354:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@295cf707{/,file:///D:/Android/B4X/DBConnector/SKDBServer/SKDBServer/Objects/www,AVAILABLE}
2021-06-11 04:07:27.358:INFO:oejs.AbstractNCSARequestLog:main: Opened D:\Android\B4X\DBConnector\SKDBServer\SKDBServer\Objects\logs\b4j-2021_06_11.request.log
2021-06-11 04:07:27.540:INFO:oejs.AbstractConnector:main: Started ServerConnector@58594a11{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
2021-06-11 04:07:27.543:INFO:oejs.Server:main: Started @2290ms
SkDBServer is running (version = 2.22)
Any help appreciated.