Hi!

I'm working with the newest hibernate release and oracle 10g...

... and I'm having the following problem:
My application will get an interface to a legacy system through a database-table. If the legacy system writes a record into the table then my application has to do something (transform it and write it into one of my own tables for instance). The question is, what is the best way for my application to detect that a new record has been added to the database table?

I think there are two possibilites (changing the legacy application / the interface is no option :-( ):
1.) Polling the database table all n seconds
2.) The database sends me an event, if a new row has been added

Does hibernate/oracle supports option 2? Exists there another good sollution for my problem?

Regards
Hoeft