B4J Question [Solved] jRDC Server

[yves67]

Hello
I am trying to install a jRDC Server to access db from B4I application
On the windows server, I have installed java jdk, the jRDC.jar, the config.properties file
but my big problem is I don't know where to put the driver ?
I am using mariadb driver
and in the log of jRDC I can see that RDC is not able to find the driver
I have tried the lib of jkd, jre, the folder of the jRDC application
no way ....
I am stuck..
Thanks for any help
Yves

 

[yves67]

I have rebuilt the jRDC.jar because I forgot to uncomment the #additionaljar with the correct driver name
now I have connection successfull but in the log I still have

AVERTISSEMENT: Could not load driverClass mariadb-java-client-1.5.7
java.lang.ClassNotFoundException: mariadb-java-client-1.5.7
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
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)

my confi.properties is :

#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.

#DATABASE CONFIGURATION
#DriverClass=com.mysql.jdbc.Driver
DriverClass=mariadb-java-client-1.5.7
JdbcUrl=jdbc:mariadb://localhost/f2a_ipad?characterEncoding=utf8
User=root
Password=*******
#Java server port
ServerPort=17178



Thanks for any help

Regards
Yves

 

[Erel]

Make sure to use jRDC2.

You need to put the the jdbc driver jar in the additional libraries folder and add a reference with the #AdditionalJar attribute (in the main module):

#AdditionalJar: mariadb-java-client-1.5.7

 

[yves67]

Hello,
OK, I put the jdbc driver jar in the additional librairies and add the #AdditionalJar attribute.

with 127.0.0.1:17178/test I got successfull connection good

but looking at the messages, I see that the jdbc driver is not found ?????

I copy the all messages :

Microsoft Windows [version 6.3.9600]
(c) 2013 Microsoft Corporation. Tous droits réservés.

C:\Users\Administrator>java -jar c:\ProgramData\jrdc\jrdc.jar
2017-02-13 13:14:04.016:INFO::main: Logging initialized @223ms
fΘvr. 13, 2017 1:14:04 PM com.mchange.v2.log.MLog <clinit>
INFOS: MLog clients using java 1.4+ standard logging.
fΘvr. 13, 2017 1:14:04 PM com.mchange.v2.c3p0.C3P0Registry banner
INFOS: Initializing c3p0-0.9.2.1 [built 20-March-2013 11:16:28 +0000; debug? tru
e; trace: 10]
2017-02-13 13:14:04.490:INFOejs.Server:main: jetty-9.3.z-SNAPSHOT
2017-02-13 13:14:04.552:INFOejsh.ContextHandler:main: Started o.e.j.s.ServletC
ontextHandler@28feb3fa{/,file:///C:/Users/Administrator/www,AVAILABLE}
2017-02-13 13:14:04.552:INFOejs.AbstractNCSARequestLog:main: Opened C:\Users\A
dministrator\logs\b4j-2017_02_13.request.log
2017-02-13 13:14:04.662:INFOejs.ServerConnector:main: Started ServerConnector@
4b952a2d{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
2017-02-13 13:14:04.662:INFOejs.Server:main: Started @864ms
jRDC is running (version = 2.1)
fΘvr. 13, 2017 1:14:23 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource
getPoolManager
INFOS: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acq
uireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoC
ommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> f
alse, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectio
nTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSource
Name -> 1hge13d9mfwlukdmc0xbp|cac736f, debugUnreturnedConnectionStackTraces -> f
alse, description -> null, driverClass -> mariadb-java-client-1.5.7, factoryClas
sLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken ->
1hge13d9mfwlukdmc0xbp|cac736f, idleConnectionTestPeriod -> 600, initialPoolSize
-> 3, jdbcUrl -> jdbc:mariadb://localhost/f2a_ipad?characterEncoding=utf8, maxAd
ministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTi
meExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 150, maxStatements
PerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery
-> null, properties -> {user=******, password=******}, propertyCycle -> 0, state
mentCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testCon
nectionOnCheckout -> true, unreturnedConnectionTimeout -> 0, userOverrides -> {}
, usesTraditionalReflectiveProxies -> false ]
fΘvr. 13, 2017 1:14:23 PM com.mchange.v2.c3p0.DriverManagerDataSource ensureDriv
erLoaded
AVERTISSEMENT: Could not load driverClass mariadb-java-client-1.5.7
java.lang.ClassNotFoundException: mariadb-java-client-1.5.7
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
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)

fΘvr. 13, 2017 1:14:23 PM com.mchange.v2.c3p0.DriverManagerDataSource ensureDriv
erLoaded
AVERTISSEMENT: Could not load driverClass mariadb-java-client-1.5.7
java.lang.ClassNotFoundException: mariadb-java-client-1.5.7
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
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)

fΘvr. 13, 2017 1:14:23 PM com.mchange.v2.c3p0.DriverManagerDataSource ensureDriv
erLoaded
AVERTISSEMENT: Could not load driverClass mariadb-java-client-1.5.7
java.lang.ClassNotFoundException: mariadb-java-client-1.5.7
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
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)


What is wrong ?

Thanks for your help
Regards
Yves

 

[yves67]

Yes, I use jRDC2

 

[Erel]

You are confusing the jar name with the driver class.

The DriverClass should be:

org.mariadb.jdbc.Driver

 

[yves67]

OK.... THANKS A LOT
You are right, it is working fine now

Regards
Yves