Hi,
Here are my DataSpurce configurations . And i think there is no problem in
connection.
jdbcRealm = org.apache.shiro.realm.jdbc.JdbcRealm
jdbcRealm.permissionsLookupEnabled = true
jdbcRealm.authenticationQuery = "SELECT user_pass FROM users
WHERE user_name = ?"
jdbcRealm.userRolesQuery = "SELECT role_name FROM user_roles
WHERE user_name = ?"
jdbcRealm.permissionsQuery = "SELECT permission FROM
roles_permissions WHERE role_name = ?"
ds = org.apache.commons.dbcp.BasicDataSource
ds.driverClassName = com.mysql.jdbc.Driver
ds.username = user
ds.password = pass
ds.url = jdbc:mysql://localhost:3306/iaau
ds.maxActive = 10
jdbcRealm.dataSource = $ds
But still it is giving me exception There was a SQL error while
authenticating user [admin] .
How to see if the sql query is correct?
Thank you.
--
View this message in context:
http://shiro-user.582556.n2.nabble.com/Shiro-Jdbc-Realm-Mysql-tp6519616p6548700.html
Sent from the Shiro User mailing list archive at Nabble.com.
