I changed my JAVA, NOW, I have Database Issues getting to our SQL-Server over SSL
Question ID: 109316

Last week, we had trouble starting our ALM service because our (Oracle) JAVA decided to update itself and messed up the path to the JVM.

changed my JAVA:



We resolved that, now, we have a “Database connection” error in our Wrapper Log.


INFO   | jvm 1    | 2020/02/10 15:41:10.770 | 2020-02-10 15:41 WrapperSimpleAppMain 
ERR com.hp.alm.platform.db.CConnectionManager 
Can't create a new database connection for 
url 'jdbc:mercury:sqlserver<strong>://almdb.mycompany.com:1433</strong>;EncryptionMethod=SSL' 
on getting connection to database server 


We use SQL-Server over SSL and it worked just fine before all of this mess from JAVA upgrading itself  to a newer build and changing the path to the JAVA.exe.

We checked basic connections to SQL-Server with PING, Telnet, ODBC, and SQL-Management Studio from the ALM Server PC.

Our usernames, rights and passwords are OK, WHY is it not connecting?

Marked as spam
Posted by (Questions: 91, Answers: 5)
Asked on February 11, 2020 5:17 pm
Answers (1)
Private answer

You need a cert for SQL-Server/SSL in the JAVA cacerts file... BUT it was removed with the old JAVA and replace with a "blank" one from AdoptOpenJDK!

You need to add the cert (for the SQL-Server using SSL) with the keytool command as specified in the install guide and it should work.

SO, the JAVA Update caused all of this:
1) path to java.exe changed
2) needed to re-point micro focus_java_home to new path (as long as no other conflicting java.exe's), or
2a) needed to install substitute JAVA (AdoptJDK 8) and re-point micro focus_java_home to new path
3) cacerts (that had the correct SQL-Server/SSL cert) was removed with older JAVA, so needed to re-import cert(s)

Marked as spam
Posted by (Questions: 4, Answers: 509)
Answered on February 11, 2020 6:08 pm

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top