tomcat-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ignacio J. Ortega" <>
Subject RE: [PATCH] change JDBCRealm to add flexibility in table layout
Date Tue, 05 Mar 2002 08:44:47 GMT
> De: John Gregg []
> Enviado el: martes 5 de marzo de 2002 1:27

> in the layout of one's users and roles tables.  The current 
> implementation
> (1.20) assumes the roles table will have a column with the 
> same name and
> meaning as the username column in the users table.  In 
> general, I like to
> avoid using a column with domain meaning as a primary or 
> foreign key.  In

Why do not use simply a views, instead of real tables..??

This way you doesnt need to do any changes in JDBCRealm to be able to
use whatever column you like to join roles and users tables.. ( that
seems what you are looking for , arent you?)

If more is needed please explain why.. perhaps i dont understand fully
what you need ..

And sure, the view method will not work with mysql ( doesnt have views
afaik ).., but will for postgress AFAIK..

Saludos ,
Ignacio J. Ortega

To unsubscribe, e-mail:   <>
For additional commands, e-mail: <>

View raw message