Skip to Content
0

JDBC to Mail Scenario

Dec 11, 2016 at 02:50 AM

54

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Apu Das Dec 12, 2016 at 11:21 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Evgeniy Kolmakov Dec 11, 2016 at 04:58 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded