I have tables users, user_roles, role created as per documentation and connect string is right too for JDBCRelam. But when I start application it keeps prompting for network id/password. The log files says:
sss(i.e. user name) authenticated.[THIS MUST BE A WRONG MESSGAE AS REALLY I AM NOT AUTHENTICATED] Table or view does not exist. other regular java dump.... below...
What does that mean? I can use connect string when I do not force JDBCRealm so that is not a problem. Some thing going wrong here. I have those there tables also needed by tomcat to look up user name/pswd/roles etc and I really connect with DBA login in connect string. I am running against Oracle(9i). Any clues?
Try to check your Realm elements in server.xml, is it correct?
Joined: Apr 24, 2003
Those are right as I tested on my stand alone PC, only thing I am doing is putting JDBCRealm clause on my UNIX server copied from my PC - like I said connect string is right too. There is some thing missing I can not fgure out ..