I have created a small web application that uses Tomcat-managed authentication via JDBCRealm. When I use the following realm descriptor, and go to the web application's site, I am prompted to log in and everything works great.
Now I am trying to use my employer's oracle database with this realm descriptor:
When I try to access the web application with the oracle back end, I am prompted to log in, but denied access. Using wireshark, I have determined that the oracle database is throwing the following exception: ORA-01403 (no data found - typically results when no rows are returned). However querying the actual tables shows that they have the same information in them as is the case for the web application with the postgresql backend. Furthermore if I remove authentication from the web.xml, I can access the oracle database just fine from the web application. In fact, the web application allows me to query and update the oracle tables (user_logins and the user_roles) without difficulty.
As it turns out, our company's intranet uses tomcat-managed authentication (different user/schema, but same domain and data instance), and this works fine.
I am baffled as to why no rows are returned when
Tomcat tries to authenticate. I have located the appropriate
JDBC drivers in $CATALINA_HOME/lib. Any suggestions as to how to troubleshoot this would be appreciated.
Deb Platt