Hi,
I am using DataSourceRealm to authenticate user in my application on Tomcat
5.5.28. When I left server idle overnight and tried to login into the
application the next day, DataSourceRealm would fail in retrieving password.
The following error message was shown in the console:
SEVERE: Exception retrieving password for "test1"
9-Oct-2009 9:22:22 AM org.apache.catalina.realm.DataSourceRealm close
SEVERE: Exception closing database connection
java.sql.SQLException: Already closed.
at
org.apache.tomcat.dbcp.dbcp.PoolableConnection.close(PoolableConnection.java:84)
at
org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181)
at
org.apache.catalina.realm.DataSourceRealm.close(DataSourceRealm.java:379)
at
org.apache.catalina.realm.DataSourceRealm.authenticate(DataSourceRealm.java:301)
at
org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:258)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:417)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
Do anyone know how to resolve this issue? Any help appreciated. Thanks
Below is my context configuration in server.xml:
<Context docBase="Reprosource" path="/Reprosource" reloadable="true"
source="org.eclipse.jst.j2ee.server:Reprosource">
<Resource name="jdbc/rpsDB"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
username="user1"
password="web01"
driverClassName="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://localhost:3306/rpsmaster"/>
<Realm className="org.apache.catalina.realm.DataSourceRealm"
dataSourceName="jdbc/rpsDB"
userTable="users"
userNameCol="user_name"
userCredCol="user_pass"
userRoleTable="user_roles"
roleNameCol="role_name"
digest="MD5"
localDataSource="true"/>
</Context>
-- Run
--
View this message in context:
http://www.nabble.com/DataSourceRealm-failed-to-retrieve-password-after-tomcat-server-being-idle-overnight-tp25822607p25822607.html
Sent from the Tomcat - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
