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

    unable to insert data using NotifySqlTable

    eravisankar1984

      Hi,

       

      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>

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

        </target>

        </NotificationList>

        </property>

        </action>

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

        </actions>

       

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

       

      Thanks,

      Ravi