RE: Oracle view compatible with JDBC realm

["Sonnek, Ryan" <Ry...@bpc.com>]

thanks for the reply.  if you're using a view and it's working for you, then
during our move from tomcat 3.2.1 to 3.2.3 we may have missed something.
i'll be looking into it!

Ryan J. Sonnek
Programmer/Analyst
Brown Printing Company
507.835.0803
<ma...@bpc.com>


-----Original Message-----
From: Ignacio J. Ortega [mailto:nacho@siapi.es]
Sent: Friday, September 28, 2001 5:56 PM
To: 'tomcat-user@jakarta.apache.org'
Subject: RE: Oracle view compatible with JDBC realm


Not a problem to use a view, should work well. i've use something
similar and works nice..


Saludos ,
Ignacio J. Ortega


> -----Mensaje original-----
> De: Sonnek, Ryan [mailto:Ryan.Sonnek@bpc.com]
> Enviado el: viernes 28 de septiembre de 2001 22:40
> Para: 'tomcat-user@jakarta.apache.org'
> Asunto: Oracle view compatible with JDBC realm
> 
> 
> I'm currently developing on tomcat 3.2.3, and have had 
> success using the
> jdbc realm setup.
> our previous setup had every user using their user_number and 
> password to
> log into our system.  now, we want to use the username, so 
> we've created a
> view for tomcat to work with.  our database is setup with an 
> integer as the
> primary key, not the string 'username', so we needed to use a 
> view to allow
> tomcat to see the string instead of the integer.  since i've 
> done this, i've
> been unable to have tomcat authenticate with our db server.  
> has anyone out
> there done something similar?  I'm stuck right now to the point that i
> either force users to use their user number or to drop this tomcat
> functionality, and write my own user management system.
> 
> thanks.
> 
> Ryan J. Sonnek
> Programmer/Analyst
> Brown Printing Company
> 507.835.0803
> <ma...@bpc.com>
> 
>