Hi, Thank you for your replies. The thing is my server is not showing any Stack trace but only following exception .
There was a SQL error while authenticating user [admin] I am using Eclipse Helios with tomcat7 is there anyway to see detailed stack trace? About using data source could you show me some example of using it with shiro? I searched it but no luck. Thanking you, Mirlan On Tue, Jun 28, 2011 at 9:39 AM, Les Hazlewood <[email protected]>wrote: > 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. >
