In your login-config.xml what is your roles query.
In my login-config.xml:
<application-policy name = "testDB">
<login-module code = "org.jboss.security.auth.spi.DatabaseServerLoginModule"
flag = "required">
<module-option name="principalsQuery">select passwd from Users where username=?</module-option>
<module-option name="rolesQuery">select userRoles, userGroup from UserRoles where username=?</module-option>
I have take a look to DatabaseServerLoginModule source code, but it seems ok.
Please help me!
My LoginSession continues to ask me users.properties file, but I'm tryng to use appointmentsApp app policy?
Can you sen me you xml files.
I really don't know how to do.
Kiuma, you have to configure your security-domain in jboss.xml
if you want that the security manager loads the DatabaseServerLoginModule
Dear Raffaella I've seen that I forgot tag now I try again.
For you problem I don't know Oracle but I use PostgrSQL,
Postgresql wouldn't work because it distinguish between LowerCase and UpperCase in fields name.
I don't know the case of orcle but in my short experience I use all lowercases separated with underscores.
I also have to ask you a big pleasure I'm trying to build that damned application that make me login and a cmp level base. To help me and other people for basic problems.
If I don't get out could you correct my 'very small' app?
I hope that what I said can help you anyway.