Skip to content

Microsoft JDBC Driver for SQL Server: IllegalAccessException #2778

Closed
#2763
Closed
Microsoft JDBC Driver for SQL Server: IllegalAccessException#2778
#2763
Assignees
Ananya2
@tommaso-borgato

Description

@tommaso-borgato
tommaso-borgato
opened on Sep 19, 2025

Driver version

Microsoft JDBC Driver 13.2.0 for SQL Server

SQL Server version

Output of executing SELECT @@VERSION on target SQL Server:

Microsoft SQL Server 2022 (RTM-CU19-GDR) (KB5058721) - 16.0.4200.1 (X64) 
	May 31 2025 08:13:20 
	Copyright (C) 2022 Microsoft Corporation
	Developer Edition (64-bit) on Linux (Ubuntu 22.04.5 LTS) <X64>

Client Operating System

Fedora 41 and RHEL9

JAVA/JVM version

$ java -version
java version "17.0.10" 2024-01-16 LTS
Java(TM) SE Runtime Environment (build 17.0.10+11-LTS-240)
Java HotSpot(TM) 64-Bit Server VM (build 17.0.10+11-LTS-240, mixed mode, sharing)

Table schema

N/A

Problem description

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 [email protected]//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.indexExists(AbstractTableManager.java:290)
	... 14 more

Some more info can be found here: https://learn.microsoft.com/en-us/answers/questions/5560429/microsoft-jdbc-driver-for-sql-server-illegalaccess

Expected behavior

No IllegalAccessException

Actual behavior

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 [email protected]//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.indexExists(AbstractTableManager.java:290)
	... 14 more

Error message/stack trace

2025-09-19 14:02:06,888 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 85) MSC000001: Failed to start null: org.jboss.msc.service.StartException in anonymous service: org.infinispan.commons.CacheConfigurationException: ISPN000659: Component ComponentWrapper{name=org.infinispan.persistence.manager.PersistenceManager, instance=org.infinispan.persistence.manager.PersistenceManagerImpl@41f96888, status=FAILED} failed to start
	at [email protected]//org.wildfly.service.AsyncServiceBuilder$AsyncService.lambda$start$0(AsyncServiceBuilder.java:92)
	at [email protected]//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
	at [email protected]//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
	at [email protected]//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
	at [email protected]//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
	at java.base/java.lang.Thread.run(Thread.java:842)
	at [email protected]//org.jboss.threads.JBossThread.run(JBossThread.java:513)
Caused by: org.infinispan.commons.CacheConfigurationException: ISPN000659: Component ComponentWrapper{name=org.infinispan.persistence.manager.PersistenceManager, instance=org.infinispan.persistence.manager.PersistenceManagerImpl@41f96888, status=FAILED} failed to start
	at [email protected]//org.infinispan.factories.impl.BasicComponentRegistryImpl.startWrapper(BasicComponentRegistryImpl.java:584)
	at [email protected]//org.infinispan.factories.impl.BasicComponentRegistryImpl$ComponentWrapper.running(BasicComponentRegistryImpl.java:807)
	at [email protected]//org.infinispan.factories.ComponentRegistry.getLocalComponent(ComponentRegistry.java:187)
	at [email protected]//org.infinispan.factories.ComponentRegistry.getLocalComponent(ComponentRegistry.java:192)
	at org.wildfly.clustering.cache.infinispan.embedded@5.0.10.Final-redhat-00001//org.wildfly.clustering.cache.infinispan.embedded.lifecycle.WildFlyClusteringModuleLifecycle.cacheStarting(WildFlyClusteringModuleLifecycle.java:31)
	at [email protected]//org.infinispan.factories.ComponentRegistry.notifyCacheStarting(ComponentRegistry.java:270)
	at [email protected]//org.infinispan.factories.ComponentRegistry.preStart(ComponentRegistry.java:257)
	at [email protected]//org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:244)
	at [email protected]//org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:222)
	at [email protected]//org.infinispan.cache.impl.CacheImpl.start(CacheImpl.java:1037)
	at [email protected]//org.infinispan.cache.impl.AbstractDelegatingCache.start(AbstractDelegatingCache.java:515)
	at [email protected]//org.infinispan.manager.DefaultCacheManager.wireAndStartCache(DefaultCacheManager.java:736)
	at [email protected]//org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:682)
	at [email protected]//org.infinispan.manager.DefaultCacheManager.internalGetCache(DefaultCacheManager.java:575)
	at [email protected]//org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:590)
	at [email protected]//org.jboss.as.clustering.infinispan.manager.DefaultCacheContainer$1.run(DefaultCacheContainer.java:109)
	at [email protected]//org.jboss.as.clustering.infinispan.manager.DefaultCacheContainer$1.run(DefaultCacheContainer.java:106)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:318)
	at [email protected]//org.jboss.as.clustering.infinispan.manager.DefaultCacheContainer.getCache(DefaultCacheContainer.java:106)
	at [email protected]//org.jboss.as.clustering.infinispan.manager.DefaultCacheContainer.getCache(DefaultCacheContainer.java:101)
	at org.wildfly.clustering.infinispan.embedded.service@8.1.0.GA-redhat-00015//org.wildfly.clustering.infinispan.service.CacheServiceInstallerFactory$1.get(CacheServiceInstallerFactory.java:75)
	at org.wildfly.clustering.infinispan.embedded.service@8.1.0.GA-redhat-00015//org.wildfly.clustering.infinispan.service.CacheServiceInstallerFactory$1.get(CacheServiceInstallerFactory.java:55)
	at [email protected]//org.wildfly.service.Installer$UnaryService.start(Installer.java:443)
	at [email protected]//org.wildfly.service.AsyncServiceBuilder$AsyncService.lambda$start$0(AsyncServiceBuilder.java:87)
	... 6 more
Caused by: java.util.concurrent.CompletionException: org.infinispan.persistence.spi.PersistenceException: 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.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:315)
	at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:320)
	at java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1807)
	at [email protected]//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
	at [email protected]//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
	at [email protected]//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
	at [email protected]//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
	at [email protected]//org.wildfly.clustering.context.ContextualExecutor$1.execute(ContextualExecutor.java:180)
	at [email protected]//org.wildfly.clustering.context.ContextualExecutor.execute(ContextualExecutor.java:31)
	at [email protected]//org.wildfly.clustering.context.Contextualizer$2$1.run(Contextualizer.java:220)
	at java.base/java.lang.Thread.run(Thread.java:842)
Caused by: org.infinispan.persistence.spi.PersistenceException: 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 [email protected]//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.indexExists(AbstractTableManager.java:298)
	at [email protected]//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.createIndex(AbstractTableManager.java:276)
	at [email protected]//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.start(AbstractTableManager.java:144)
	at [email protected]//org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.createTableOperations(JdbcStringBasedStore.java:124)
	at [email protected]//org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.createTableOperations(JdbcStringBasedStore.java:84)
	at [email protected]//org.infinispan.persistence.jdbc.common.impl.BaseJdbcStore.lambda$start$0(BaseJdbcStore.java:72)
	at java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804)
	... 8 more
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 [email protected]//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.indexExists(AbstractTableManager.java:290)
	... 14 more

2025-09-19 14:02:06,889 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 1) WFLYCTL0013: Operation ("deploy") failed - address: ({"deployment" => "cbnc.ear"}) - failure description: {"WFLYCTL0080: Failed services" => {
    "org.wildfly.clustering.infinispan.cache.web.\"cbnc.ear.a.war\"" => "org.infinispan.commons.CacheConfigurationException: ISPN000659: Component ComponentWrapper{name=org.infinispan.persistence.manager.PersistenceManager, instance=org.infinispan.persistence.manager.PersistenceManagerImpl@41f96888, status=FAILED} failed to start
    Caused by: org.infinispan.commons.CacheConfigurationException: ISPN000659: Component ComponentWrapper{name=org.infinispan.persistence.manager.PersistenceManager, instance=org.infinispan.persistence.manager.PersistenceManagerImpl@41f96888, status=FAILED} failed to start
    Caused by: java.util.concurrent.CompletionException: org.infinispan.persistence.spi.PersistenceException: 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))]
    Caused by: org.infinispan.persistence.spi.PersistenceException: 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))]
    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))]",
    "org.wildfly.clustering.infinispan.cache.web.\"cbnc.ear.b.war\"" => "org.infinispan.commons.CacheConfigurationException: ISPN000659: Component ComponentWrapper{name=org.infinispan.persistence.manager.PersistenceManager, instance=org.infinispan.persistence.manager.PersistenceManagerImpl@6961a49b, status=FAILED} failed to start
    Caused by: org.infinispan.commons.CacheConfigurationException: ISPN000659: Component ComponentWrapper{name=org.infinispan.persistence.manager.PersistenceManager, instance=org.infinispan.persistence.manager.PersistenceManagerImpl@6961a49b, status=FAILED} failed to start
    Caused by: java.util.concurrent.CompletionException: org.infinispan.persistence.spi.PersistenceException: 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))]
    Caused by: org.infinispan.persistence.spi.PersistenceException: 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))]
    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))]"
}}
2025-09-19 14:02:06,890 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 1) WFLYCTL0013: Operation ("deploy") failed - address: ({"deployment" => "cbnc.ear"}) - failure description: {"WFLYCTL0080: Failed services" => {
    "org.wildfly.clustering.infinispan.cache.web.\"cbnc.ear.a.war\"" => "org.infinispan.commons.CacheConfigurationException: ISPN000659: Component ComponentWrapper{name=org.infinispan.persistence.manager.PersistenceManager, instance=org.infinispan.persistence.manager.PersistenceManagerImpl@41f96888, status=FAILED} failed to start
    Caused by: org.infinispan.commons.CacheConfigurationException: ISPN000659: Component ComponentWrapper{name=org.infinispan.persistence.manager.PersistenceManager, instance=org.infinispan.persistence.manager.PersistenceManagerImpl@41f96888, status=FAILED} failed to start
    Caused by: java.util.concurrent.CompletionException: org.infinispan.persistence.spi.PersistenceException: 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))]
    Caused by: org.infinispan.persistence.spi.PersistenceException: 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))]
    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))]",
    "org.wildfly.clustering.infinispan.cache.web.\"cbnc.ear.b.war\"" => "org.infinispan.commons.CacheConfigurationException: ISPN000659: Component ComponentWrapper{name=org.infinispan.persistence.manager.PersistenceManager, instance=org.infinispan.persistence.manager.PersistenceManagerImpl@6961a49b, status=FAILED} failed to start
    Caused by: org.infinispan.commons.CacheConfigurationException: ISPN000659: Component ComponentWrapper{name=org.infinispan.persistence.manager.PersistenceManager, instance=org.infinispan.persistence.manager.PersistenceManagerImpl@6961a49b, status=FAILED} failed to start
    Caused by: java.util.concurrent.CompletionException: org.infinispan.persistence.spi.PersistenceException: 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))]
    Caused by: org.infinispan.persistence.spi.PersistenceException: 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))]
    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))]"
}}
2025-09-19 14:02:06,890 ERROR [org.jboss.as.server] (management-handler-thread - 1) WFLYSRV0021: Deploy of deployment "cbnc.ear" was rolled back with the following failure message: 
{"WFLYCTL0080: Failed services" => {
    "org.wildfly.clustering.infinispan.cache.web.\"cbnc.ear.a.war\"" => "org.infinispan.commons.CacheConfigurationException: ISPN000659: Component ComponentWrapper{name=org.infinispan.persistence.manager.PersistenceManager, instance=org.infinispan.persistence.manager.PersistenceManagerImpl@41f96888, status=FAILED} failed to start
    Caused by: org.infinispan.commons.CacheConfigurationException: ISPN000659: Component ComponentWrapper{name=org.infinispan.persistence.manager.PersistenceManager, instance=org.infinispan.persistence.manager.PersistenceManagerImpl@41f96888, status=FAILED} failed to start
    Caused by: java.util.concurrent.CompletionException: org.infinispan.persistence.spi.PersistenceException: 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))]
    Caused by: org.infinispan.persistence.spi.PersistenceException: 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))]
    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))]",
    "org.wildfly.clustering.infinispan.cache.web.\"cbnc.ear.b.war\"" => "org.infinispan.commons.CacheConfigurationException: ISPN000659: Component ComponentWrapper{name=org.infinispan.persistence.manager.PersistenceManager, instance=org.infinispan.persistence.manager.PersistenceManagerImpl@6961a49b, status=FAILED} failed to start
    Caused by: org.infinispan.commons.CacheConfigurationException: ISPN000659: Component ComponentWrapper{name=org.infinispan.persistence.manager.PersistenceManager, instance=org.infinispan.persistence.manager.PersistenceManagerImpl@6961a49b, status=FAILED} failed to start
    Caused by: java.util.concurrent.CompletionException: org.infinispan.persistence.spi.PersistenceException: 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))]
    Caused by: org.infinispan.persistence.spi.PersistenceException: 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))]
    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))]"
}}

Any other details that can be helpful

In order to reproduce the error:

Start MSSQL:

podman run -it --rm --network host -e ACCEPT_EULA=Y -e MSSQL_SA_PASSWORD=1234.pass --name mssql-database mcr.microsoft.com/mssql/server:2022-CU19-GDR1-ubuntu-22.04

Start WildFly:

wildfly/bin/standalone.sh --server-config=standalone-ha.xml

Deploy the JDBC Driver and configure wildfly as in the follwoing:

wildfly/bin/jboss-cli.sh
connect
deploy /tmp/sqljdbc_13.2.0.0_enu/sqljdbc_13.2/enu/jars/mssql-jdbc-13.2.0.jre11.jar

/subsystem=jgroups/channel=ee:write-attribute(name=stack,value=tcp)
/subsystem=infinispan/cache-container=web/invalidation-cache=offload:add()
data-source add --name=testDS --jndi-name=java:jboss/datasources/testDS --driver-name=mssql-jdbc-13.2.0.jre11.jar --connection-url=jdbc:sqlserver://127.0.0.1:1433;DatabaseName=tempdb;encrypt=false --enabled=true --jta=true --use-java-context=true --transaction-isolation=TRANSACTION_READ_COMMITTED --min-pool-size=5 --max-pool-size=100 --pool-prefill=true --user-name=sa --password=1234.pass
/subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc:add(data-source=testDS,fetch-state=false,passivation=false,purge=false,shared=true,dialect=SQL_SERVER){allow-resource-service-restart=true}
/subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc/table=string:write-attribute(name=id-column.name,value=id)
/subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc/table=string:write-attribute(name=data-column.name,value=datum)
/subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc/table=string:write-attribute(name=timestamp-column.name,value=version)
/subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc/table=string:write-attribute(name=id-column.type,value=VARCHAR(255))
/subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc/table=string:write-attribute(name=timestamp-column.type,value=BIGINT)
/subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc/table=string:write-attribute(name=data-column.type,value=VARBINARY(8000))
/subsystem=infinispan/cache-container=web:write-attribute(name=default-cache, value=offload)
/subsystem=transactions:write-attribute(name=node-identifier,value=wildfly1)

deploy clusterbench:

deploy /tmp/cbnc.ear

JDBC trace logs

JDBC driver trace logs in server.log (obtained with /subsystem=logging/logger=com.microsoft.sqlserver.jdbc:add(level=TRACE))

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions