Hi: Thanks Kaneda but the parameter autoReconnect doesn't work in Postgres. I have found the error in the server.xml file and now I can't authenticate fine. Now the problem is that I need the user name in differents context. How can I do that? How can I keep client state in different contexts?
Miguel Ángel Medina López ----- Original Message ----- From: "Kaneda K" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 27, 2001 10:01 AM Subject: Re: Form Based authentication problem > 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=tru e" > > 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