MQSeries.net :: View topic - .Cannot find any provider supporting RC4/ECB/NOPADDING error

martc · Posted: Mon Aug 17, 2015 9:14 am Post subject:

Hi, I am attempting to call a Composite Stored Procedure on a JCN and am receiving the following error. This is only happening when executing on the IIB environment (9.x or 10x). Running the JDBC code on a non IIB environment (i.e. SUN Java JDK) does not cause any issues.

Obviously there seems to be conflicts with the IBM JDK implementation as the stack shows the invocation in: com.ibm.crypto.provider.RC4.engineSetMode(Unknown Source)...

Is there a way around this? Anythoughts, solutions.

The java code is a straightforward JDBC call:

public ResultSet getPDDResultSet(String storedProcedure, String jdbcDbUrl, String jdbcDbClass, String username,
String password) throws SQLException, ClassNotFoundException, JSONException, IOException {

if (jdbcDbUrl == null || jdbcDbUrl.isEmpty() || jdbcDbUrl.equalsIgnoreCase("null")) {
jdbcDbUrl = "jdbc:compositesw:dbapi@RCOVLNX031:9401?domain=composite&registerOutputCursors=false&dataSource=mm";
}
if (jdbcDbClass == null || jdbcDbClass.isEmpty() || jdbcDbClass.equalsIgnoreCase("null")) {
jdbcDbClass = "cs.jdbc.driver.CompositeDriver";
}
if (username == null || username.isEmpty() || username.equalsIgnoreCase("null")) {
username = "yy";
}
if (password == null || password.isEmpty() || password.equalsIgnoreCase("null")) {

password = "xx";
}

Connection dbConnection = null;
Class.forName(jdbcDbClass);
Error here: dbConnection = DriverManager.getConnection(jdbcDbUrl, username, password);
CallableStatement theCallableStatement = null;
theCallableStatement = dbConnection.prepareCall(storedProcedure);
ResultSet theResultSet = theCallableStatement.executeQuery();
System.out.println("Got resultset Column Count,Row count:" +
theResultSet.getMetaData().getColumnCount()+","+theResultSet.getFetchSize());
// System.out.println("Got resultset row Count:" +
// theResultSet.getFetchSize());

return theResultSet;
}

Stack Trace:

Exception in thread "main" cs.jdbc.driver.protocol.UnexpectedException: java.security.NoSuchAlgorithmException: Cannot find any provider supporting RC4/ECB/NOPADDING
at cs.jdbc.driver.DriverOptions.encrypt(DriverOptions.java:422)
at cs.jdbc.driver.DriverOptions.encode(DriverOptions.java:164)
at cs.jdbc.driver.ClientChannelConnection$4.encode(ClientChannelConnection.java:1075)
at cs.jdbc.driver.ClientChannelConnection.invokeCommand(ClientChannelConnection.java:965)
at cs.jdbc.driver.ClientChannelConnection.init(ClientChannelConnection.java:1097)
at cs.jdbc.driver.ClientChannelConnection.<init>(ClientChannelConnection.java:189)
at cs.jdbc.driver.CompositeConnection.getChannel(CompositeConnection.java:165)
at cs.jdbc.driver.DatabaseMetaDataImpl.<init>(DatabaseMetaDataImpl.java:39)
at cs.jdbc.driver.CompositeConnection.<init>(CompositeConnection.java:123)
at cs.jdbc.driver.CompositeDriver.connect(CompositeDriver.java:59)
at cs.jdbc.driver.CompositeDriver.connect(CompositeDriver.java:22)
at java.sql.DriverManager.getConnection(DriverManager.java:590)
at java.sql.DriverManager.getConnection(DriverManager.java:232)
at com.ft.pdd.PDSService.getPDDString(PDSService.java:52)
at PDSClient.main(PDSClient.java:21)
Caused by: java.security.NoSuchAlgorithmException: Cannot find any provider supporting RC4/ECB/NOPADDING
at javax.crypto.Cipher.getInstance(Unknown Source)
at cs.jdbc.driver.protocol.Encryption.symmEncrypt(Encryption.java:44)
at cs.jdbc.driver.DriverOptions.encrypt(DriverOptions.java:418)
... 14 more
Caused by: java.security.NoSuchAlgorithmException: Mode is not supported in RC4
at com.ibm.crypto.provider.RC4.engineSetMode(Unknown Source)
at javax.crypto.Cipher$a_.a(Unknown Source)
... 17 more
09:54:18.080 ERROR: [EventDispatcher.cpp:79] Exception in EventDispatcher thread: TransportException [510/201] there isn't an open connection to a debugger