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
The backup of my system failed because the files named wbengine.exe could not be found. How can I repair this ?? Peter BoeremaRead the Microsoft KB @ http://support.microsoft.com/kb/981851 Please remember to click "Mark as Answer" on the post th [More]
H, This is reg JIT - in Schedule Agreements JIT schedules are created to day 10.02.2010 .. In Creation profile for JIT, 'Changed or next date' is given & 'Weekly trans' option is chosen I could see system calculated 'Next JIT sched' date as 15.02.201 [More]
I have remote access using my IMAC. The computer at work is a Windows PC, how do I set up the IMAC's keyboard to function as the same one at work?Port 3389 should be open on your work network. Check with your admin. They know what ports are open on y [More]
Hello everbody, how can I set the startpage in workspace area (i.e. transaction index or knowledge search) in IC WebClient? (SAP CRM 4.0 SP 12) Thanks a lot. Regards DirkHi Dirk, I'm in a 4.0 version also. We have SP07 with service industries add-on. [More]
On July 19, 2007 the new firmware version 12.0.013 for Nokia N95 became available through Nokia Software Updater for US product coded N95s. I installed it and only within 1-2 hours my phone messed up. It is now almost unusable. I am trying to figure [More]
I've created a hero slideshow on the homepage. It is "unpinned", however it doesn't move vertically with the rest of the content when scrolling up/down. It stays in its same spot and the other page content scrolls correctly.Hi Aish! Sadly, it is [More]
Hey guys i urgently need help in Seeburger adapter,actually i have a scenario where in i m getting EDI directly from VAN or from seeburger adapter over XI,and i have to post this information to R/3 server,can anyone provide me with some links about h [More]
Hi, DB Version: 11.1.0.6 O/S : Win XP Prof I am reading 11g docs.In the Upgrade guide, there are quite a number of ways listed for the upgrade.Please look here. The listed ways are (1)Database Upgrade Assistant (DBUA) (2)Manual upgrade using SQL scri [More]
Hello All, According to my requirement I created a copy program(ZRSEIDOC2)   which is copy program of “RSEIDOC2”attached in T Code WE02. and I  created another program ZXXXXXX. Now what I am trying to do is 1.     I  am trying to export the final out [More]
Can't get to the bottom of what's going on with my machine. It's very slow after start or wake-up, beachballs with lots of disk activity even when no apps are open. After twenty minutes or so everything seems OK, well nearly OK as it will still beach [More]