** Message is not returned by JDBC Sender Adapter

[jegathees_waran]

Hi Friends,

We are doing JDBC to Proxy scenario using BPM. Scenario is like Purchase Order data stored in SQL Tables (dbo.POHEADER, dbo.PODETAIL). Based on PO data we create Sales Order, Delivery, Invoice in R/3 system. In JDBC Sender Adapter, we have written the query for the following parameters to take the new Purchase orders.

-

---

Query SQL Statement :

SELECT poheader.pono, poheader.podate, poheader.vendor_code, poheader.reference, podetail.material_code, podetail.order_qty FROM poheader,podetail WHERE poheader.flag = ' ' AND poheader.pono = podetail.pono order by poheader.pono, podetail.material_code

Update SQL Statement:

Update poheader set flag = 'Y' where flag = ' '

Database Connection:

JDBC Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection: jdbc:sqlserver://<HOST NAME>:1433;databaseName=XI

Poll Interval : 30 Sec.

-

---

Our database is Microsoft SQL Server 2005. XI is PI 7.0

After poll, JDBC adapter updates the 'flag' field as 'Y' in poheader table. But, while check in SXI_MONITOR, inbound message, the XML shows as empty as below.

<?xml version="1.0" encoding="UTF-8"?><ns1:PO xmlns:ns1="http://www.brain.com/ABB/SDFunctions"></ns1:PO>

In the RWB, Component Monitoring --> Adapter Monitoring --> It shows the message 'Processed Successfully' for the JDBC Sender Adapter.

Adapter works fine, but the inbound XML shows as empty ... After Poll JDBC adapter updates the data in SQL table.

So, what could be the problem friends ?

Kindly help me friends to solve this issue.

Kind Regards,

Jegathees P.

We are using Microsoft SQL Server 2005.

[Former Member]

hi

Run the Select statement from u r Sql plus , wud give u the clue.Problem with u r Select statement.

1) Select statement has where clause based upon "flag" "pono" "material_code"

podetail.material_code ??? r u not passing anything here ???

2) Update wud happen since it's based on flag.

run commands on sqlplus wud sort u r problem

rgds

srini

[kkram]

Looks like the pono in the poheader and podetail are not matching and hence you are not receiving any resultset in your query but your update works fine because it acts only on the poheader.

KK

[Former Member]

hi,

I think the problem is with your SELECTstatement, run the statement on your database directly, it shdn't return any values.

Check this....

Regards,

Sukarna Chirumamilla