Skip to Content

JDBC to Mail Scenario

Hello Expert.

I have requirement for JDBC to mail . I have one order database table . In this table a field ORDER_STATUS , In this field two flag a) Completed b) Error .

Requirement : When order_status field is Error than we will sent a mail to customer .

Please let me know how i can achieve this requirement via JDBC to FILE .

Regards

Pankaj Singh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 12, 2016 at 11:21 AM

    Hi Pankaj,

    As Evgeniy said, create one simple JDBC -> Mail interface and pool data with below query in the communication channel.

    Select * from <table name> where ORDER_STATUS = 'Error' and flag = ''

    Update one flag field to 'X' or try to put some other sql query logic so that same data will not be polled repeatidely.

    Thanks,

    Apu

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 11, 2016 at 04:58 AM

    Hi Pankaj!

    It seems to be the simple async scenario JDBC-Mail.

    Sender JDBC adapter polls the orders data via statement with condition to select records with error status. Than you use mail adapter at receiver's side and compose your mail message.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded