<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div style="margin: 0px; font-size: 11px; font-family: Menlo;">You have 41 prepared statment access to the cache. This not mean that you have 41 different statements.</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">This means that you have actually only 6 different. Those 6 were added initially to the cache and</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">the other 35 access found them on the cache, so you have 35 hits.</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; color: rgb(94, 52, 255);"> </div><div style=""><div>On Aug 27, 2014, at 7:58 AM, Eduardo Sant'Ana da Silva <<a href="mailto:eduardo.santanadasilva@gmail.com">eduardo.santanadasilva@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><meta http-equiv="Content-Type" content="text/html charset=us-ascii"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><div style="margin: 0px;">/**</div><div style="margin: 0px;"> * JBQA-6456 Test jdbc statistics of data sources</div><div style="margin: 0px;"> *</div><div style="margin: 0px;"> * @author <a href="<a href="mailto:vrastsel@redhat.com">vrastsel@redhat.com</a>">Vladimir Rastseluev</a></div><div style="margin: 0px;"> */</div><div style="margin: 0px; min-height: 13px;"><br></div><div style="margin: 0px;">@RunWith(Arquillian.class)</div><div style="margin: 0px;">@ServerSetup(DataSourceJdbcStatisticsTestCase.TestCaseSetup.class)</div><div style="margin: 0px;">public class DataSourceJdbcStatisticsTestCase {</div><div><br></div><div>...</div></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> public StringBuffer assertStatisticsSet(boolean yes, ModelNode statisticNode) throws Exception {</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> StringBuffer sb = new StringBuffer();</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> String[] params = { "PreparedStatementCacheAccessCount", // The number of times that the statement cache was</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> // accessed</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> "PreparedStatementCacheAddCount", // The number of statements added to the statement cache</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> "PreparedStatementCacheCurrentSize", // The number of prepared and callable statements currently cached in</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> // the statement cache</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> "PreparedStatementCacheDeleteCount", // The number of statements discarded from the cache</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> "PreparedStatementCacheHitCount" // The number of times that statements from the cache were used</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> };</div><div><br></div><div><br></div><div><div>On Aug 27, 2014, at 6:10 AM, Heiko Braun <<a href="mailto:hbraun@redhat.com">hbraun@redhat.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span style="color: rgb(149, 165, 167); font-family: 'Source Code Pro'; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(0, 57, 70); display: inline !important; float: none;">PreparedStatementCacheAccessCount</span></blockquote></div><br></div></blockquote></div><br></body></html>