Shiro environment initialization failed: org.apache.shiro.config.ConfigurationException

Question

We are running an existing application using wildfly-10.0.0.Final with Shiro 1.2.2 We have upgraded our application from using mysql 5.6 to 8.0.40 and we are now using the latest mysql drivers. The other parts of the application are working with the new mysql besides this section that uses apache.shiro.

see https://mvnrepository.com/artifact/com.mysql/mysql-connector-j/9.1.0

From our pom.xml
<!-- https://mvnrepository.com/artifact/com.mysql/mysql-connector-j -->
<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <version>9.1.0</version>
</dependency>

From our keep.shiro.ini

[main]  
authc.loginUrl = /index.xhtml
authc.successUrl  = /hello
logout.redirectUrl = /hello

# ------------------------  
# Database  

# Own Realm  
#jdbcRealm = com.jjoe64.shiroexample.auth.MyCustomRealm
#jdbcRealm = org.apache.shiro.realm.jdbc.JdbcRealm
jdbcRealm = com.ecomm.messages.security.JdbcReferenceRealm

# Sha256  
sha256Matcher = 
 org.apache.shiro.authc.credential.Sha256CredentialsMatcher
# base64 encoding, not hex in this example:  
sha256Matcher.storedCredentialsHexEncoded = false  
sha256Matcher.hashIterations = 1024  
  # User Query  
 jdbcRealm.authenticationQuery = select pr.password from 
 principals 
 pr,clientdetails cd where pr.clientid = cd.clientid and username 
 = ? and cd.clientref     
 = ? and pr.active = 1

# permissions  
#jdbcRealm.permissionsLookupEnabled = true
#jdbcRealm.userRolesQuery = select roleName from UserRole where 
  userName = ?
  jdbcRealm.userRolesQuery = select rl.roles, rl.rolegroups from 
 roles rl,     
 principals pr, clientdetails cd where pr.clientid = cd.clientid 
 and 
 rl.userid=pr.userid and pr.username = ? and cd.clientref = ?

# Connection   
ds = com.mysql.cj.jdbc.MysqlDataSource
ds.driverClass=com.mysql.cj.jdbc.Driver
ds.serverName = localhost
ds.user = 
ds.password = 
ds.databaseName = dbname
jdbcRealm.dataSource=$ds

# Use Built-in Chache Manager
builtInCacheManager = 
org.apache.shiro.cache.MemoryConstrainedCacheManager
securityManager.cacheManager = $builtInCacheManager

securityManager.realms = $jdbcRealm

# -----------------------------------------------------------------------------  
[urls]  
#/hello = authc
/index.xhtml = authc
/app/** = authc
/admin.jsp = authc, perms["admin:access"]

In Wildfly we updated ./jboss-cli.sh --connect [standalone@localhost:9990 /]

[standalone@localhost:9990 /] /subsystem=datasources/jdbc-driver=com.mysql:add(driver-name=com.mysql,driver-module-name=com.mysql,driver-xa-datasource-class-name=com.mysql.cj.jdbc.MysqlXADataSource {"outcome" => "success"}

We checked our application and all the references for object ds have been changed from com.mysql.jdbc.jdbc2.optional to com.mysql.cj.jdbc.MysqlDataSource based on the changes mentioned here https://dev.mysql.com/doc/connector-j/en/connector-j-api-changes.html

We are still getting the errors: 2025-01-14 09:07:27,509 ERROR [org.apache.shiro.web.env.EnvironmentLoader] (ServerService Thread Pool -- 197) Shiro environment initialization failed: org.apache.shiro.config.ConfigurationException: Unable to instantiate class [com.mysql.jdbc.jdbc2.optional.MysqlDataSource] for object named 'ds'. Please ensure you've specified the fully qualified class name correctly. 2025-01-14 09:07:27,510 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 197) MSC000001: Failed to start service jboss.undertow.deployment.default-server.default-host./message: org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./message: java.lang.RuntimeException: org.apache.shiro.config.ConfigurationException: Unable to instantiate class [com.mysql.jdbc.jdbc2.optional.MysqlDataSource] for object named 'ds'. Please ensure you've specified the fully qualified class name correctly. 2025-01-14 09:07:27,522 ERROR [org.jboss.as.controller.management-operation] (DeploymentScanner-threads - 2) WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" => "messageapp.ear")]) - failure description: {"WFLYCTL0080: Failed services" => {"jboss.undertow.deployment.default-server.default-host./message" => "org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./messsage: java.lang.RuntimeException: org.apache.shiro.config.ConfigurationException: Unable to instantiate class [com.mysql.jdbc.jdbc2.optional.MysqlDataSource] for object named 'ds'. Please ensure you've specified the fully qualified class name correctly.

Any suggestions where we can look to find out where apache.shiro could be setting the object ds to com.mysql.jdbc.jdbc2.optional.MysqlDataSource so we can change it to com.mysql.cj.jdbc.MysqlDataSource and fix this part of the application.

Thanks for any help.