11 Replies Latest reply on Aug 21, 2008 5:59 AM by Alexandros Karypidis

    Sql-provider cannot update the status field

    Rasmus Skibye Newbie

      Hello.
      I have a problem with the sql-provider in the jboss-esb.

      Created a simple table:

      CREATE table ELECTRONIC_ORDER_TEST(
      STATUS varchar2(20),
      ORDER_ID number not null,
      MESSAGE_ID varchar2(200),
      primary key (order_id));


      , added the required params to the esb-file:

      <sql-provider name="ResourceOrderSQLProvider"
      url="jdbc:oracle:thin:@211.211.11.92:1511:test13"
      driver="oracle.jdbc.OracleDriver" username="AB" password="AB1234">
      <sql-bus busid="ResourceOrderSQLChannel">
      <sql-message-filter
      tablename="ELECTRONIC_ORDER_TEST" status-column="STATUS" order-by="ORDER_ID"
      message-id-column="ORDER_ID"
      message-column="MESSAGE_ID" post-delete="false"
      error-delete="false"/>
      </sql-bus>
      </sql-provider>


      , added a row to the table:

      insert into electronic_order_test values('P',1,'test_text');


      , and got the following error:

      14:47:14,924 ERROR [SqlTableGatewayListener] Row status change to Working has failed. Rolling back!!


      I am able to change the status manually (from P to W), but the esb-service can not do this?


      Any help to this problem is very welcome :-)

      Regards

      Rasmus