File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Tomcat and the fly likes Problem with authentication using JDBC Realm... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Problem with authentication using JDBC Realm..." Watch "Problem with authentication using JDBC Realm..." New topic

Problem with authentication using JDBC Realm...

toukhir mujawar
Ranch Hand

Joined: Oct 11, 2006
Posts: 70

i have developed a web application...

the authenication is done through the tomcat Server using the JDBC based Realm...

IT is working very well on local server....

the problem is that, it is not working on the web server...

i have created the users table and user roles table and also added the user into it..

i think the problem might be because of the Oracle configuration...

there is something that is preventing me from logging into my application....

it cant find the user name and password...

there is no error message in the Log of tomcat server...

please help me what should i do?

Toukhir Mujawar
Jan Cumps

Joined: Dec 20, 2006
Posts: 2565


If it doesn't work, but there is no error in the log, it looks like the tomcat configuration on your web server is using the default realm.
Problems connecting to the oracle realm database would show up in tomcat's logs.

Can you verify in the startup log of tomcat if the correct realm is started?

Did you define the jdbc realm on the correct level (if it's defined in one application's context level, it is not available for other applications)?

Regards, Jan

OCUP UML fundamental and ITIL foundation
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33132

Welcome to JavaRanch!

I'm going to move this to our Tomcat forum for you so you can get more help.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
toukhir mujawar
Ranch Hand

Joined: Oct 11, 2006
Posts: 70

i have got one problem...

the error message is it cant find the sid name...

the cause is ...

the database name and SID are different....

what should i do?
I agree. Here's the link:
subject: Problem with authentication using JDBC Realm...
It's not a secret anymore!