B4J Question JRDC2 Error

[Dey]

Hello
I have tried multiple times to use JRDC2 with DBRequestManager V2
I can not get it to work
Below B4J and B4A errors
Kindly who helps me?
I did not understand if I should put constant VERSION1 at 2
However tried unresponsed
thank you

SQLite
config.prperties
DriverClass=org.sqlite.JDBC
JdbcUrl=sqlite:C:/BarApp/DataBase/00102-RIO.bar
User=root
Password=
ServerPort=17178

Spoiler: Log JRDC

Waiting for debugger to connect...
Program started.
2017-05-08 21:26:31.116:INFO::main: Logging initialized @577ms
mag 08, 2017 9:26:31 PM com.mchange.v2.log.MLog
INFORMAZIONI: MLog clients using java 1.4+ standard logging.
mag 08, 2017 9:26:31 PM com.mchange.v2.c3p0.C3P0Registry
INFORMAZIONI: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
2017-05-08 21:26:31.368:INFOejs.Server:main: jetty-9.3.z-SNAPSHOT
2017-05-08 21:26:31.390:INFOejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@4566e5bd{/,file:///G:/Developer/Android/Samples%20Erel/RDC/jRDC2/jRDC/Objects/www,AVAILABLE}
2017-05-08 21:26:31.392:INFOejs.AbstractNCSARequestLog:main: Opened G:\Developer\Android\Samples Erel\RDC\jRDC2\jRDC\Objects\logs\b4j-2017_05_08.request.log
2017-05-08 21:26:31.442:INFOejs.ServerConnector:main: Started ServerConnector@72b6cbcc{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
2017-05-08 21:26:31.443:INFOejs.Server:main: Started @904ms
Emulated network latency: 100ms
jRDC is running (version = 2.1)
mag 08, 2017 9:26:40 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource
INFORMAZIONI: 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 -> 1hge15y9n1ssn1gdke1z8o|567d299b, debugUnreturnedC...
mag 08, 2017 9:27:10 PM com.mchange.v2.resourcepool.BasicResourcePool
AVVERTENZA: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@6296f8aa -- 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: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:315)
at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
mag 08, 2017 9:27:10 PM com.mchange.v2.resourcepool.BasicResourcePool
AVVERTENZA: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@3473093b -- 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: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:315)
at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
mag 08, 2017 9:27:10 PM com.mchange.v2.resourcepool.BasicResourcePool
AVVERTENZA: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@20830e86 -- 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: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:315)
at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
mag 08, 2017 9:27:10 PM com.mchange.v2.resourcepool.BasicResourcePool
AVVERTENZA: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@36b4cef0 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
mag 08, 2017 9:27:10 PM com.mchange.v2.resourcepool.BasicResourcePool
AVVERTENZA: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@36b4cef0 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
mag 08, 2017 9:27:10 PM com.mchange.v2.resourcepool.BasicResourcePool
AVVERTENZA: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@36b4cef0 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
(TimeoutException) com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@36b4cef0 -- timeout at awaitAvailable()
Command: , took: 30057ms, client=192.168.1.102

Spoiler: Log B4A

** Service (starter) Create **
** Service (starter) Start **
** Activity (main) Create, isFirst = true **
** Activity (main) Resume **
PING 192.168.1.102 (192.168.1.102) 56(84) bytes of data.
64 bytes from 192.168.1.102: icmp_seq=1 ttl=63 time=1.80 ms
64 bytes from 192.168.1.102: icmp_seq=2 ttl=63 time=1.30 ms
--- 192.168.1.102 ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1003ms
rtt min/avg/max/mdev = 1.300/1.552/1.805/0.255 ms
** Service (httputils2service) Create **
** Service (httputils2service) Start **
ResponseError. Reason: java.net.SocketTimeoutException: timeout, Response:
DB_cmd.JobDone error: java.net.SocketTimeoutException: timeout Tag=100

 

[EnriqueGonzalez]

Hi!

In your JdbcURL use this:

JdbcUrl=jdbc:sqlite:/C:/BarApp/DataBase/00102-RIO.bar

please try it, and tell me if any changes happened, also the bes way to test if your connection is working is:

Open your browser
write: localhost:17172/test

it will tell you if you have access to your connection.

 

[Dey]

Hi!

In your JdbcURL use this:

JdbcUrl=jdbc:sqlite:/C:/BarApp/DataBase/00102-RIO.bar

please try it, and tell me if any changes happened, also the bes way to test if your connection is working is:

Open your browser
write: localhost:17172/test

it will tell you if you have access to your connection.

Here is the result
RemoteServer is running (05/08/2017 22:19:38)
Error fetching connection.

The JRDC1 version works correctly
Thank you Enrique for your interest

 

[EnriqueGonzalez]

Could you change your database name (just to test) for data.db and try again?

 

[EnriqueGonzalez]

Another thing may be the direction of the "/"

Try also this:

JdbcUrl=jdbc:sqlite:/C:\BarApp\DataBase\00102-RIO.bar

 

[Dey]

Another thing may be the direction of the "/"

Try also this:

JdbcUrl=jdbc:sqlite:/C:\BarApp\DataBase\00102-RIO.bar

Thank you
I managed to connect
I forgot "jdbc"
Now let's put it all in solotion
thank you