Android Question [SOLVED] JRDC2 error after Java Update

makis_best · May 10, 2021

Hi all

I have one project using JRDC2 and Android as clients.
Jrdc2 is on a Windows Server and Microsoft SQL
The project was working fine for many months until yesterday Java update by it self.

Then my connection stop working.

If I run JRDC2 on my client computer through B4J, connection is working fine.
From my browser on my client computer I get

B4X:

http://localhost:17178/test
Then I get correct
RemoteServer is running (05/10/2021 11:02:27)
Connection successful.

But if i try to connect to my Windows Server with JRDC2 running I get

B4X:

http://192.168.1.2:17178/test
Then I get
RemoteServer is running (05/10/2021 11:14:06)
Error fetching connection.

Why that happen?

Any idea?

Erel · May 10, 2021

makis_best said:
Why that happen?

You need to allow incoming connections on port 17178 in Windows Firewall. You probably had a rule, created automatically, for the previous Java version.

makis_best · May 10, 2021

Erel said:
You need to allow incoming connections on port 17178 in Windows Firewall. You probably had a rule, created automatically, for the previous Java version.

Firewall is all off as before.
We down have firewall working on any computer on our network cuz on Internet connection we have a watchguard running

Erel · May 10, 2021

I misread the server response. Your post isn't formatted correctly.

My guess is that it isn't related to the new Java.

Where is the database server located? Check the configuration file.
What do you see in the jRDC2 server logs?

makis_best · May 10, 2021

Erel said:
I misread the server response. Your post isn't formatted correctly.

My guess is that it isn't related to the new Java.

Where is the database server located? Check the configuration file.
What do you see in the jRDC2 server logs?

On B4J I see

B4X:

Waiting for debugger to connect...
Program started.
2021-05-10 11:00:30.170:INFO::main: Logging initialized @608ms to org.eclipse.jetty.util.log.StdErrLog
ΞΞ±Ο 10, 2021 11:00:30 Ξ Ξ com.mchange.v2.log.MLog
INFO: MLog clients using java 1.4+ standard logging.
ΞΞ±Ο 10, 2021 11:00:30 Ξ Ξ com.mchange.v2.c3p0.C3P0Registry
INFO: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
2021-05-10 11:00:30.676:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 1.8.0_281-b09
2021-05-10 11:00:30.720:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2021-05-10 11:00:30.720:INFO:oejs.session:main: No SessionScavenger set, using defaults
2021-05-10 11:00:30.722:INFO:oejs.session:main: node0 Scavenging every 660000ms
2021-05-10 11:00:30.727:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@7276c8cd{/,file:///C:/MEGA/B4J%20Project/jRDC2/jRDC/Objects/www,AVAILABLE}
2021-05-10 11:00:30.731:INFO:oejs.AbstractNCSARequestLog:main: Opened C:\MEGA\B4J Project\jRDC2\jRDC\Objects\logs\b4j-2021_05_10.request.log
2021-05-10 11:00:30.744:INFO:oejs.AbstractConnector:main: Started ServerConnector@727803de{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
2021-05-10 11:00:30.744:INFO:oejs.Server:main: Started @1185ms
Emulated network latency: 100ms
jRDC is running (version = 2.22)
ΞΞ±Ο 10, 2021 11:02:27 Ξ Ξ 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 -> 1hgeby9ahnnyfma1ui5vrs|23223dd8, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.microsoft.sqlserver.jdbc.SQLServerDriver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hgeby9ahnnyfma1ui5vrs|23223dd8, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:sqlserver://192.168.1.2;databaseName=EXPIosif;, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTi...

And on Server I see

B4X:

192.168.1.2 - - [10/May/2021:08:14:06 +0000] "GET /test HTTP/1.1" 200 76 "-" "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36"
0:0:0:0:0:0:0:1 - - [10/May/2021:08:14:37 +0000] "GET /favicon.ico HTTP/1.1" 404 326 "http://localhost:17178/test" "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36"
192.168.1.2 - - [10/May/2021:08:14:38 +0000] "GET /favicon.ico HTTP/1.1" 404 326 "http://192.168.1.2:17178/test" "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36"

When I run it from my pc connection made to the Windows server through lan
But when running local on server connection is not made.
Server firewall is off

When I do a request on chrome inside windows server task manager show that resources are used but no response.

makis_best · May 10, 2021

What the error means?

B4X:

com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "The server selected protocol version TLS10 is not accepted by client preferences [TLS12]". ClientConnectionId:76ada2a4-294a-41ff-8c64-24918c688a30

DonManfred · May 10, 2021

makis_best said:
TLS10 is not accepted by client preferences [TLS12]

you are trying to use TLS10 but the server does not accept TLS1.0 but need TLS1.2
Or vice versa.
You need to check your SSL-Settings...

makis_best · May 10, 2021

SSL-Settings??

I don't use any.

If needed where I need to implement them?

DonManfred · May 10, 2021

Search Results

www.b4x.com

walt61 · May 10, 2021

That one got me puzzled too, I found the solution by googling it: edit file "C:\Program Files\Java\jre1.8.0_291\lib\security\java.security" (edit the path for your JRE directory of course), and turn the "jdk.tls.disabledAlgorithms" entry into comment. Its default settings have changed with the new JRE version.

makis_best · May 10, 2021

walt61 said:
That one got me puzzled too, I found the solution by googling it: edit file "C:\Program Files\Java\jre1.8.0_291\lib\security\java.security" (edit the path for your JRE directory of course), and turn the "jdk.tls.disabledAlgorithms" entry into comment. Its default settings have changed with the new JRE version.

I try you solution but not working for me

walt61 · May 10, 2021

Hmmm... I think I also rebooted after that change, to make sure that the old config wouldn't remain 'hanging' somewhere. If that doesn't do the trick, I'm afraid I'm out of options; the one I mentioned worked for me

makis_best · May 10, 2021

My problem is why when I run jRDC.jar on my PC working just fine and when I run it on Wondows Server not.

josejad · May 10, 2021

Have you tried some of the google solutions?

JDBC Connections fails with "The driver could not establish a secure connection to SQL Server...."

SQL Server JDBC Connectivity Error on JDK 1.7.0: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption

techcommunity.microsoft.com

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption.

First published on MSDN on Sep 09, 2008 What is SSL and why is my JDBC driver using it?The v1.

techcommunity.microsoft.com

SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption

I am getting the following error when connecting to a SQL Server database using version the Microsoft JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a

stackoverflow.com

makis_best · May 10, 2021

José J. Aguilar said:
Have you tried some of the google solutions?

JDBC Connections fails with "The driver could not establish a secure connection to SQL Server...."

SQL Server JDBC Connectivity Error on JDK 1.7.0: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption

techcommunity.microsoft.com

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption.

First published on MSDN on Sep 09, 2008 What is SSL and why is my JDBC driver using it?The v1.

techcommunity.microsoft.com

SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption

I am getting the following error when connecting to a SQL Server database using version the Microsoft JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a

stackoverflow.com

I try those also.... Nothing change

Erel · May 10, 2021

You should configure your server to support TLS 1.2.

This might help: https://dba.stackexchange.com/quest...-database-level-if-yes-then-how/276116#276116
If not, check your server documentation.

makis_best · May 10, 2021

OK....

After lot of research about why the same jar file working fine in 4 different pc's on the
same lan but not on the server of the lan come to nothing.

So I decide to change tactic... I decide to change driver.
So I jump from com.microsoft.sqlserver.jdbc.SQLServerDriver
to net.sourceforge.jtds.jdbc.Driver

I compile again..... and Boom.... everything working fine.
Maybe a new jRDC3 need to come out with more SSL options integrated

The question remain but for the moment problem solved
Thank you all for your help.

Erel · May 10, 2021

makis_best said:
Maybe a new jRDC3 need to come out with more SSL options integrated

It has nothing to do with jRDC. Your SQL driver, for good reasons, doesn't support TLS 1.0.

makis_best · May 10, 2021

Erel said:
It has nothing to do with jRDC. Your SQL driver, for good reasons, doesn't support TLS 1.0.

So.... where TLS 1.2 need to intergrade?

Erel · May 10, 2021

The SQL server. The error is between the db client (jRDC2) and the db server (SQL Server).

Android Question [SOLVED] JRDC2 error after Java Update

Well-Known Member

B4X founder

Well-Known Member

B4X founder

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Expert

Active Member

Well-Known Member

Active Member

Well-Known Member

Expert

Well-Known Member

B4X founder

Well-Known Member

B4X founder

Well-Known Member

B4X founder

Similar Threads