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 have a PRING button on the HTML DB report. When the user click on this PRINT button it launches the oracle report location Portal Server in UNIX box. The report display in Lanscape format as I set it up. However, when I go to File/Print and click p [More]
Ok, first - here is my setup. I've got the router hooked into the modem, with the desktop computer hooked directly into the router.  I've got my laptop running off wireless internet, and I've got an ethernet cable connecting through my laptop to an x [More]
I run a music teaching business from home and currently I just have an iMac, an HDTV, a printer and an external HD (for Time Machine backups). My computer and peripherals are in a small study and my TV is in the front room where I now teach. I want t [More]
Trying to open a streamed PDF in an IFRAME in Internet Explorer 9 on my Win7 64bit machine. This results in the following dialog: There is a problem with Adobe Acrobat/Reader. If it is running, please exit and try again. (4:4) The PDF is streamed (no [More]
I have installed Tomcat 5.0.28 and it is running successfully in Fedora core 4,I wrote a servlet,to access a mysql database and it is running correctly,but when i logged onto non-root user, when i call the servlet through the html page i get "page no [More]
Hello, I have a batch processing java script which will place digital signature fields in a drawing. Sometimes the drawing could have multiple pages and the script needs to place the digital signature fields onto each page. The problem with the scrip [More]
I am having trouble with the bluetooth handsfree and my Nokia N73. Previously I had the N70 which I had almost no trouble with. I set up a connection, copied across my contacts to the car and since then evertime I started the engine my phone would au [More]
Hello All, I relatively new to Pr Pro and I am working on a music Video.  I need to sync various clips to the music track.  I would like to know is there a key command for nudging clip position in the timeline so that I can more easily get my mouth m [More]
Today it is the "Select" function.  A very common task is to select between two values, and this function does that in a tidy little package.  And unlike the case structure, we can easily see what both choices are on the BD.  What you end up wit [More]
i have a littel problem i buy some iphone application from some shop around my area and i try to install in my iphone with laptop but i cant its seys autherize this computer and i autherized my computer a lot of time but i cant steel install any apli [More]