Android Question Problem RDC with Firebird

Heppy

Active Member
Licensed User
Longtime User
Hi.

Sorry for my english and the length of the post

I use Windows 7 64bits
I installed on my computer AppServ.
I installed jdk 1.8
I downloaded Jaybird 2.2.4 for jdk1.8
I copy in the folder remotedatabaseconnector\jdbc_driver the file jaybird-2.2.4.jar
The Firebird service is running

config.properties:

B4X: 
DriverClass=org.firebirdsql.jdbc.FBDriver
jdbcUrl=jdbc:firebirdsql://192.168.1.17/c:/Android/UMBELA.FDB

User=sysdba
Password=masterkey
ServerPort=17178
Debug=true
#commands
sql.select_inst=SELECT ID FROM APARATOS

RunRLC.bat
B4X: 
"C:\Program Files\Java\jdk1.8.0\bin\java" -Xmx256m -cp .;libs\*;jdbc_driver\* anywheresoftware.b4a.remotedatabase.RemoteServer
pause

I execute RunRLC.bat

code b4a:
B4X: 
Sub Button1_click
  If reqManager.IsInitialized Then
    Dim cmd As DBCommand
      Dim Name As String
      cmd.Initialize
      cmd.Name = "select_inst"
      cmd.Parameters = Array As Object(Name)
      reqManager.ExecuteQuery(cmd, 0, Null)
  End If
End Sub


Error form server. Console MS-DOS
B4X: 
C:\AppServ\RemoteDatabaseConnector>"C:\Program Files\Java\jdk1.8.0\bin\java" -Xm
x256m -cp .;libs\*;jdbc_driver\* anywheresoftware.b4a.remotedatabase.RemoteServe
r
B4A Remote Database Connecter (version 0.9)
loading: C:\AppServ\RemoteDatabaseConnector\config.properties
2014-04-08 09:24:15.507:INFO::jetty-7.4.2.v20110526
2014-04-08 09:24:15.537:INFO::started o.e.j.s.ServletContextHandler{/,null}
abr 08, 2014 9:24:15 AM com.mchange.v2.log.MLog <clinit>
INFORMACIËN: MLog clients using java 1.4+ standard logging.
abr 08, 2014 9:24:15 AM com.mchange.v2.c3p0.C3P0Registry banner
INFORMACIËN: Initializing c3p0-0.9.2.1 [built 20-March-2013 11:16:28 +0000; debu
g? true; trace: 10]
2014-04-08 09:24:15.797:INFO::Started SelectChannelConnector@0.0.0.0:17178 START
ING
abr 08, 2014 9:24:24 AM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource ge
tPoolManager
INFORMACIËN: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource
[ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000,
autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailur
e -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, con
nectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, data
SourceName -> 1hge13l91hti8b91wp3akc|56cbfb61, debugUnreturnedConnectionStackTra
ces -> false, description -> null, driverClass -> org.firebirdsql.jdbc.FBDriver,
factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, ident
ityToken -> 1hge13l91hti8b91wp3akc|56cbfb61, idleConnectionTestPeriod -> 600, in
itialPoolSize -> 3, jdbcUrl -> null, maxAdministrativeTaskTime -> 0, maxConnecti
onAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize
-> 15, maxStatements -> 150, maxStatementsPerConnection -> 0, minPoolSize -> 3,
numHelperThreads -> 3, preferredTestQuery -> null, properties -> {user=******, p
assword=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0,
testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturned
ConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies ->
false ]
abr 08, 2014 9:24:24 AM com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolTh
read run
ADVERTENCIA: An Error forced the closing of Thread[C3P0PooledConnectionPoolManag
er[identityToken->1hge13l91hti8b91wp3akc|56cbfb61]-HelperThread-#1,5,main]. Will
attempt to reconstruct, but this might mean that something bad is happening.
java.lang.NoClassDefFoundError: javax/resource/ResourceException
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:259)
        at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(Driver
ManagerDataSource.java:112)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:144)
        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)
Caused by: java.lang.ClassNotFoundException: javax.resource.ResourceException
        at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        ... 12 more

Exception in thread "C3P0PooledConnectionPoolManager[identityToken->1hge13l91hti
8b91wp3akc|56cbfb61]-HelperThread-#1" java.lang.NoClassDefFoundError: javax/reso
urce/ResourceException
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:259)
        at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(Driver
ManagerDataSource.java:112)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:144)
        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)
Caused by: java.lang.ClassNotFoundException: javax.resource.ResourceException
        at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        ... 12 more
abr 08, 2014 9:24:24 AM com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolTh
read run
ADVERTENCIA: An Error forced the closing of Thread[C3P0PooledConnectionPoolManag
er[identityToken->1hge13l91hti8b91wp3akc|56cbfb61]-HelperThread-#0,5,main]. Will
attempt to reconstruct, but this might mean that something bad is happening.
java.lang.NoClassDefFoundError: javax/resource/ResourceException
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:259)
        at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(Driver
ManagerDataSource.java:112)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:144)
        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)
Caused by: java.lang.ClassNotFoundException: javax.resource.ResourceException
        at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        ... 12 more

Exception in thread "C3P0PooledConnectionPoolManager[identityToken->1hge13l91hti
8b91wp3akc|56cbfb61]-HelperThread-#0" java.lang.NoClassDefFoundError: javax/reso
urce/ResourceException
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:259)
        at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(Driver
ManagerDataSource.java:112)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:144)
        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)
Caused by: java.lang.ClassNotFoundException: javax.resource.ResourceException
        at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        ... 12 more
abr 08, 2014 9:24:24 AM com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolTh
read run
ADVERTENCIA: An Error forced the closing of Thread[C3P0PooledConnectionPoolManag
er[identityToken->1hge13l91hti8b91wp3akc|56cbfb61]-HelperThread-#2,5,main]. Will
attempt to reconstruct, but this might mean that something bad is happening.
java.lang.NoClassDefFoundError: javax/resource/ResourceException
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:259)
        at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(Driver
ManagerDataSource.java:112)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:144)
        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)
Caused by: java.lang.ClassNotFoundException: javax.resource.ResourceException
        at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        ... 12 more

Exception in thread "C3P0PooledConnectionPoolManager[identityToken->1hge13l91hti
8b91wp3akc|56cbfb61]-HelperThread-#2" java.lang.NoClassDefFoundError: javax/reso
urce/ResourceException
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:259)
        at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(Driver
ManagerDataSource.java:112)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:144)
        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)
Caused by: java.lang.ClassNotFoundException: javax.resource.ResourceException
        at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        ... 12 more
 
Last edited:
Sort by date Sort by votes
You must log in or register to reply here.

Similar Threads

Games [XUI2D] X2 v2.0 - 2021
Replies
12
Views
13K
Erel
  • Locked
Games [XUI2D] Example Pack
2
Replies
34
Views
61K
Erel
  • Article
B4A Library Dropbox SDK V2 - Java
2 3
Replies
53
Views
22K
netsistemas
  • Locked
  • Article
B4J Library [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)
5 6 7
Replies
138
Views
144K
Erel
  • Locked
  • Article
Android Tutorial Remote Database Connector (RDC) - Connect to any remote DB
20 21 22
Replies
423
Views
315K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…