2 Replies Latest reply on Jul 27, 2007 1:22 PM by Barry Sheward

    SQL Listener configuration problem ..URGENT PLEASE

    Srikanth Val Newbie

      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>