2 Replies Latest reply on Feb 22, 2012 3:08 AM by Ravi Evani

    unable to insert data using NotifySqlTable

    Ravi Evani Newbie



      I am trying to execute an insert query using NotifySqlTable to insert data into the table.

      My action looks like


      <actions mep="OneWay">

      <action class="org.jboss.soa.esb.actions.SystemPrintln" name="print">

        <property name="message" value="filepolled" />


      <action class="org.jboss.soa.esb.actions.Notifier" name="SqlNotify">

        <property name="okMethod" value="notifyOK" />

        <property name="exceptionMethod" value="notifyError" />

      <property name="destinations">

      <NotificationList type="NotifySql">

      <target class="NotifySqlTable" connection-url="jdbc:oracle:thin:@localhost:1521:wmdb" dataColumn="DATA_COLUMN" driver-class="oracle.jdbc.driver.OracleDriver" password="manage" table="gateway_table" user-name="hr">

        <column name="unique_id" value="122" />

        <column name="STATUS_COL" value="P" />





        <action class="org.jboss.labs.showFileContent" name="showFileContent" process="process" />



      but its neither inserting  data nor throwing any error.


      i have placed the ojdbc14.jar in deploy/lib folder.


      where am I doing wrong ?  please give your inputs..