Hi friends,
below is the configuration of my sql listener, i ran the esb in standalone mode there is no error or any ouput when the table got inserted a new record. Its urgent as i could not debug since there is no error...
<providers>
<jms-provider name="JBossMQ"
connection-factory="WSMQQueueConnectionFactory"
jndi-context-factory="org.jnp.interfaces.NamingContextFactory"
jndi-URL="localhost" >
<jms-bus busid="sqlstartEsbChannel">
<jms-message-filter
dest-type="QUEUE"
dest-name="wsmq/sqlmessage"
selector="type='fromHelloWorldJmsAction'"/>
</jms-bus>
</jms-provider>
<sql-provider name="SQLprovider"
url="jdbc:db2://ip:6789/testdb"
driver="COM.ibm.db2.jdbc.net.DB2Driver"
username="user"
password="pass">
<sql-bus busid="helloSQLChannel" >
<sql-message-filter
tablename="order_complete"
status-column="mass_update_flag"/>
</sql-bus>
</sql-provider>
</providers>
.
<services>
<service
category="SQLService"
name="SQLService"
description="Hello World SQL Action (esb jdbc listener)">
<listeners>
<sql-listener name="SqlGateway"
busidref="helloSQLChannel"
maxThreads="1"
is-gateway="true"
poll-frequency-seconds="2"/>
<jms-listener name="helloWorldJmsAction"
busidref="sqlstartEsbChannel"
maxThreads="1"/>
</listeners>
<actions>
<action name="action1"
class="com.bluebird.integration.SQLAction"
process="displayMessage" />
</actions>
</service>
</services>