Android Question Problem RDC with Firebird

Heppy

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 [email protected]: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.
Top