Sir
Jdev ver 12.2.1 and glassfish 4.0
What changes are to made in this shiro.ini file, for oracle express edition, tables being remain the same?
The bellow ini file is for mysql database.
shiro.ini file:
[main]
user = com.vesterli.view.filter.FacesAjaxAwareUserFilter
shiro.loginUrl = /faces/login.jsf
user.loginUrl = /faces/login.jsf
# DataSource config
ds = org.apache.shiro.jndi.JndiObjectFactory
ds.requiredType = javax.sql.DataSource
ds.resourceName = jdbc/SakilaDS
# JDBC realm config
jdbcRealm = org.apache.shiro.realm.jdbc.JdbcRealm
jdbcRealm.permissionsLookupEnabled = true
jdbcRealm.authenticationQuery = SELECT password FROM sakila.users
WHERE user_name = ?
jdbcRealm.userRolesQuery = SELECT role FROM sakila.roles, sakila.user_
roles, sakila.users WHERE roles.id = user_roles.role_id and users.id =
user_roles.user_id and users.user_name = ?
jdbcRealm.permissionsQuery = SELECT permission FROM sakila.
permissions, sakila.role_permissions, sakila.roles WHERE permissions.
id = role_permissions.perm_id and roles.id = role_permissions.role_id
and roles.role = ?
jdbcRealm.dataSource = $ds
[urls]
/faces/** = user
Because I am getting message about class not qualified.
Regards