This might be (I had a probleme that look the same with Mysql) so this might be that it need to be autoReconnect=true:
connectionURL="jdbc:postgresql://192.168.0.17/tomcat_users" became : connectionURL="jdbc:postgresql://192.168.0.17/tomcat_users?autoReconnect=true" Try and give me your feed back, please. At 09:32 27/09/2001 +0200, you wrote: >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