very important question about entity bean + warjort

[mannu]

My very important question is the next one:
I have a db linked to ejb entities. That's meaning that I have to ways to add data:
first one: create ejb entity, which will update my db; and second one: directly by accessing to my db.
In this second case, does jboss server know (because of the .ldb?)in the same time that a new data has been added (without doing a findall() on my ejb), and then could I make an event, like a message or another update to another database? In other terms, is jboss able to detect changes in a database, and then, produce an event in background, without showing anything to any users.

Make sure, I would be very very happy to have many responses, specialy from warjort, my master...

[adrian.brock]

The only way to do event processing on database
updates is to use triggers.
I've never done this with ejbs. I don't even know
if the spec allows it, or how transactions might be
handled in this case.
Of course using triggers would make it synchronous.

You probably want to ask in the persistence forum,
but knowing you, you've probably posted this to every
forum anyway :-)

A better approach is to send a message to an
MDB with the key to the data you changed.
The MDB can then invoke your second bean, with the key
of the changed data, no need for findAll()

Regards,
Adrian

[mannu]

first all, thank you warjort for answering me so quickly...
If I understand your answer, even if each of my data is an EJB entity, when I add a data (i.e. a EJB entity) directly by accessing to my db, jboss don't know it, and can't create an event itself.
Am I true?

[adrian.brock]

I think you are correct. There is no notification support
for ejbs. There could be something in CMP, but
probably not. (I don't know CMP, ask in the persistence
forum)

My guess is you'll have to do this yourself.

Regards,
Adrian

[mannu]

Thanks a lot Adrian,
I hope one day (in the future) my jboss knowledge will be able to help you at your turn...

[wolfc]

Yes, it is possible at the cost of speed.

In your jboss.xml you can create a container configuration with a different commit option. (Look in standardjboss.xml for examples.)

Look in ejb 1.1 spec (9.1.10) for the different commit options. (Probably option 'B' will work perfectly.)

[mannu]

thank you wolfc, let's try!