Configuring, debugging with JDBCRealm

I'm unable to get the Sun ONE sample JDBCRealm working. I've triple checked the configuration; created a database using the sample sql script with no luck.My web server logs say that the jdbc realm is being called, but that it failed. There's no indication of why or what's wrong.

Is there any way to get some debug information out of an authentication realm? I'd like to know what's not working, whether it's the database connection (I've also got a jdbc pool to the same db which works fine); the configuration (copied and pasted from the docs); data entry (I'm entered username and password dozens of times) or something else (what?!).

I'm using Sun ONE Web server, version 6.1 SP2. The sample application is in <SERVER ROOT>\WebServer6.1\plugins\java\samples\webapps\security\jdbcrealm

The JDBCRealm doesn't log much. Is there anyway to get more of an indication from it as to why it's not working?Has anyone successfully gotten this to work in Sun ONE? I was able to set this up in Tomcat very easily. I'm stumped. Any help would be appreciated.

[1095 byte] By [bendede2] at [2007-11-26 9:02:34]
# 1
Hi,Could you please post the exact message that you were getting in the log files? Also please give us the extract from server.xml which relates to this webapp.What database are you using?Did you install the correct drivers?Thanks
roho at 2007-7-6 23:10:23 > top of Java-index,Web & Directory Servers,Web Servers...