Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-30974

[MSSQL] Error when using JDBC Driver mssql-jdbc-13.2.0.jre11.jar

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Critical Critical
    • None
    • 8.1.0.GA
    • Clustering
    • None
    • False
    • False
    • Workaround Exists
    • Hide

      Use an older JDBC driver

      Show
      Use an older JDBC driver
    • Hide

      Start the Database:

      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 EAP:

      jboss-eap-8.1/bin/standalone.sh --server-config=standalone-ha.xml

      Configure EAP:

      jboss-eap-8.1/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

      Error:

      2025-09-19 14:02:06,886 ERROR [org.infinispan.CONFIG] (ServerService Thread Pool -- 18) ISPN000660: Cache cbnc.ear.b.war start failed, stopping any running components: 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
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.impl.BasicComponentRegistryImpl.startWrapper(BasicComponentRegistryImpl.java:584)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.impl.BasicComponentRegistryImpl$ComponentWrapper.running(BasicComponentRegistryImpl.java:807)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.ComponentRegistry.getLocalComponent(ComponentRegistry.java:187)
	at org.infinispan.core@15.0.16.Final-redhat-00001//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 org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.ComponentRegistry.notifyCacheStarting(ComponentRegistry.java:270)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.ComponentRegistry.preStart(ComponentRegistry.java:257)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:244)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:222)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.cache.impl.CacheImpl.start(CacheImpl.java:1037)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.cache.impl.AbstractDelegatingCache.start(AbstractDelegatingCache.java:515)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.manager.DefaultCacheManager.wireAndStartCache(DefaultCacheManager.java:736)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:682)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.manager.DefaultCacheManager.internalGetCache(DefaultCacheManager.java:575)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:590)
	at org.jboss.as.clustering.infinispan@8.1.0.GA-redhat-00015//org.jboss.as.clustering.infinispan.manager.DefaultCacheContainer$1.run(DefaultCacheContainer.java:109)
	at org.jboss.as.clustering.infinispan@8.1.0.GA-redhat-00015//org.jboss.as.clustering.infinispan.manager.DefaultCacheContainer$1.run(DefaultCacheContainer.java:106)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:318)
	at org.jboss.as.clustering.infinispan@8.1.0.GA-redhat-00015//org.jboss.as.clustering.infinispan.manager.DefaultCacheContainer.getCache(DefaultCacheContainer.java:106)
	at org.jboss.as.clustering.infinispan@8.1.0.GA-redhat-00015//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 org.wildfly.service@27.1.0.Final-redhat-00010//org.wildfly.service.Installer$UnaryService.start(Installer.java:443)
	at org.wildfly.service@27.1.0.Final-redhat-00010//org.wildfly.service.AsyncServiceBuilder$AsyncService.lambda$start$0(AsyncServiceBuilder.java:87)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
	at java.base/java.lang.Thread.run(Thread.java:842)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.JBossThread.run(JBossThread.java:513)
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 org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1348)
	at org.wildfly.clustering.context@5.0.10.Final-redhat-00001//org.wildfly.clustering.context.ContextualExecutor$1.execute(ContextualExecutor.java:180)
	at org.wildfly.clustering.context@5.0.10.Final-redhat-00001//org.wildfly.clustering.context.ContextualExecutor.execute(ContextualExecutor.java:31)
	at org.wildfly.clustering.context@5.0.10.Final-redhat-00001//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 org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.indexExists(AbstractTableManager.java:298)
	at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.createIndex(AbstractTableManager.java:276)
	at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.start(AbstractTableManager.java:144)
	at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.createTableOperations(JdbcStringBasedStore.java:124)
	at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.createTableOperations(JdbcStringBasedStore.java:84)
	at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//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 org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.indexExists(AbstractTableManager.java:290)
	... 14 more
      Show
      Start the Database: 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 EAP: jboss-eap-8.1/bin/standalone.sh --server-config=standalone-ha.xml Configure EAP: jboss-eap-8.1/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 Error: 2025-09-19 14:02:06,886 ERROR [org.infinispan.CONFIG] (ServerService Thread Pool -- 18) ISPN000660: Cache cbnc.ear.b.war start failed, stopping any running components: 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 at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.impl.BasicComponentRegistryImpl.startWrapper(BasicComponentRegistryImpl.java:584) at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.impl.BasicComponentRegistryImpl$ComponentWrapper.running(BasicComponentRegistryImpl.java:807) at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.ComponentRegistry.getLocalComponent(ComponentRegistry.java:187) at org.infinispan.core@15.0.16.Final-redhat-00001//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 org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.ComponentRegistry.notifyCacheStarting(ComponentRegistry.java:270) at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.ComponentRegistry.preStart(ComponentRegistry.java:257) at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:244) at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:222) at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.cache.impl.CacheImpl.start(CacheImpl.java:1037) at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.cache.impl.AbstractDelegatingCache.start(AbstractDelegatingCache.java:515) at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.manager.DefaultCacheManager.wireAndStartCache(DefaultCacheManager.java:736) at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:682) at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.manager.DefaultCacheManager.internalGetCache(DefaultCacheManager.java:575) at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:590) at org.jboss.as.clustering.infinispan@8.1.0.GA-redhat-00015//org.jboss.as.clustering.infinispan.manager.DefaultCacheContainer$1.run(DefaultCacheContainer.java:109) at org.jboss.as.clustering.infinispan@8.1.0.GA-redhat-00015//org.jboss.as.clustering.infinispan.manager.DefaultCacheContainer$1.run(DefaultCacheContainer.java:106) at java.base/java.security.AccessController.doPrivileged(AccessController.java:318) at org.jboss.as.clustering.infinispan@8.1.0.GA-redhat-00015//org.jboss.as.clustering.infinispan.manager.DefaultCacheContainer.getCache(DefaultCacheContainer.java:106) at org.jboss.as.clustering.infinispan@8.1.0.GA-redhat-00015//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 org.wildfly.service@27.1.0.Final-redhat-00010//org.wildfly.service.Installer$UnaryService.start(Installer.java:443) at org.wildfly.service@27.1.0.Final-redhat-00010//org.wildfly.service.AsyncServiceBuilder$AsyncService.lambda$start$0(AsyncServiceBuilder.java:87) at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990) at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486) at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377) at java.base/java.lang.Thread.run(Thread.java:842) at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.JBossThread.run(JBossThread.java:513) 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 org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990) at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486) at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1348) at org.wildfly.clustering.context@5.0.10.Final-redhat-00001//org.wildfly.clustering.context.ContextualExecutor$1.execute(ContextualExecutor.java:180) at org.wildfly.clustering.context@5.0.10.Final-redhat-00001//org.wildfly.clustering.context.ContextualExecutor.execute(ContextualExecutor.java:31) at org.wildfly.clustering.context@5.0.10.Final-redhat-00001//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 org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.indexExists(AbstractTableManager.java:298) at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.createIndex(AbstractTableManager.java:276) at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.start(AbstractTableManager.java:144) at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.createTableOperations(JdbcStringBasedStore.java:124) at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.createTableOperations(JdbcStringBasedStore.java:84) at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//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 org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.indexExists(AbstractTableManager.java:290) ... 14 more

      When using the recommended JDBC Driver for MSSQL (https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver17) with EAP 8.1, we get the following error when deploying a distributed application (complete log in server.log, server config in standalone-ha.xml):

      2025-09-19 14:02:06,886 ERROR [org.infinispan.CONFIG] (ServerService Thread Pool -- 18) ISPN000660: Cache cbnc.ear.b.war start failed, stopping any running components: 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
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.impl.BasicComponentRegistryImpl.startWrapper(BasicComponentRegistryImpl.java:584)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.impl.BasicComponentRegistryImpl$ComponentWrapper.running(BasicComponentRegistryImpl.java:807)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.ComponentRegistry.getLocalComponent(ComponentRegistry.java:187)
	at org.infinispan.core@15.0.16.Final-redhat-00001//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 org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.ComponentRegistry.notifyCacheStarting(ComponentRegistry.java:270)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.ComponentRegistry.preStart(ComponentRegistry.java:257)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:244)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:222)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.cache.impl.CacheImpl.start(CacheImpl.java:1037)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.cache.impl.AbstractDelegatingCache.start(AbstractDelegatingCache.java:515)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.manager.DefaultCacheManager.wireAndStartCache(DefaultCacheManager.java:736)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:682)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.manager.DefaultCacheManager.internalGetCache(DefaultCacheManager.java:575)
	at org.infinispan.core@15.0.16.Final-redhat-00001//org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:590)
	at org.jboss.as.clustering.infinispan@8.1.0.GA-redhat-00015//org.jboss.as.clustering.infinispan.manager.DefaultCacheContainer$1.run(DefaultCacheContainer.java:109)
	at org.jboss.as.clustering.infinispan@8.1.0.GA-redhat-00015//org.jboss.as.clustering.infinispan.manager.DefaultCacheContainer$1.run(DefaultCacheContainer.java:106)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:318)
	at org.jboss.as.clustering.infinispan@8.1.0.GA-redhat-00015//org.jboss.as.clustering.infinispan.manager.DefaultCacheContainer.getCache(DefaultCacheContainer.java:106)
	at org.jboss.as.clustering.infinispan@8.1.0.GA-redhat-00015//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 org.wildfly.service@27.1.0.Final-redhat-00010//org.wildfly.service.Installer$UnaryService.start(Installer.java:443)
	at org.wildfly.service@27.1.0.Final-redhat-00010//org.wildfly.service.AsyncServiceBuilder$AsyncService.lambda$start$0(AsyncServiceBuilder.java:87)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
	at java.base/java.lang.Thread.run(Thread.java:842)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.JBossThread.run(JBossThread.java:513)
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 org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
	at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1348)
	at org.wildfly.clustering.context@5.0.10.Final-redhat-00001//org.wildfly.clustering.context.ContextualExecutor$1.execute(ContextualExecutor.java:180)
	at org.wildfly.clustering.context@5.0.10.Final-redhat-00001//org.wildfly.clustering.context.ContextualExecutor.execute(ContextualExecutor.java:31)
	at org.wildfly.clustering.context@5.0.10.Final-redhat-00001//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 org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.indexExists(AbstractTableManager.java:298)
	at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.createIndex(AbstractTableManager.java:276)
	at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.start(AbstractTableManager.java:144)
	at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.createTableOperations(JdbcStringBasedStore.java:124)
	at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.createTableOperations(JdbcStringBasedStore.java:84)
	at org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//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 org.infinispan.persistence.jdbc@15.0.16.Final-redhat-00001//org.infinispan.persistence.jdbc.impl.table.AbstractTableManager.indexExists(AbstractTableManager.java:290)
	... 14 more

      NOTE everything works fine when using an older JDBC Driver like mssql-jdbc-12.10.1.jre11.jar

        1. server.log
          98 kB
        2. standalone-ha.xml
          35 kB
        3. cbnc.ear
          63 kB
        4. mssql-jdbc-13.2.0.jre11.jar
          1.46 MB

              Unassigned Unassigned
              tborgato@redhat.com Tommaso Borgato
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: