Skip to Content
author's profile photo Former Member
Former Member

how to prevent the db adapter, which is attached to a window, from deleting data in database when the data in the attached window has expired?

Here is the problem I've got:

In the ESP project, I have a window that do some operations on the input data, and I have a db adapter that attach the window and insert the data in the database.

At first, every row in the window will be inserted in the database. But as time goes by, some rows in the windows will expire, and at the same time, the db adapter will make the database also delete the corresponding data in database.

In my case, I don't want the db adapter to delete any rows in the database.

Can anyone help me?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on May 09, 2014 at 01:30 PM

    Kevin - there are a couple of different ways to address this, depending on the use case. Start by reading this post. The simplest is to configure the adapter for Data Warehouse mode - if that works for your use case.

    And if that doesn't meet your needs, there are other options that can be considered:

    - feed the window through a stream (which will strip out the deletes)

    - set up a Flex operators to filter based on opCodes or otherwise transform events - including their opCodes

    - and it doesn't sound like you are using updates, but just an FYI, there is a new feature coming in SP08 called "Keyed Streams" that adds some additional flexibility

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.