NoSuchAlgorithmException using MS SQL JDBC driver

[heidi.m.z400]

I'm using version 4.2.0-fuse-002-00 of the FUSE ESB, version 3.0.1301.101 of the MS SQL JDBC 4 jdbc driver, version 1.4 of commons dbcp and version 1.5.4 of commons pool.

I have created an OSGi bundle, which executes code that tries to get a connection with the server. An exception is thrown during the SSL exchange.

When I execute the same code outside of the FUSE ESB, the connection is established successfully.

The root of the exception is:

Caused by: java.security.NoSuchAlgorithmException: SunTlsRsaPremasterSecretKeyGenerator not available

        at javax.crypto.KeyGenerator.(RSAClientKeyExchange.java:89)

The code I'm using is:

BasicDataSource ds = new BasicDataSource();

ds.setDriverClassName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

ds.setUsername("sa");

ds.setPassword("*****");

ds.setUrl("jdbc:sqlserver://;serverName=myserver125.ca.comportNumber=1433;databaseName=mydatabasename");

Connection conn = ds.getConnection();

Any suggestions on how to resolve this would be appreciated.

Thx

[ffang]

Hi,

Could you please check the path for sunjce_provider.jar from your jdk?

By default, it should be in $/lib/ext, but for some platform or jre installation, it's in $/jre/lib/ext. If you're in the second case, you should edit $SMX4_HOME/bin/servicemix, change -Djava.ext.dirs accordingly.

Freeman

[heidi.m.z400]

This is resolved by modifying the startup script as described here:

http://servicemix.396122.n5.nabble.com/jira-Created-SMX4-537-Startup-script-bin-servicemix-misconfigures-java-ext-dirs-breaking-things-likeF-td510983.html