Android Question Unknow format (magic number a0d)

Heppy · Apr 9, 2014

I'm doing something wrong.
Could someone put a tutorial on how to configure Firebird with RDC.
I use Firebird 2.5
thanks

Erel · Apr 9, 2014

Can you post the error and your current configuration?

Heppy · Apr 9, 2014

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

Erel · Apr 10, 2014

Have you seen their manual: http://www.firebirdsql.org/file/doc...umentation/Jaybird_2_1_JDBC_driver_manual.pdf

Heppy · Apr 10, 2014

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

Erel · Apr 10, 2014

Can you post the content of the config file?

Heppy · Apr 10, 2014

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

Erel · Apr 10, 2014

Not sure. Are you using the latest Jdbc jar: http://www.firebirdsql.org/en/jdbc-driver/ ?

Heppy · Apr 10, 2014

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)

Erel · Apr 11, 2014

Do you get this error when you send a test request (from the browser)?

Heppy · Apr 11, 2014

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)

Erel · Apr 13, 2014

Are you using the latest JDBC driver from the link I posted above?

There are other users who work with Firebird databases and RDC. It should work.

Heppy · Apr 13, 2014

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

Heppy · Apr 13, 2014

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

Heppy · Apr 14, 2014

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

Android Question Unknow format (magic number a0d)

Heppy

Active Member

Erel

B4X founder

Heppy

Active Member

Erel

B4X founder

Heppy

Active Member

Erel

B4X founder

Heppy

Active Member

Erel

B4X founder

Heppy

Active Member

Erel

B4X founder

Heppy

Active Member

Erel

B4X founder

Heppy

Active Member

Heppy

Active Member

Heppy

Active Member