Also, I wouldn't use the DataSource directly - use a connection pool like BoneCPDataSource that uses the MySQL driver internally:
http://jolbox.com/ I've been using it for a while with good results. HTH, Les On Mon, Jun 27, 2011 at 4:17 AM, Jared Bunting <[email protected]> wrote: > Well, on first glance your password field is different in your tables and > your query. That being said, it would probably be a bit easier to assist if > you pasted the full stacktrace. > > ipas <[email protected]> wrote: > > > Hi, the problem above is resolved by changing following lines in web.xml : > > ds = com.mysql.jdbc.Driver > to > ds = com.mysql.jdbc.jdbc2.optional.MysqlDataSource > > and i forget changing line coreFreightRealm.dataSource = $ds to > jdbcRealm.dataSource = $ds > > > Now my application is working but giving me *"here was a SQL error while > authenticating user [admin]* ", But i can not understand exactly in which > SQL query i have an error. > > my tables are : > users(user_name varchar,user_pass varchar, status int), > user_roles (user_name varchar,role_name varchar), > roles_permissions(role_name varchar, permission varchar) > > Am i missing something? > > Thanking you, > Mirlan > > > > -- > View this message in context: > http://shiro-user.582556.n2.nabble.com/Shiro-Jdbc-Realm-Mysql-tp6519616p6519975.html > Sent from the Shiro User mailing list archive at Nabble.com.
