tag:blogger.com,1999:blog-3027735045190050818.post2011824079720135266..comments2018-02-28T12:59:12.267-08:00Comments on Tuning J2EE Application Performance: Understanding performance impact of shareable JDBC connections in struts based web application deployed on Websphere Application ServerSamarth Bhargavahttp://www.blogger.com/profile/08841650694688026570noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-3027735045190050818.post-62655419761653280792011-10-27T07:38:44.378-07:002011-10-27T07:38:44.378-07:00Thanks for pointing out the typos. Fixed them.Thanks for pointing out the typos. Fixed them.Samarth Bhargavahttps://www.blogger.com/profile/08841650694688026570noreply@blogger.comtag:blogger.com,1999:blog-3027735045190050818.post-43002313803657402312011-10-26T01:37:27.035-07:002011-10-26T01:37:27.035-07:00Very good article, helped me in a lot of ways.
Ju...Very good article, helped me in a lot of ways.<br /><br />Just a quick remark: i think u used shareable a couple of times where u actually meant unshareable and vice versa<br /><br />eg: <br />- However, if the connections are <b>unshareable</b> then the connection, even if closed will not be returned to the pool until the LTC of SearchAction is completed.<br /><br />- If you are facing any of the above mentioned issues, then it is highly recommended that you switch to the <b>shareable</b> connections by configuring the same in web.xml as shown below.De Mattehttps://www.blogger.com/profile/08104413055745605846noreply@blogger.comtag:blogger.com,1999:blog-3027735045190050818.post-53114788978166537232008-09-28T00:18:00.000-07:002008-09-28T00:18:00.000-07:00In "However, if the connections are unshareable th...In "However, if the connections are unshareable then the connection, even if closed will not be returned to the pool until the LTC of SearchAction is completed." sentence should be shareable instead of unshareablemilushttps://www.blogger.com/profile/04255791953013506623noreply@blogger.comtag:blogger.com,1999:blog-3027735045190050818.post-91795521275771936922007-06-26T00:12:00.000-07:002007-06-26T00:12:00.000-07:00Hi,Thanks for your insightful inputs.Is this "Shar...Hi,<BR/><BR/>Thanks for your insightful inputs.<BR/><BR/>Is this "Shareable" connection unique to Websphere? Because my application (which is based on STRUTS f/w) are pre-configured with Shareable connections and it seems to work fine in other container such as JBOSS.<BR/><BR/>Thanks!<BR/><BR/>/CS急惊风与慢郎中https://www.blogger.com/profile/09532799879271857148noreply@blogger.comtag:blogger.com,1999:blog-3027735045190050818.post-85185325507771215072007-06-25T07:32:00.000-07:002007-06-25T07:32:00.000-07:00Hi CS,Making the connections unshareable will not ...Hi CS,<BR/>Making the connections unshareable will <I>not have</I> any impact on the application logic. <BR/>Instead of being kept in the LTC for reuse, the connection will now be returned to the pool as soon as the work is complete.<BR/><BR/>Whether shareable connections impact performance is a function of the number of servlets (servlet threads) being used to process a request. <BR/>If there is no kind of servlet chaining or action chaining then shareable connections are recommended.<BR/>However, if multiple servlets/actions are chained to process a single request, then you should use unshareable conenctions.<BR/><BR/>Whether you use spring f/w or not should not dictate the usage of shareable/unshareable connections.<BR/><BR/>However, I would like to say that if you are using Struts F/W, then most probably you might be forwarding from one action to another. In that case, you must use unshareable connections.<BR/><BR/>Regards,<BR/>SamarthSamarth Bhargavahttps://www.blogger.com/profile/08841650694688026570noreply@blogger.comtag:blogger.com,1999:blog-3027735045190050818.post-47949016835344541912007-06-25T06:43:00.000-07:002007-06-25T06:43:00.000-07:00I've found "Nested Local Transactions" (refer to t...I've found "Nested Local Transactions" (refer to technote: http://www-1.ibm.com/support/docview.wss?rs=180&context=SSEQTP&q1=J2CA0045E&uid=swg21217062&loc=en_US&cs=utf-8&lang=en).<BR/><BR/>And as recommended by the technote, the situation can be solved by having "Unshared connections".<BR/><BR/>However, could you enlighten whether the change to "Unshared" connections would impact the application logic in anyway?<BR/><BR/>Is it common for applications based on SPRING framework to require "Unshared" connections in Websphere?<BR/><BR/>Thanks!<BR/><BR/>/CS急惊风与慢郎中https://www.blogger.com/profile/09532799879271857148noreply@blogger.comtag:blogger.com,1999:blog-3027735045190050818.post-12792663967428578082007-06-23T20:52:00.000-07:002007-06-23T20:52:00.000-07:00Hi CS,Can you please elaborate a bit more on the i...Hi CS,<BR/>Can you please elaborate a bit more on the issue you are trying to solve? I may be able to provide some help then.<BR/><BR/>Regards,<BR/>SamarthSamarth Bhargavahttps://www.blogger.com/profile/08841650694688026570noreply@blogger.comtag:blogger.com,1999:blog-3027735045190050818.post-76284378646317579172007-06-23T10:43:00.000-07:002007-06-23T10:43:00.000-07:00Hi,I'm trying to solve performance issue due to th...Hi,<BR/><BR/>I'm trying to solve performance issue due to the shareable connections too. It seems to work for my case. However, do you know what could be the most obvious side-effects? Will the memory usage be higher? What are some of the simple tests I could conduct?<BR/><BR/>Thanks!<BR/><BR/>/CS急惊风与慢郎中https://www.blogger.com/profile/09532799879271857148noreply@blogger.com