> This whole thing is really a TOMCAT-USER issue, but there's lots of Tomcat > users here. > > JDBCRealm does *not* require that the username be the primary key -- you > can still use an autogenerated sequence number (or whatever) for that > purpose. You'll want to ensure that the username column is indexed, > however, for faster performance. > > If you're using a USER_ID column as the primary key for your users and > users_roles tables, the easiest thing to do is create a view...
I just received an e-mail mirroring this solution...and I was afraid of it being that, since MySQL (my current RDBMS) does not support views. The nice part is, now I understand why it should, SOON! Anyway, I can just update the non-normalized data manually and it will work. Don't get me wrong, I realize that you can work yourself into a nice configuration. I just thought it would have been more natural had the behind the scenes query been a join on the user_id rather than the username. Either way, it will definitely work out. Dan -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Daniel Allen, <[EMAIL PROTECTED]> http://www.mojavelinux.com/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - It is not enough to succeed. Others must fail. -- Gore Vidal - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
