• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Secure Sockets Layer (SSL) encryption Error : MSSQL SERVER 2008

 
Abhishekshri Shrivastava
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am working on a web spring application. I have a databasex.xml file. I am trying to connect to a MSSQL SEVER 2008. I am getting following error:-->

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: class configured for SSLContext: com.sun.net.ssl.internal.ssl.SSLContextImpl not a SSLContext.

I am using
1. sqljdbc4.jar
2. JRE 1.6.0_31
3. JBOSS 6.1

The DB source bean as following:

I have also checked the /jre/lib/security configuration. even jsse.jar is in my buildpath.It's fine.
Please suggest me the solution.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Would this page be of any help? (I don't have any experience in the area, this just came out first from my search.)
 
Abhishekshri Shrivastava
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Martin Vajsar wrote:Would this page be of any help? (I don't have any experience in the area, this just came out first from my search.)



I tried by changing connection properties in url but it didn't work.

yes.. if I make encrypt=true; then get something different eror here as

Servlet.service() for servlet spring threw exception: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: class configured for TrustManagerFactory: com.sun.net.ssl.internal.ssl.TrustManagerFactoryImpl$PKIXFactory not a TrustManagerFactory.
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1509) [:]



even i tried by chnaging jre versions (as got somewhere that jdbc 4 ; jre 1.6.0_29 / 30 doesn't work properly for MS SQL connections.
even that didn't work.

The starnge thing is that --> if I make a jdbc connection in java console apps it works fine but doesn't work in a web application.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic