Publisher Worker Reports 'Cannot Create JDBC Driver Of Class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' Message (Doc ID 2276494.1)

Last updated on JUNE 16, 2017

Applies to:

Oracle Insurance Istream - Version 4.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 4.2.0 version, IStream Publisher

When Publisher Worker attempts to connect to the Publisher Database,
the following message is reported:


ERROR
-----------------------
2017-06-01 01:07:21,145 [ERROR] (NewMessageMover.java:202) [Thread-6] JMSType=[distribution-service], RequestID=[1496289940162], ParentID=[] - Error in closing connection.
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL 'jdbc:Sqlserver://host:1435;SelectMethod=cursor;DatabaseName=PublisherDB'
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at com.insystems.distributor.tools.DBConnectionFactory.getConnection(DBConnectionFactory.java:266)
at com.insystems.distributor.tools.InternalRequestIdGenerator.getConnection(InternalRequestIdGenerator.java:54)
at com.insystems.distributor.tools.InternalRequestIdGenerator.nextHighKey(InternalRequestIdGenerator.java:108)
at com.insystems.distributor.tools.InternalRequestIdGenerator.nextLong(InternalRequestIdGenerator.java:91)
at com.insystems.distributor.tools.InternalRequestIdGenerator.getID(InternalRequestIdGenerator.java:72)
at com.insystems.distributor.queueagent.NewMessageMover.processMessage(NewMessageMover.java:315)
at com.insystems.distributor.queueagent.NewMessageMover.run(NewMessageMover.java:166)
Caused by: java.sql.SQLException: No suitable driver



Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms