That is correct. It expects a query that maps any existing schema onto
the idealized Principal and Roles tables as described in the JBossSX
docs and the DatabaseServerLoginModule javadoc.
See http://www.jboss.org/documentation/HTML/ch09s17.html



----- Original Message ----- 
From: "Grim Shieldsson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 12, 2001 8:39 AM
Subject: RE: [JBoss-user] Problems using DatabaseServerLoginModule


> I would try using the column names you have.  I have a sneaking
> suspicion that the databaseLoginModule is not looking at names, but
> rather position.  I could be wrong.. it's worth a shot.
> 
> --- Pelle Poluha <[EMAIL PROTECTED]> wrote:
> > I would at least have to change the column names in the table and
> > change the
> > entity bean dealing with that table.
> > 
> > Regards,
> > Pelle
> > 
> > > The roles query should be something like:
> > > select Role,RoleGroup from Roles where username=?
> > > You have:
> > > select rolename Role, 0 RoleGroup from rolemapper where username=?"
> > > The rolename Role and 0 RoleGroup are prolly causing the problem. 
> > I'm
> > > not sure why this would cause a database structure change.
> > 
> > > > Perhaps there is something wrong with the roles query as Grim
> > > > Shieldsson
> > > > suggested (but then I would have to change the structure of
> > > the table
> > > > which
> > > > I'd prefer not to).
> > > >
> > 
> > 
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > http://lists.sourceforge.net/lists/listinfo/jboss-user
> 
> 
> =====
> Grim Shieldsson (James A Barrows)
> Acting Chieftain of Clan StormWolf
> Barbarian Freehold Alliance
> Oppurtunity doesn't knock.  It only presents itself after you kick down the door.
> --Kyle Chandler
> 
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35 
> a year!  http://personal.mail.yahoo.com/
> 
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
> 


_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to