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
>
>
