Issues making JBOSS 6.3.2 SQL JDBC connections when InsiteAgent.jar is applied

Products

• CA Continuous Application Insight (PathFinder)
• Service Virtualization

Issue/Introduction

When trying to add the Insight Agent to  configured on JBOSS 6.3.2 with Microsoft SQL Server. , the data no longer comes in from the database.  If the standalone.sh is edited to remove loading the Agent jar, everything works as expected.  We use datasources with Spring to make the connection.  The agent is showing up on Application Insight through the portal and it looks like it's picking up the REST calls, but not the JDBC transactions.

WARN [org.jboss.modules] (http-/0.0.0.0:8280-4) Failed to define class com.microsoft.sqlserver.jdbc.ISQLServerConnection in Module "com.microsoft:main" from local module loader @6d4b1c02 (finder: local module finder @6093dd95 (roots: /opt/jboss/latest/modules,/opt/jboss/latest/modules/system/layers/base/.overlays/layer-base-jboss-eap-6.3.2.CP,/opt/jboss/latest/modules/system/layers/base)):
java.lang.SecurityException: class "com.microsoft.sqlserver.jdbc.ISQLServerConnection"'s signer information does not match signer information of other classes in the same package 

Environment

All Supported DevTest Environments

Cause

Was using signed MS SQL driver jar in 3 different places.   Replaced this with unsigned sqljdbc driver jar and was able to capture the transactions.

Resolution

Used unsigned jar  "sqljdbc4-4.0.2206.100-unsigned.jar "  instead of the signed MS SQL driver jars when using datasource with Spring to make JDBC connections.