Microsoft JDBC Driver for SQL Server: IllegalAccessException

Question

When Using the latest JDBC Driver https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver17 we get the following error:

Caused by: javax.sql.rowset.spi.SyncFactoryException: IllegalAccessException: com.sun.rowset.providers.RIOptimisticProvider from [Module "org.wildfly.service" version 27.1.0.Final-redhat-00010 from local module loader @3b7d3a38 (finder: local module finder @416c58f5 (roots: /tmp/jboss-eap-8.1.0.GA-CR10.2/jboss-eap-8.1/modules,/tmp/jboss-eap-8.1.0.GA-CR10.2/jboss-eap-8.1/modules/system/layers/base))]
	at java.sql.rowset/javax.sql.rowset.spi.SyncFactory.getInstance(SyncFactory.java:591)
	at java.sql.rowset/com.sun.rowset.CachedRowSetImpl$1.run(CachedRowSetImpl.java:370)
	at java.sql.rowset/com.sun.rowset.CachedRowSetImpl$1.run(CachedRowSetImpl.java:367)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:712)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:891)
	at java.sql.rowset/com.sun.rowset.CachedRowSetImpl.<init>(CachedRowSetImpl.java:367)
	at java.sql.rowset/com.sun.rowset.RowSetFactoryImpl.createCachedRowSet(RowSetFactoryImpl.java:49)
	at deployment.mssql-jdbc-13.2.0.jre11.jar//com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getIndexInfo(SQLServerDatabaseMetaData.java:1421)
	at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.indexExists(AbstractTableManager.java:290)
	... 14 more

this is probably related to some changes introduced in the 13.2 version:

Answer 1

Have you reported this on the GitHub site for the driver? That is probably a better place to get help and attention.

https://github.com/microsoft/mssql-jdbc/blob/main/README.md