<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
sql-listener causing extremely frequent queries on database (once every 50millisec)
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/vishal_changrani">Vishal Changrani</a> in <i>JBoss ESB Development</i> - <a href="https://community.jboss.org/message/726482#726482">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi,</p><p>Following is my jboss-esb.xml (ESB version 4.9) For some unknown reason the sql-listener (TxHelloSQLChannel) causes extremely frequent SQL queries being sent to the database server. Upon some investigation through the source code I realize that a "MessageAwareListener" class is created for this listener (maybe since I have not set is-gateway to true). This MessageAwareListener class has a run() method which runs once every 50 milliseconds as hardcoded in the _pauseLapseInMillis variable. It doesnt honor the schedule-frequency that I specify in the xml. Also another strange thing I observe is the my SqlGatewayListener class is not initalized for this listener (is that becuase this is not a gateway sql-listener). For the other listner 'helloSQLChannel' it is instatiated and it honors the schedule frequency. </p><p>Finally I got the ESB source code but I cannot get the package xbeanmodel.impl. Are these suppose to be downloaded from somewhere else? (they are coming from the jar jbossesb-config-model-1.0.1.jar).</p><p>Thanks in advance for all your help/comments.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><?xml version="1.0"?></p><p><jbossesb parameterReloadSecs="5"</p><p> xmlns="<a class="jive-link-external-small" href="http://anonsvn.labs.jboss.com/labs/jbossesb/trunk/product/etc/schemas/xml/jbossesb-1.0.1.xsd" target="_blank">http://anonsvn.labs.jboss.com/labs/jbossesb/trunk/product/etc/schemas/xml/jbossesb-1.0.1.xsd</a>"</p><p> xmlns:xsi="<a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a>" xsi:schemaLocation="<a class="jive-link-external-small" href="http://anonsvn.labs.jboss.com/labs/jbossesb/trunk/product/etc/schemas/xml/jbossesb-1.0.1.xsd" target="_blank">http://anonsvn.labs.jboss.com/labs/jbossesb/trunk/product/etc/schemas/xml/jbossesb-1.0.1.xsd</a> <a class="jive-link-external-small" href="http://anonsvn.jboss.org/repos/labs/labs/jbossesb/trunk/product/etc/schemas/xml/jbossesb-1.0.1.xsd" target="_blank">http://anonsvn.jboss.org/repos/labs/labs/jbossesb/trunk/product/etc/schemas/xml/jbossesb-1.0.1.xsd</a>"></p><p> <providers></p><p>  <jms-provider connection-factory="ConnectionFactory" name="JBossMQ"></p><p>   <jms-bus busid="ftpGwChannel"></p><p>    <jms-message-filter dest-name="queue/ftptstv_gw" dest-type="QUEUE"/></p><p>   </jms-bus></p><p>   <jms-bus busid="ftpEsbChannel"></p><p>    <jms-message-filter dest-name="queue/ftptstv_esb" dest-type="QUEUE"/></p><p>   </jms-bus></p><p>   <jms-bus busid="quickstartEsbChannel"></p><p>    <jms-message-filter</p><p>     dest-name="queue/quickstart_sql_action_Request_esb"</p><p>     dest-type="QUEUE" selector="source='fromHelloworldSQLAction'"/></p><p>   </jms-bus></p><p>  </jms-provider></p><p>  <fs-provider name="FSprovider"></p><p>   <fs-bus busid="FtpChannel"></p><p>    <fs-message-filter directory="${esb.ftpwatchdir}"</p><p>     error-delete="false" error-directory="${esb.error}"</p><p>     error-suffix=".IN_ERROR" input-suffix=".dat" post-delete="true"</p><p>     post-directory="${esb.sent}" post-suffix=".sentToEsb" work-suffix=".esbWorking"/></p><p>   </fs-bus></p><p>  </fs-provider></p><p>  <sql-provider datasource="java:/myDB" name="GatewaySQLprovider" url="${esb.oracleurl}"></p><p>   <sql-bus busid="helloSQLChannel"></p><p>    <sql-message-filter insert-timestamp-column="TIMESTAMP_COL"</p><p>     message-column="DATA_COLUMN" message-id-column="UNIQUE_ID"</p><p>     order-by="DATA_COLUMN" post-delete="false"</p><p>     status-column="STATUS_COL" tablename="export_gateway" where-condition="DATA_COLUMN like 'data%'"/></p><p>   </sql-bus></p><p>  </sql-provider></p><p>  <sql-provider datasource="java:/myDB" name="SQLprovider" url="${esb.oracleurl}"></p><p>   <sql-bus busid="TxHelloSQLChannel"></p><p>    <sql-message-filter insert-timestamp-column="TIMESTAMP_COL"</p><p>     message-column="DATA_COLUMN" message-id-column="MESSAGE_ID"</p><p>     status-column="STATUS_COL" tablename="TX_ESB_MESSAGES"/></p><p>   </sql-bus></p><p>  </sql-provider></p><p> </providers></p><p> <services></p><p>  <service category="FtpServiceESB" description="Ftp service" name="FtpListener"></p><p>   <listeners></p><p>    <jms-listener busidref="ftpGwChannel" is-gateway="true" name="JMS-Gateway"/></p><p>    <jms-listener busidref="ftpEsbChannel" name="quickstart"/></p><p>    <fs-listener busidref="FtpChannel" is-gateway="true"</p><p>     name="FtpGateway" poll-frequency-seconds="10"></p><p>     <property name="mimeType" value="text/plain"/></p><p>     <property name="encoding" value="UTF-8"/></p><p>    </fs-listener></p><p>   </listeners></p><p>   <actions mep="OneWay"></p><p>    <action class="org.jboss.soa.esb.actions.SystemPrintln" name="actionq2"></p><p>     <property name="message"/></p><p>    </action></p><p>    <action class="org.jboss.soa.esb.smooks.SmooksAction" name="simple-transform"></p><p>     <property name="smooksConfig" value="/smooks-res.xml"/></p><p>    </action></p><p>    <action class="org.jboss.soa.esb.actions.Notifier" name="notificationAction1"></p><p>     <property name="okMethod" value="notifyOK"/></p><p>     <property name="notification-details"></p><p>      <NotificationList type="ok"></p><p>       <target class="NotifyConsole"/></p><p>      </NotificationList></p><p>      <NotificationList type="OK" xmlns="<a class="jive-link-external-small" href="http://anonsvn.labs.jboss.com/labs/jbossesb/trunk/product/etc/schemas/xml/jbossesb-1.0.1.xsd" target="_blank">http://anonsvn.labs.jboss.com/labs/jbossesb/trunk/product/etc/schemas/xml/jbossesb-1.0.1.xsd</a>"></p><p>       <target class="NotifyFTP"></p><p>        <ftp</p><p>         URL="<a class="jive-link-external-small" href="ftp://$/" target="_blank">ftp://$</a>{esb.ftpuser}:${esb.ftpuserpw}@${esb.ftpserver}/" filename="${esb.ftpfilename}"/></p><p>       </target></p><p>      </NotificationList></p><p>     </property></p><p>    </action></p><p>   </actions></p><p>  </service></p><p>  <service category="SQLServiceESB"</p><p>   description=" TX SQL Action (esb jdbc listener)" name="myTxListener"></p><p>   <listeners></p><p>       <sql-listener busidref="helloSQLChannel" is-gateway="true"</p><p>     name="SqlGateway" schedule-frequency="${esb.demandInterval}"/></p><p>    <sql-listener busidref="TxHelloSQLChannel" name="TxSqlListener" schedule-frequency="${esb.demandInterval}"></p><p>     <property name="transacted" value="false"/></p><p>    </sql-listener></p><p>   </listeners></p><p>   <actions mep="OneWay"></p><p>    <action class="com.tandbergtv.tstv.rcs.esb.MyAction" name="action1" process="displayMessage1"/></p><p>   </actions></p><p>  </service></p><p> </services></p><p></jbossesb></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>PS: the esb.demandInterval and other values are coming from the properties-service.xml. Am sure via debugging that the values are picked up correctly and even if they are not the default is 10seconds but the query is happening way more frequently than 10 seconds</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Some more info...</p><p>If I use only one listener by deleting TxSqlListener and making the one above it SqlGateway as a non gateway listener I see the same issue for querying the database too frequently but for the export_gateway table. I therefore feel this is a bug in esb 4.9 since a non-gateway sql listener actually instantiates a SqlTableCourer which has no notion of schedule-frequency and goes around qurying the database once every 50 milliseconds.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/726482#726482">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in JBoss ESB Development at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2032">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>