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

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:

<bean id="sqlServerDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
      <property name="properties">
                  <props>
                        <prop key="APPLICATIONNAME">MyApps</prop>
                  </props>               
            </property>
            <property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
     
            <property name="jdbcUrl" value="jdbc:sqlserver://hostname:1433;databaseName=DbName"/>
            <property name="user" value="user1" />
            <property name="password" value="password1"/>
            <property name="maxPoolSize" value="5" />
            <property name="minPoolSize" value="1"/>
            <property name="initialPoolSize" value="3"/>
            <property name="acquireIncrement" value="1"/>
            <property name="maxIdleTime" value="0"/> 
            <property name="checkoutTimeout" value="0" /> 
            <property name="maxStatementsPerConnection" value="10"/>
    </bean>

I have also checked the /jre/lib/security configuration. even jsse.jar is in my buildpath.It's fine.
Please suggest me the solution.

Would this page be of any help? (I don't have any experience in the area, this just came out first from my search.)

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.