Hi Chris, Thanks for the quick response.
Please find the stack trace. This happens when there is more requests. I could reproduce it by loading more concurrent request All datasources called with same username/password. 4 datasources are called at a time by 4 different application. INFO: Stopping ProtocolHandler ["ajp-bio-8009"] ionFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1356) at com.avaya.sce.runtime.BasicServlet.handleRequest(BasicServlet.java:116) at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:96) at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:285) at com.avaya.sce.runtime.SCEServlet.doGet(SCEServlet.java:182) at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1356) at com.avaya.sce.runtime.Data.handleRequest(Data.java:153) at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:96) at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:285) at com.avaya.sce.runtime.SCEServlet.doGet(SCEServlet.java:182) at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) java.sql.SQLException: Given password did not match password used to create the PooledConnection. at org.apache.tomcat.dbcp.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:723) at com.avaya.aps.sca.selfservice.dm.ConnectionManager.getDataSource(ConnectionManager.java:101) at com.avaya.aps.sca.selfservice.InteractionFlowServiceDaoImpl.getTransitionMapDetail(InteractionFlowServiceDaoImpl.java:241) at com.avaya.aps.sca.selfservice.businesservice.impl.InteractionFlowServiceImpl.getTransitionMapDetail(InteractionFlowServiceImpl.java:154) at flow.GetDialogState.servletImplementation(GetDialogState.java:81) at com.avaya.sce.runtime.BasicServlet.handleRequest(BasicServlet.java:99) at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:96) at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:285) at com.avaya.sce.runtime.SCEServlet.doGet(SCEServlet.java:182) at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1356) at com.avaya.sce.runtime.BasicServlet.handleRequest(BasicServlet.java:116) at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:96) at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:285) at com.avaya.sce.runtime.SCEServlet.doGet(SCEServlet.java:182) at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1356) at com.avaya.sce.runtime.Data.handleRequest(Data.java:153) at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:96) at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:285) at com.avaya.sce.runtime.SCEServlet.doGet(SCEServlet.java:182) at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) java.sql.SQLException: Given password did not match password used to create the PooledConnection. at org.apache.tomcat.dbcp.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:723) at com.avaya.aps.sca.selfservice.dm.ConnectionManager.getDataSource(ConnectionManager.java:101) at com.avaya.aps.sca.selfservice.InteractionFlowServiceDaoImpl.getDnisContext(InteractionFlowServiceDaoImpl.java:61) at com.avaya.aps.sca.selfservice.businesservice.impl.InteractionFlowServiceImpl.getDnisContext(InteractionFlowServiceImpl.java:55) at flow.GetDnisContext.servletImplementation(GetDnisContext.java:65) at com.avaya.sce.runtime.BasicServlet.handleRequest(BasicServlet.java:99) at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:96) at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:285) at com.avaya.sce.runtime.SCEServlet.doGet(SCEServlet.java:182) at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.avaya.sce.runtime.SCEServlet.forward(SCEServlet.java:1356) at com.avaya.sce.runtime.Data.handleRequest(Data.java:153) at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:96) at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:285) at com.avaya.sce.runtime.SCEServlet.doGet(SCEServlet.java:182) at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Thanks Vinoth On Wed, Feb 11, 2015 at 3:36 AM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA256 > > Vinoth, > > On 2/10/15 11:57 AM, Vinoth Raja wrote: > > Environment used: - Tomcat 7.0.57 - Windows - Java 1.7 - MS SQL > > 2008. > > > > Issue:"Given password did not match password used to create the > > PooledConnection" > > Stack trace? > > - -chris > > > There is no change in the password from the day application went > > live.But it happens when there is more request. > > > > Background on the logic : We have five different business > > application deployed on tomcat. There is different DB instance for > > each business. 5 primary DB instances and 5 secondary DB > > instances. I have configured total 10 datasource in tomcat > > context.xml. username/password it passed in > > getConnection(username,password ) to get the connection object. I > > have posted the query in stackoverflow and the recommendation was > > to update the library.Not sure whether to update the higher version > > library. > > > > > > Datasource and Application Logic: > > > > I have configured 10 datasources like the below > > > > <Resource auth="Container" > > driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" > > factory="org.apache.tomcat.dbcp.dbcp.cpdsadapter.DriverAdapterCPDS" > > > > > name="jdbc/CDBCPDS" > > type="org.apache.tomcat.dbcp.dbcp.cpdsadapter.DriverAdapterCPDS" > > url="jdbc:sqlserver://10.200.100.8:1433;DatabaseName=SNECDB"/> > > <Resource auth="Container" > > dataSourceName="java:/comp/env/jdbc/CDBCPDS" defaultMaxActive="20" > > defaultMaxIdle="5" defaultMaxWait="10000" > > > factory="org.apache.tomcat.dbcp.dbcp.datasources.PerUserPoolDataSourceFactory" > > > > > logAbandoned="true" name="jdbc/CDB" removeAbandoned="true" > > removeAbandonedTimeout="300" testOnBorrow="true" > > testWhileIdle="true" timeBetweenEvictionRunsMillis="60000" > > type="org.apache.tomcat.dbcp.dbcp.datasources.PerUserPoolDataSource" > > > > > validationQuery="select 1"/> > > > > Here is the java application which retrieves the connection > > object. > > > > try { > > > > dataSourceName = "jdbc/".concat(GetConfigurationDetails > > .get("cmm.datasource.db2." + dnis)); userName = > > GetConfigurationDetails.get("cmm.username.db2"); password = > > GetConfigurationDetails.get("cmm.password.db2"); if > > (objLogger.isDebugEnabled()) objLogger.debug("[" + ucid + "] > > dataSourceName: " + dataSourceName); > > > > objDataSource = (DataSource) envContext.lookup(dataSourceName); try > > { connection = objDataSource.getConnection(userName, password); } > > catch (SQLException e) { objLogger.error("[" + ucid + "]" + > > "SQLException in connection manager: " + e.getMessage()); } > > > > } catch (NamingException e) { objLogger.info("[" + ucid + "]" + > > "NamingException in connection manager: " + e.getMessage()); > > e.printStackTrace(); } > > > > Background on findings: > > > > - There was patch to fix "when changes his/her password, the > > entire connection pool must be restarted for DBCP to recognize the > > new password". It is not the case with me as there is no change in > > the password. - Stack Overflow recommendation to update the > > library. Not sure whether to use the library from tomcat 7.0.59 - I > > have modified the Resource to have username/password details and > > this issue doesn't happen. <Resource name="jdbc/SHPDB" > > auth="Container" type="javax.sql.DataSource" > > driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" > > url="jdbc:sqlserver://10.200.100.8:1433;DatabaseName=SHPDB" > > username="user" password="Password" defaultMaxActive="20" > > defaultMaxIdle="5" defaultMaxWait="10000" > > > > removeAbandonedTimeout="300" testOnBorrow="false" > > removeAbandoned="true" logAbandoned="true"/> > > > > Please advice whether there is any limit on the datasources to be > > configured when we set the credentials from the application.There > > is no issue when I have the credentials as part of the Resource. > > Please advice whether the fix is already provided or it should be > > handled in different way. > > > > Thanks Vinoth > > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1 > Comment: GPGTools - http://gpgtools.org > > iQIcBAEBCAAGBQJU2l2hAAoJEBzwKT+lPKRYca0P/RuQ2HqxkoQLZ9sU7PJrqWIS > jV0WOLSpHq+IWx+HnEYWZcUaZs2nB/MfCP1L3a3vSq+uc+6zmThG/jV2yIH62VAb > uiXprzepMPIm8nB3W6md/wWRBtej/GaYTlC2oMxRODpWT9EDhberWAH4hC724zpC > NGHCtEv722l80zZj8FnWT9WKZGs0LPgvzI+Mo2bmU8Q4QEJPZ2RbuPiutWk51Nub > kKlIwn1DIQK0Bi7HsjRpgyt4LbeSgYQyaS+q3sOKGjV3ZjnQX9JaeGbNvW3RtXl+ > 09l73Qkf3uhOUP+zmGSbCBYJ2HSz3x5nKicJxWbmODuhxWk7ZUrtGkKCIxd+Wdxe > 8oM8aoN4iU7TnZNxg62GQtQs25sokTml2jFbjxiaSPP2ViiuX1F/nstGGm5KjGJm > XkhrOfwj+mEXvXNWXQCHpn8okvA8kx4lJKcyQhOTrE642AMIkLqiNn17RG078o/u > N8G/a5KCnlmZYOurqOoi/ndCEbRXR+l3nB1jeszu2kP/MGUyMSIejEyEtsBHHKvW > J3uApMK63O5dQW9F6uvvG+9RAgH3cFKBv1bXUPTjjpCnD0JFmgWsdm9rMC3Woyj0 > b4H+UhD9DHqWSHqJIfe61K3K7NhcTYepER7fKwyyW2WO42MUE1VEwPiKBqM0SK7M > Y69T4DBGcRbmrHkZcraf > =nxph > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >