FreeTDS Development Group

["Jason" <jcowley AT cenquest.com>]

I cannot seem to get JDBC realm working with the freetds driver. When I go
to a page in the protected area, I get in without being prompted for a
password but only see a blank page. I'm pretty sure my configuration is
correct, I've tested it with a mySQL database and driver.

I've been struggling with this for two days now. Does anyone have any
advice?

I'm using tomcat 4.0.3 on a Linux system (RH 7.2) and SQL Server 7.0.

I have configured my Realm in the tomcat server.xml file like this:

<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
     driverName="com.internetcds.jdbc.tds.Driver"
     connectionName="test" connectionPassword="password"
     connectionURL="jdbc:freetds:sqlserver://ONYX/Web_Onyx_test;TDS=7.0"
     userTable="Users"
     userNameCol="Login"
     userCredCol="Password"
     userRoleTable="User_Roles" 
     roleNameCol="Role" />

And my web.xml file like this:

<web-app>
    <security-constraint>
        <display-name>Test Realm</display-name>
        <web-resource-collection>
        <web-resource-name>Protected Area</web-resource-name>
             <url-pattern>/*</url-pattern>
             <http-method>DELETE</http-method>
             <http-method>GET</http-method>
             <http-method>POST</http-method>
             <http-method>PUT</http-method>
         </web-resource-collection>
         <auth-constraint>
             <role-name>testRole</role-name>
         </auth-constraint>
     </security-constraint>
     <login-config>
        <auth-method>BASIC</auth-method>
        <realm-name>Test</realm-name>
     </login-config>
</web-app>


Thanks!