Issues making JBOSS 6.3.2 SQL JDBC connections when InsiteAgent.jar is applied
Article ID: 98156
CA Continuous Application Insight (PathFinder)Service Virtualization
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
All Supported DevTest Environments
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.
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.