It's done and it works perfectly. It seems that you can't label the columns
as I did in the query. The names of the table don't matter though.
Alas:
from: select rolename Role, 0 RoleGroup from rolemapper where username=?
to : select role, rolegroup from rolemapper where username=?
/Pelle Poluha
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> Pelle Poluha
> Sent: den 12 juni 2001 10:50
> To: [EMAIL PROTECTED]
> Subject: RE: [JBoss-user] Problems using DatabaseServerLoginModule
>
>
> 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
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
