[jboss-dev-forums] [Design of JBoss ESB] - SQL Listener configuration problem ..URGENT PLEASE

[srikanth_vals]

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

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4064012#4064012

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4064012