Monitoring table from JDBC

[former_member184166]

Hi,

It's possible monitoring an insert or update in one table (oracle) from JDBC adapter?.

I want to begin mi scenary BPM when it generate an new registry in my database.

Regards

[MichalKrawczyk]

hi,

>>>>It's possible monitoring an insert or update in one table (oracle) from JDBC adapter?.

in a way yes

you can set the pool interval for the sender jdbc adapter

and it can check the table (with a select statement)

for new or updated entries (and when it finds a new one

it can send the data to XI )

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions">XI FAQ - Frequently Asked Questions</a>

[former_member184166]

thank's Michal

this is possible if i know when a registry is new right?(example: a field of a table that indicates a state)

who it's FAQ of the list of the page?.

Regards

[Former Member]

Hi,

JDBC adapter allows you to select and update in the same aapter.

Please got hrought htis URL.

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

Regards

Vijaya

[bhavesh_kantilal]

Hi,

when you are using your JDBC as a sender, then your JDBC will poll over your database and select the rows that satisfy your Select Query. Also, there is another field in your JDBC adapter that is very important and that is the Update satatement. Once your JDBC adapter executes your select query and selects rows from the database, you might not need those rows to be selected again. In this csse, you can use the Update statement to update the database.

In the case of the receiver JDBC adapter, you can insert/ update/ delete data and execute stored prooedure into your databse.

For more info, look at these links,

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

To access any Database from XI, you will have to install the corresponding Driver on your XI server.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Regards,

Bhavesh

[MichalKrawczyk]

hi,

>>>>this is possible if i know when a registry is new right?(example: a field of a table that indicates a state)

yes you need to have a column which indicates

that the entry is new or updated

(in the sender jdbs you can change it after you do a select so it won't be retrieved with the next select)

>>>who it's FAQ of the list of the page?.

don't understand that

you mean who's ?

anyway XI FAQ is a good place to start looking

for XI related questions

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions">XI FAQ - Frequently Asked Questions</a>