Sitemap

Amicuk Programming Answers

Poll Database Adapter Physicial Delete strategy

-0001-11-30   Views:0

Advertisement

Guys, The database adapter should delete the record from table only if the record was processed successfully in esb or BPEL. But as far as i tested it deletes the polled record regardless of success or fault. Is there any setting that I need to do to

Guys,
The database adapter should delete the record from table only if the record was processed successfully in esb or BPEL. But as far as i tested it deletes the polled record regardless of success or fault.
Is there any setting that I need to do to force delete only when a successful instance is created.

The replay answer
Advertisement
DB Adapter should participate in transaction, so upon failure it should be rolled back.
Can you make sure you aren't using any MCF properties, and also in your process you don't have any dehydration point (e.g. recv/on-msg)?
Regards,
Chintan

Go to See the other 2 answers

Poll Database Adapter Physicial Delete strategy

Category:DefaultRelease time:-0001-11-30Views:130

Guys, The database adapter should delete the record from table only if the record was processed successfully in esb or BPEL. But as far as i tested it deletes the polled record regardless of success or fault. Is there any setting that I need to do to[More]

Rollback in database adapter with delete polling strategy

Category:DefaultRelease time:2015-10-11Views:130

Hi All, We have designed a database adapter with "Delete the Rows That Were Read" after read strategy with auto-retry attempts as 5. In BPEL process, where we are receiving the DB records, we are throwing a rollback fault in case of any fault. D[More]

Use of current time for polling Database Adapter query

Category:DefaultRelease time:2015-10-11Views:130

I am writing a simple BPEL process with a Polling Database Adapter and a Recieve. The idea is that we are polling an XE database for any entries in a TRIP table which have an expiration date/time field that has passed. The Adapter was build using JDe[More]

Urgent: "where" clause for polling database Adapter

Category:DefaultRelease time:-0001-11-30Views:130

Hi I am creating a database Polling (logical delete OPEN to CLOSED) adapter that polls a table for records which have a "SCHEDULED" date field. The Polling Adapter should pick up those records where the status is OPEN and SCHEDULED<=SYSDATE.[More]

Database Adapter Logical Delete Not Working....

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have an issue with the DB Adapter under BPEL GA 10.1.3.1. I'm trying to do a logical delete on a table however the logical delete isn't updating the records to show that they've been processed. I've created a simple test case with a 3 column ta[More]

Where clause for polling database Adapter

Category:DefaultRelease time:-0001-11-30Views:130

I am creating a database adapter that polls a table for documents that are more than a month old based on a last updated field. For My where clause in the select statement I would like to have something like: where last_updated_date < add_months(sysd[More]

Oracle BPEL Polling Database Adapter

Category:DefaultRelease time:-0001-11-30Views:130

Can someone give me sample or link of db polling ? i tired in following way 1. created db adapter with logical delete option 2. then created bpel process based on wsdl i tired inserting new data but my instance did not get executed?Hi, Can you please[More]

How to specify custom SQL in polling db adapter with logical delete option

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I am writing a SOA composite app using JDeveloper SOA Suite 11.1.1.4 connecting to a SQL Server db using a polling DB Adapter with the logical delete option to send data to a BPEL process. I have requirements which go beyond what is supported[More]

How to delete the content of a datatable by the "Database Adapter"

Category:DefaultRelease time:2015-10-11Views:130

Hello, i want to delete all entries in a table by a database adapter - like "DELETE FROM table" in SQL. (Oracle SOA Suite 11g SR1, with Oracle DB over JDBC)) When i create a new Database adapter i can select standard functions for "insert,[More]

Database Adapter Advanced Polling Technique

Category:DefaultRelease time:-0001-11-30Views:130

I would like to create a polling database adapter on an SOA application. The data is statistical and changes frequently. I have developed the SQL in sqldeveloper to get the data (hard part done, or so I thought). I would like the adapter to poll the[More]

Intermittence for execute Polling with DataBase Adapter in OSB11g

Category:DefaultRelease time:-0001-11-30Views:130

Hello Guys, I'm having a problem running the polling DataBase Adapter OSB11g. The creation of the adapter was made in Jdeveloper 11. The problem is: Intermittence to run the polling DataBase. Sometimes it works, other time it does not work. Displays[More]

Hot
I can't update any apps on my iPad2 because the store keeps asking for my password on an appleID that is no longer valid.  It was my old comcast email, which I cancelled, and even though I've tried signing out of store, and signing back in with the c [More]
Hi. I am currently running Photoshop elements 10 and Premiere elements 10 (64Bit) on a Windows 7 Home Premium machine. The Hardware specs are pretty good, with a I7 2.5 processor, 8GB RAM, 2GB dedicated video card etc. I was planning to upgrade mysel [More]
which the easy way to transfer contacts from iphone4 to 520. i have backup of iphone4 in windows outlook express.from here anyway to nokia 520? or any other easiest way?Try THIS Outlook express is ancient and has not been supported or available for y [More]
Sorry, thread duplicated. Edited by: Andres Vilallave on 14-may-2010 15:31Hello, I had a situation similar to this. I had NULL selected in the column when I wanted to hide the link. Please find below more explenation:- <b>example report </b> I [More]
I've had BT Infinity 2 for a couple of years now and it has been working flawlessly. I use a Fritz!Box 7390 router and have had no problems at all with it. That is until mid-January 2014 when I noticed by connection speed dropping down to less than 4 [More]
hi,     the selection-screen has the fields invoice number,invoice date and customer name. date is mandatory..now i have to fetch the data based on the selection. if only date is selected,then i have to print the entrie data from that date. how to  w [More]
Question How do we transport questions and questionnaires from dev to QAS or to PRD. Do you type all them again or there is process no. What is best process others do Answer As you must be aware, Questionnaires are updated from a Recruiter start page [More]
transferring my contacts to my phone from my computer saved as vcard, what program do i use, i have the apple 3gs. I used Icloud and clicked on import in contact there a message came back with an errorHello Tehuti2, There are a few ways to transfer c [More]
hi, i created a data element. after sometime in se80 when i tried to edit it, i get an error message saying " system settings does not allow changes to be made to the object" ..why ? whats the solution ? thksMay be somebody has changed the syste [More]
Hi all, Back with more LMS questions.  We have 4.2 running (two separate instances - we have more than one network) and I have a config collection job set up.  Upon initial discovery, configs were pulled from all devices into the Shadow director as e [More]