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
Ok, built a new PC.  Here are the parts: MSI K8N Neo4 Platinum XFX Geforce 6800GT Seagate 160 Gig w/ NCQ 1 Gig (512x2) Corsair value memory 3200 PC Power and Cooling 470 Watt Silencer w/ Y PCI-express adapter Athlon 3500+ (Clawhammer, says Newegg) Li [More]
I have a MacBook Pro and a Mac mini. I use a portable hard drive to store my iTunes library. I was able to use the same library for both Macs before and I'm not sure when (maybe before iTunes 8) but I'm not able to anymore. I can run it just fine in [More]
Basically my sister updated her iPhone 5c to iOS 7.1, before this she has a passcode on it, She then took the passcode off, after the 7.1 update. Yesterday it randomly put a passcode back on so she tried the ones she had used before and the usual 1,2 [More]
Hi, I am in the earlier stage of developing a web application with Jdev 10.3 using ADF BC. I authorize the users against LDAP in my application. I got some help about orion.application.xml file and jazn. But I need some thing more to start up with. I [More]
I am using a simple HTML page that references several external CSS style sheets.  The style sheets are site root relative.  The code validates. http://www.sandsmuseum.com/coinop/games/evansraces/documentation/index.html In Dreamweaver, the page looks [More]
Hi All, When trying to open task form link which is in email, facing: How to fix this issue? thanks in advance!Paul, My scenario is: Having a team site and a sub-site. In sub-site, created on list form associated with designer workflow which will ass [More]
Hi We have Scenario like an IDoc would be send to SAP through XI system by a non - sap system and expects the Status of the sent IDoc from SAP system in an Async communication by using ALEAUD message type. Non SAP <==> XI <==> SAP We have trie [More]
I am using Firefox 6 the latest version on Windows 7 64 bit using 2 monitors. I was on a website that wanted me to logon via facebook. So the browser opened a popup windows. The window that opened covered both monitors. The left edge of the window st [More]
Hey there, is it possible to get custom skins to appear in design view without creating a Theme? My ultimate goal is to improve the design-time experience for a custom component that I have.  The component extends SkinnableContainer and I have a skin [More]
how can i change my passwordPlease describe the situation better. Is it a lost iPhone? Is it the password for the phone that you need to change, your Apple ID password, or some other password?Read other 2 answers [More]