tigger jdbc sender

[Former Member]

Hello All,

I have JDBC-RFC Scenario.

My requirement is like whenever any changes are made in oracle database (insert, update, delete), immediately it should send data to RFC. I need real time scenario. i don't have direct access to DB

Is there any way to do that?

In one of thread i have read that we can receive a SOAP trigger message from db using primary key and the use web service to get details is possible. In this case i don't need to have access to DB.

If that is possible can anyone tell me how to do that

Please guide me for the same.

Regards,

Manisha.

[JoelTrinidade · Accepted solution]

Hi Manisha,

Yours is a very interesting requirement . I don't think such a functionality is possible against a jdbc adapter but with a soap it might be possible. The idea being like suppose if you are using SQL 2005 you can use a CLR based stored proc to call into a .NET web-service.

For further help refer the thread.

http://www.windows-tech.info/15/8be468c6c49fcb5e.php

Regards

joel

Edited by: joel trinidade on Mar 24, 2009 10:06 AM

[Former Member]

Hi Joel,

I have orcale system...is it possbile with oracle system?

[JoelTrinidade]

Hi Manisha,

Its surely possible with oracle system. In fact it would be easier but the only thing is that you would need to take help of someone who is well versed in stored procedures.

Note: As and when i come up with something i will update this thread.

Regards

joel

[Former Member]

For this possiblity of receiving SOAP message you need to check from the Database programming end as they need to write stored procedure for trigger the request whenever an update ,change ,... happens from the database end.

May be you can ask them to send the data via http request (provided the data is not of large volume)

and process the data once received.

This can be possible.

Rajesh

[Former Member]

Hi Rejesh,

U mean, we can write stored procedure to trigger SOAP messge whenever any action happens in oracle database?

As Joel said, using .NET will not be possible for me...

So it seems writting stored procedure to send SOAP message is better or i can use http to trigger.

Can u tell me how it happens?

Regards,

Manisha

[Former Member]

In our application we use to get the notification via http request from SQL Database server

may be it can be possible with oracle too,check it out with your Databse team for more possibilities

Rajesh

[Former Member]

Hi Rajesh,

Its sounds great !!

I guess it is possible with Oracle server also.

Can u explain me in details how it is done in ur case.

Thanks a lot for showing me path.

Regards,

Manisha

[Former Member]

It has been done by database team so i am not aware of the process how they did it.

but surely be can proceed for doing this may be search some database forums for pointing to in right direction

HTH

Rajesh

[Former Member]

Hi Rajesh,

Even in my case i will not be doing anything at database site.

I just need confirmation that whether sending http request to XI is real time (as changes are made in DB that time request is send to XI).

In ur case it is happening so??

Regards,

Manisha