on Jun 14, 2016Article Content
| Article Number | 000030143 |
| Applies To | RSA Product Set: Identity Management and Governance RSA Product/Service Type: Enterprise Software RSA Version/Condition: 6.9, 6.9.1 Platform: SUSE Linux Product Description: Access Fulfill Express (AFX), IMG Collectors |
| Issue | Connections through collectors or AFX to SQL Server fail. Discovery for AFX: mule_ee.log contains: Exception followed by: Caused by: java.lang.UnsupportedClassVersionError: net/sourceforge/jtds/jdbc/Driver : Unsupported major.minor version 51.0 Discovery for collections: Error on screen says: Collector test failed: com.aveksa.server.runtime.ServerException: Test request failed with response: com.aveksa.server.runtime.ServerException: com.aveksa.sdk.collector.CollectionException: com.aveksa.common.DataReadException: ERROR: Could not get accounts data: . Caused by com.aveksa.common.DataReadException: ERROR: Could not get accounts data: . Caused by java.sql.SQLException: No suitable driver found for jdbc:sqlserver://node,domain.com:1433;databaseName=somedatabase |
| Cause | Customer downloaded the latest jTDS driver 1.3.1 This driver is compatible with Java 7, but not Java 6. Reference: http://stackoverflow.com/questions/13403471/unsupported-version-error-using-jtds-with-scala |
| Resolution | IMG 6.9.1 and lower are using Java 6. so JTDS driver 1.2.x is needed as 1.3.x will not work. After you have dropped the driver into /home/oracle/jboss-4.2.2.GA/server/default/lib, you will need to restart ACM and AFX if you are using AFX. |