Form Based authentication problem

[Miguel Angel Medina Lopez]

Hi all:

I'm working with Tomcat 3.2.3 and postgres 7.0. I want to use form-based
authentication and i have included the next lines in the server.xml file:
        <RequestInterceptor
            className="org.apache.tomcat.request.JDBCRealm"
            debug="0"
            driverName="org.postgresql.Driver"
            connectionURL="jdbc:postgresql://192.168.0.17/tomcat_users"
            connectionName="tomcat"
            connectionPassword="tomcat"
            userTable="usuarios"
            userNameCol="login"
            userCredCol="password"
            userRoleTable="usuarios"
            roleNameCol="role" />

The connection to the db is opened succesfully but when I put a valid
username and password the query doesn't work. The error in the tomcat.log
file is:
    JDBCRealm: The database connection is null or was found to be closed.
Trying to re-open it.

and the user isn't authenticated.

Thank you all

-------------------------------------------------------------
Miguel �ngel Medina L�pez
Logic Factory: www.logic-factory.com
Granada - Espa�a