Android Question Unknow format (magic number a0d)

Heppy

Active Member
Licensed User
Longtime User
I'm doing something wrong.
Could someone put a tutorial on how to configure Firebird with RDC.
I use Firebird 2.5
thanks
 
Last edited:

Heppy

Active Member
Licensed User
Longtime User
The error is caused by configuration of RDC with Firebird.
I Downloaded Jaybird 2.2.4.
which jar file or files have to put in the folder jdbc_driver.
I worked with Interbase, MySQL and Sybase, Firebird does not work but I
He had put the error was format (magig number ad0) but I think it was setup, because 127.0.0.1:17178 /? Method = the test was error timeout.
Tomorrow I posting the error.
My request would ordain an example or tutorial on this configuration shortie. I have started a conversation with incendio seems to work, but has not answered.
The problem is that Jaybird has many files and have tried all the possibilities and the test fails me.
Always install Appserver and do not know if necessary
Tanks Erel
 
Last edited:
Upvote 0

Heppy

Active Member
Licensed User
Longtime User
Hi.
I've talked to incendio and It has given me the settings with which it works.
jdk1.6.0_37, Firebird 2.5.2 and Jaybird 2.2.4.
I copied into folder jdbc_driver the files jaybird-2.2.4.jar and jaybird-full-2.2.4.jar.
I installed the same on my computer and whenever I get the following error when I do a 127.0.0.1:17178/?method=
B4X:
C:\Android\RemoteDatabaseConnector>"C:\Archivos de programa\Java\jdk1.6.0_35\bin
\java" -Xmx256m -cp .;libs\*;jdbc_driver\* anywheresoftware.b4a.remotedatabase.R
emoteServer
B4A Remote Database Connecter (version 0.9)
loading: C:\Android\RemoteDatabaseConnector\config.properties
2014-04-10 08:52:51.708:INFO::jetty-7.4.2.v20110526
2014-04-10 08:52:51.748:INFO::started o.e.j.s.ServletContextHandler{/,null}
10-abr-2014 8:52:51 com.mchange.v2.log.MLog <clinit>
INFO: MLog clients using java 1.4+ standard logging.
10-abr-2014 8:52:51 com.mchange.v2.c3p0.C3P0Registry banner
INFO: Initializing c3p0-0.9.2.1 [built 20-March-2013 11:16:28 +0000; debug? true
; trace: 10]
2014-04-10 08:52:52.069:INFO::Started [email protected]:17178 START
ING
10-abr-2014 8:52:55 com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoo
lManager
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, dataSourceN
ame -> 1hge0zo91kn9k3i181jokd|120a47e, debugUnreturnedConnectionStackTraces -> f
alse, description -> null, driverClass -> org.firebirdsql.jdbc.FBDriver, factory
ClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken
-> 1hge0zo91kn9k3i181jokd|120a47e, idleConnectionTestPeriod -> 600, initialPool
Size -> 3, jdbcUrl -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge ->
0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, ma
xStatements -> 150, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelper
Threads -> 3, preferredTestQuery -> null, properties -> {user=******, password=*
*****}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConn
ectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectio
nTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
10-abr-2014 8:53:25 com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcqui
reTask run
ADVERTENCIA: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@
e020c9 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying
to acquire a needed new resource, we failed to succeed more than the maximum num
ber of allowed acquisition attempts (30). Last acquisition attempt exception:
java.lang.NullPointerException
        at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
        at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
        at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
        at java.sql.DriverManager.getDriver(DriverManager.java:253)
        at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataS
ource.java:240)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:146)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:195)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:184)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe
sourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResource
Pool.java:1086)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPe
ndingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourc
ePool.java:44)
        at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.ru
n(BasicResourcePool.java:1810)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Thre
adPoolAsynchronousRunner.java:648)
10-abr-2014 8:53:25 com.mchange.v2.resourcepool.BasicResourcePool forceKillAcqui
res
ADVERTENCIA: Having failed to acquire a resource, com.mchange.v2.resourcepool.Ba
sicResourcePool@18bf072 is interrupting all Threads waiting on a resource to che
ck out. Will try again in response to new client requests.
10-abr-2014 8:53:25 com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcqui
reTask run
ADVERTENCIA: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@
39e5b5 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying
to acquire a needed new resource, we failed to succeed more than the maximum num
ber of allowed acquisition attempts (30). Last acquisition attempt exception:
java.lang.NullPointerException
        at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
        at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
        at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
        at java.sql.DriverManager.getDriver(DriverManager.java:253)
        at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataS
ource.java:240)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:146)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:195)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:184)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe
sourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResource
Pool.java:1086)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPe
ndingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourc
ePool.java:44)
        at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.ru
n(BasicResourcePool.java:1810)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Thre
adPoolAsynchronousRunner.java:648)
10-abr-2014 8:53:25 com.mchange.v2.resourcepool.BasicResourcePool forceKillAcqui
res
ADVERTENCIA: Having failed to acquire a resource, com.mchange.v2.resourcepool.Ba
sicResourcePool@18bf072 is interrupting all Threads waiting on a resource to che
ck out. Will try again in response to new client requests.
10-abr-2014 8:53:25 com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcqui
reTask run
ADVERTENCIA: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@
117f31e -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying
to acquire a needed new resource, we failed to succeed more than the maximum nu
mber of allowed acquisition attempts (30). Last acquisition attempt exception:
java.lang.NullPointerException
        at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
        at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
        at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
        at java.sql.DriverManager.getDriver(DriverManager.java:253)
        at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataS
ource.java:240)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:146)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:195)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:184)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe
sourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResource
Pool.java:1086)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPe
ndingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourc
ePool.java:44)
        at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.ru
n(BasicResourcePool.java:1810)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Thre
adPoolAsynchronousRunner.java:648)
10-abr-2014 8:53:25 com.mchange.v2.resourcepool.BasicResourcePool forceKillAcqui
res
ADVERTENCIA: Having failed to acquire a resource, com.mchange.v2.resourcepool.Ba
sicResourcePool@18bf072 is interrupting all Threads waiting on a resource to che
ck out. Will try again in response to new client requests.
java.sql.SQLException: An attempt by a client to checkout a Connection has timed
out.
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConne
ction(C3P0PooledConnectionPool.java:687)
        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:140)
        at anywheresoftware.b4a.remotedatabase.Servlet.doGet(Servlet.java:64)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538
)
        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java
:478)
        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandl
er.java:937)
        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:
406)
        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandle
r.java:871)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
ava:117)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper
.java:110)
        at org.eclipse.jetty.server.Server.handle(Server.java:346)
        at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.
java:589)
        at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete
(HttpConnection.java:1048)
        at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:601)
        at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:214)

        at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:41
1)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEn
dPoint.java:535)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEnd
Point.java:40)
        at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool
.java:529)
        at java.lang.Thread.run(Thread.java:662)
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out whil
e waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePo
ol@18bf072 -- timeout at awaitAvailable()
        at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicRes
ourcePool.java:1416)
        at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(
BasicResourcePool.java:606)
        at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicR
esourcePool.java:526)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConn
ectionInUse(C3P0PooledConnectionPool.java:755)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConne
ction(C3P0PooledConnectionPool.java:682)
        ... 21 more

Thanks
 
Upvote 0

Heppy

Active Member
Licensed User
Longtime User
B4X:
#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.
DriverClass=org.firebirdsql.jdbc.FBDriver
jdbcUrl=jdbc:firebirdsql://192.168.1.162/c:/Android/UMBELA.FDB

User=sysdba
Password=masterkey
ServerPort=17178
#If Debug is true then this file will be reloaded on every query.
#This is useful if you need to modify the queries.
Debug=true

#commands
sql.select_inst=SELECT ID FROM APARATOS


B4X:
"C:\Archivos de programa\Java\jdk1.6.0_45\bin\java" -Xmx256m -cp .;libs\*;jdbc_driver\* anywheresoftware.b4a.remotedatabase.RemoteServer
pause

Thanks Erel
 
Last edited:
Upvote 0

Heppy

Active Member
Licensed User
Longtime User
I am very silly
Sorry for the time I wasted to incendio and Erel.
I connect, but I get the following error:
B4X:
C:\AppServ\RemoteDatabaseConnector>"C:\Archivos de programa\Java\jdk1.6.0_45\bin
\java" -Xmx256m -cp .;libs\*;jdbc_driver\* anywheresoftware.b4a.remotedatabase.R
emoteServer
B4A Remote Database Connecter (version 0.9)
loading: C:\AppServ\RemoteDatabaseConnector\config.properties
2014-04-10 18:11:16.392:INFO::jetty-7.4.2.v20110526
2014-04-10 18:11:16.470:INFO::started o.e.j.s.ServletContextHandler{/,null}
10-abr-2014 18:11:16 com.mchange.v2.log.MLog <clinit>
INFO: MLog clients using java 1.4+ standard logging.
10-abr-2014 18:11:16 com.mchange.v2.c3p0.C3P0Registry banner
INFO: Initializing c3p0-0.9.2.1 [built 20-March-2013 11:16:28 +0000; debug? true
; trace: 10]
2014-04-10 18:11:16.845:INFO::Started [email protected]:17178 START
ING
java.io.EOFException
        at java.util.zip.GZIPInputStream.readUByte(GZIPInputStream.java:246)
        at java.util.zip.GZIPInputStream.readUShort(GZIPInputStream.java:236)
        at java.util.zip.GZIPInputStream.readHeader(GZIPInputStream.java:140)
        at java.util.zip.GZIPInputStream.<init>(GZIPInputStream.java:56)
        at java.util.zip.GZIPInputStream.<init>(GZIPInputStream.java:65)
        at anywheresoftware.b4a.remotedatabase.Servlet.doGet(Servlet.java:75)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538
)
        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java
:478)
        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandl
er.java:937)
        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:
406)
        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandle
r.java:871)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
ava:117)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper
.java:110)
        at org.eclipse.jetty.server.Server.handle(Server.java:346)
        at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.
java:589)
        at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete
(HttpConnection.java:1048)
        at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:601)
        at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:214)

        at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:41
1)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEn
dPoint.java:535)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEnd
Point.java:40)
        at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool
.java:529)
        at java.lang.Thread.run(Thread.java:662)
 
Last edited:
Upvote 0

Heppy

Active Member
Licensed User
Longtime User
With http:127.0.0.1:178/?method=test in the browser, the error is:
B4X:
C:\AppServ\RemoteDatabaseConnector>"C:\Archivos de programa\Java\jdk1.6.0_45\bin
\java" -Xmx256m -cp .;libs\*;jdbc_driver\* anywheresoftware.b4a.remotedatabase.R
emoteServer
B4A Remote Database Connecter (version 0.9)
loading: C:\AppServ\RemoteDatabaseConnector\config.properties
2014-04-11 08:38:05.979:INFO::jetty-7.4.2.v20110526
2014-04-11 08:38:06.057:INFO::started o.e.j.s.ServletContextHandler{/,null}
11-abr-2014 8:38:06 com.mchange.v2.log.MLog <clinit>
INFO: MLog clients using java 1.4+ standard logging.
11-abr-2014 8:38:06 com.mchange.v2.c3p0.C3P0Registry banner
INFO: Initializing c3p0-0.9.2.1 [built 20-March-2013 11:16:28 +0000; debug? true
; trace: 10]
2014-04-11 08:38:06.479:INFO::Started [email protected]:17178 START
ING
11-abr-2014 8:38:13 com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoo
lManager
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, dataSourceN
ame -> 1hge19i91m26fd31wfwaev|789144, debugUnreturnedConnectionStackTraces -> fa
lse, description -> null, driverClass -> org.firebirdsql.jdbc.FBDriver, factoryC
lassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken
-> 1hge19i91m26fd31wfwaev|789144, idleConnectionTestPeriod -> 600, initialPoolSi
ze -> 3, jdbcUrl -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0,
maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxS
tatements -> 150, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperTh
reads -> 3, preferredTestQuery -> null, properties -> {user=******, password=***
***}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnec
tionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionT
imeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
11-abr-2014 8:38:43 com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcqui
reTask run
ADVERTENCIA: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@
db4fa2 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying
to acquire a needed new resource, we failed to succeed more than the maximum num
ber of allowed acquisition attempts (30). Last acquisition attempt exception:
java.lang.NullPointerException
        at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
        at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
        at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
        at java.sql.DriverManager.getDriver(DriverManager.java:253)
        at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataS
ource.java:240)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:146)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:195)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:184)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe
sourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResource
Pool.java:1086)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPe
ndingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourc
ePool.java:44)
        at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.ru
n(BasicResourcePool.java:1810)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Thre
adPoolAsynchronousRunner.java:648)
11-abr-2014 8:38:43 com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcqui
reTask run
ADVERTENCIA: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@
491c4c -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying
to acquire a needed new resource, we failed to succeed more than the maximum num
ber of allowed acquisition attempts (30). Last acquisition attempt exception:
java.lang.NullPointerException
        at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
        at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
        at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
        at java.sql.DriverManager.getDriver(DriverManager.java:253)
        at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataS
ource.java:240)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:146)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:195)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:184)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe
sourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResource
Pool.java:1086)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPe
ndingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourc
ePool.java:44)
        at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.ru
n(BasicResourcePool.java:1810)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Thre
adPoolAsynchronousRunner.java:648)
11-abr-2014 8:38:43 com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcqui
reTask run
ADVERTENCIA: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@
1e0f2f6 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying
to acquire a needed new resource, we failed to succeed more than the maximum nu
mber of allowed acquisition attempts (30). Last acquisition attempt exception:
java.lang.NullPointerException
        at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
        at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
        at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
        at java.sql.DriverManager.getDriver(DriverManager.java:253)
        at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataS
ource.java:240)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:146)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:195)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:184)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe
sourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResource
Pool.java:1086)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPe
ndingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourc
ePool.java:44)
        at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.ru
n(BasicResourcePool.java:1810)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Thre
adPoolAsynchronousRunner.java:648)
11-abr-2014 8:38:43 com.mchange.v2.resourcepool.BasicResourcePool forceKillAcqui
res
ADVERTENCIA: Having failed to acquire a resource, com.mchange.v2.resourcepool.Ba
sicResourcePool@1309e87 is interrupting all Threads waiting on a resource to che
ck out. Will try again in response to new client requests.
11-abr-2014 8:38:43 com.mchange.v2.resourcepool.BasicResourcePool forceKillAcqui
res
ADVERTENCIA: Having failed to acquire a resource, com.mchange.v2.resourcepool.Ba
sicResourcePool@1309e87 is interrupting all Threads waiting on a resource to che
ck out. Will try again in response to new client requests.
11-abr-2014 8:38:43 com.mchange.v2.resourcepool.BasicResourcePool forceKillAcqui
res
ADVERTENCIA: Having failed to acquire a resource, com.mchange.v2.resourcepool.Ba
sicResourcePool@1309e87 is interrupting all Threads waiting on a resource to che
ck out. Will try again in response to new client requests.
java.sql.SQLException: An attempt by a client to checkout a Connection has timed
out.
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConne
ction(C3P0PooledConnectionPool.java:687)
        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:140)
        at anywheresoftware.b4a.remotedatabase.Servlet.doGet(Servlet.java:64)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538
)
        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java
:478)
        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandl
er.java:937)
        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:
406)
        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandle
r.java:871)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
ava:117)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper
.java:110)
        at org.eclipse.jetty.server.Server.handle(Server.java:346)
        at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.
java:589)
        at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete
(HttpConnection.java:1048)
        at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:601)
        at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:214)

        at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:41
1)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEn
dPoint.java:535)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEnd
Point.java:40)
        at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool
.java:529)
        at java.lang.Thread.run(Thread.java:662)
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out whil
e waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePo
ol@1309e87 -- timeout at awaitAvailable()
        at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicRes
ourcePool.java:1416)
        at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(
BasicResourcePool.java:606)
        at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicR
esourcePool.java:526)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConn
ectionInUse(C3P0PooledConnectionPool.java:755)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConne
ction(C3P0PooledConnectionPool.java:682)
        ... 21 more

With http:127.0.0.1:178/?method=select_inst in the browser, the error is:
B4X:
C:\AppServ\RemoteDatabaseConnector>"C:\Archivos de programa\Java\jdk1.6.0_45\bin
\java" -Xmx256m -cp .;libs\*;jdbc_driver\* anywheresoftware.b4a.remotedatabase.R
emoteServer
B4A Remote Database Connecter (version 0.9)
loading: C:\AppServ\RemoteDatabaseConnector\config.properties
2014-04-10 18:11:16.392:INFO::jetty-7.4.2.v20110526
2014-04-10 18:11:16.470:INFO::started o.e.j.s.ServletContextHandler{/,null}
10-abr-2014 18:11:16 com.mchange.v2.log.MLog <clinit>
INFO: MLog clients using java 1.4+ standard logging.
10-abr-2014 18:11:16 com.mchange.v2.c3p0.C3P0Registry banner
INFO: Initializing c3p0-0.9.2.1 [built 20-March-2013 11:16:28 +0000; debug? true
; trace: 10]
2014-04-10 18:11:16.845:INFO::Started [email protected]:17178 START
ING
java.io.EOFException
        at java.util.zip.GZIPInputStream.readUByte(GZIPInputStream.java:246)
        at java.util.zip.GZIPInputStream.readUShort(GZIPInputStream.java:236)
        at java.util.zip.GZIPInputStream.readHeader(GZIPInputStream.java:140)
        at java.util.zip.GZIPInputStream.<init>(GZIPInputStream.java:56)
        at java.util.zip.GZIPInputStream.<init>(GZIPInputStream.java:65)
        at anywheresoftware.b4a.remotedatabase.Servlet.doGet(Servlet.java:75)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538
)
        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java
:478)
        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandl
er.java:937)
        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:
406)
        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandle
r.java:871)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
ava:117)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper
.java:110)
        at org.eclipse.jetty.server.Server.handle(Server.java:346)
        at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.
java:589)
        at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete
(HttpConnection.java:1048)
        at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:601)
        at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:214)

        at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:41
1)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEn
dPoint.java:535)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEnd
Point.java:40)
        at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool
.java:529)
        at java.lang.Thread.run(Thread.java:662)
 
Upvote 0

Heppy

Active Member
Licensed User
Longtime User
Yes.
It proves to create a new virtual machine with firebird 2.5, 2.4 Jaybird jdk1.6 and jdk 1.6. RDC will configure again and hope it works.
i'll Copy jaybird2.2.4.jar 2.2.4full.jar to jdbc_driver folder.
I'll post the results
Thanks Erel
 
Upvote 0

Heppy

Active Member
Licensed User
Longtime User
Not to enlarge the thread, I'll open a new post detailing step by step everything I've done. I hope it serves as tutoeial
 
Upvote 0

Heppy

Active Member
Licensed User
Longtime User
Finally solved.
What nonsense and it has taken me too long to find the solution.
A letter in lowercase instead of uppercase
In the file config.properties

Before not run
B4X:
jdbcUrl=jdbc:firebirdsql://192.168.1.162/c:/Android/UMBELA.FDB

Now if it works
B4X:
JdbcUrl=jdbc:firebirdsql://192.168.1.162/c:/Android/UMBELA.FDB

The J was the problem.

Thanks to Erel and incendio for their infinite patience
 
Upvote 0
Top