B4J Question WebApp and JrdcUtil2 - general error

1) Wow! Someone is using jRDC2Utils!!!! ?

Now some questions:
2) Which jRDC2 server are you using? Stock? Modified? If Modified, which one?
3) Are you sure select_OFKupci is in config.properties of the jRDC2 server?
4) What does the error log show on the jRDC2 server? Can you run the server in debug mode and see the full error message (trace stack and all)?

Note: Use code tags to post your code. You can also use the drop down list (the ...) next to the smiley face in the editor box to insert code tags (via the </> Code or >_ Inline code options). You can use the Quote option to post error messages.

OliverA said:

1) Wow! Someone is using jRDC2Utils!!!! ?

Click to expand...

Why WoW? I think - this is really great utility and why not to use it?! In any case - big like for this ...

OliverA said:

2) Which jRDC2 server are you using? Stock? Modified? If Modified, which one?
I'm using "standard" solution of jRDC - downloaded from
jRDC2 - B4J implementation of RDC (Remote Database Connector)

and just little modified, that I can access sql server. And that works...

3) Are you sure select_OFKupci is in config.properties of the jRDC2 server?
Totaly sure... I builded one little android application (b4a) which has connection to RDC and can download the data...

4) What does the error log show on the jRDC2 server? Can you run the server in debug mode and see the full error message (trace stack and all)?

Click to expand...

Here is ErrorLog from Debug of RDC - nothing special:

Waiting for debugger to connect...
Program started.
2020-04-10 16:41:33.683:INFO::main: Logging initialized @591ms to org.eclipse.jetty.util.log.StdErrLog
apr. 10, 2020 4:41:33 PM com.mchange.v2.log.MLog
INFO: MLog clients using java 1.4+ standard logging.
apr. 10, 2020 4:41:34 PM com.mchange.v2.c3p0.C3P0Registry
INFO: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
2020-04-10 16:41:34.585:INFOejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 1.8.0_241-b07
2020-04-10 16:41:34.634:INFOejs.session:main: DefaultSessionIdManager workerName=node0
2020-04-10 16:41:34.634:INFOejs.session:main: No SessionScavenger set, using defaults
2020-04-10 16:41:34.638:INFOejs.session:main: node0 Scavenging every 600000ms
2020-04-10 16:41:34.642:INFOejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@3cb1ffe6{/,file:///C:/Work/Vtisk/B4JProjects/DatabaseConnector_SqlServer/Objects/www,AVAILABLE}
2020-04-10 16:41:34.647:INFOejs.AbstractNCSARequestLog:main: Opened C:\Work\Vtisk\B4JProjects\DatabaseConnector_SqlServer\Objects\logs\b4j-2020_04_10.request.log
2020-04-10 16:41:34.665:INFOejs.AbstractConnector:main: Started ServerConnector@2f9829{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
2020-04-10 16:41:34.666:INFOejs.Server:main: Started @1577ms
Emulated network latency: 100ms
jRDC is running (version = 2.28)
apr. 10, 2020 4:43:50 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource
INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1hgeby9a9rw95p8vf8y8x|61443d8f, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> net.sourceforge.jtds.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hgeby9a9rw95p8vf8y8x|61443d8f, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:jtds:sqlserver://192.168.204.159/utility, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleT...
(NullPointerException) java.lang.NullPointerException
Command: , took: 723ms, client=192.168.0.16"

Sounds like - system will not send real command to RDC server...

Please, if you can - take a look... If you need additional information, let me know... I really appreciate your help...

Thx, DArko

DarkoT said:

(NullPointerException) java.lang.NullPointerException
Command: , took: 723ms, client=192.168.0.16"

Click to expand...

That means that it could not find the "select_OFKupci" in the config.properties file. Please note, with the default jRDC2 server (that you are using), the config.properties file should be located under the Files folder of the project source tree. Every time you modify the config.properties file, you need to re-compile the jRDC2 source. If compiled in release mode then re-deploy (re-start) the newly created .jar file.

Totaly sure... I builded one little android application (b4a) which has connection to RDC and can download the data...

Click to expand...

Are you 100% sure the Android app and the ABMaterial web app are talking to the SAME server? It's just not possible that
works properly in the Android app and not in the web app especially, since both are using
So
1) Either the apps are using different servers, or
2) If the are using the same server, this ->select_OFKupci<- is spelled differently in one of the apps

@OliverA - please - accept my apologys... I was expecting that jRDC for Android and for WebApp can be same (on server site)... Now I changed Jrdc for android to Jrdc2 to WebApp and work perfect...

Sory for my mistake...

Thank you for your help... I owe you a big caffee...

Regards, Darko