tomcat-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Gregg" <john.gr...@techarch.com>
Subject RE: [PATCH] change JDBCRealm to add flexibility in table layout
Date Wed, 06 Mar 2002 14:25:46 GMT
I assumed increased flexibility + backwards compatibility would be welcome.
After all, Tomcat has to serve the needs of many different users.  Some of
those users, including me, are working for clients who aren't willing to
spend the money on things like WebLogic or Oracle.  Instead, we use Tomcat,
which works great, and databases like PostgreSQL and MySQL.  As you've shown
with the views, as a PostgreSQL user, I don't absolutely NEED the patch I've
provided, but I consider it an improvement nonetheless because I value
flexible designs.  I would expect the MySQL users to appreciate a solution
that works for everyone, not just everyone else.

After this patch, I was considering cleaning up some of the exception
handling issues in JDBCRealm, but from now on I'll confine myself to
ordinary bug fixes and not design "improvements."

john


-----Original Message-----
From: tomcat-dev-return-6703-john.gregg=techarch.com@jakarta.apache.org
[mailto:tomcat-dev-return-6703-john.gregg=techarch.com@jakarta.apache.or
g]On Behalf Of Ignacio J. Ortega
Sent: Tuesday, March 05, 2002 1:43 PM
To: 'Tomcat Developers List'; 'john.gregg@techarch.com'
Subject: RE: [PATCH] change JDBCRealm to add flexibility in table layout


( Syntax aproximated maybe sql-92, more or less )

create table users
(
  user_id   integer not null primary key,
  user_name varchar(15) not null ,
  user_pass varchar(15) not null
);


create table user_roles
(
  role_id   integer not null primary key,
  user_id   integer not null,
  role_name varchar(15) not null
);


create view user_roles_jdbcrealm
as
select u.user_name,ur.role_name
from user_roles ur join users u
on (ur.user_id=u.user_id)


and use this view in jdbcrealm..

Please add what you need to be able to understand you..

Saludos ,
Ignacio J. Ortega


--
To unsubscribe, e-mail:   <mailto:tomcat-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-dev-help@jakarta.apache.org>


Mime
View raw message