I think Alexy resently added this to 4.0, and it is scheduleded to be back ported to 3.2. I think needed this for optimistic locking.
I would also like to do this. I have an existing CMP based application, to which I must now add some kind of history reflecting who has changed what during program execution.
I thought I would be able to write an interceptor to intercept all JDBC calls that are made to the database. I would then treat this info, add user info and send it to an MDB so that history tables could be appended with this information.
I was capable of writing a proof of concept with a working simple interceptor and a message queue. However, I don't succeed in intercepting JDBC statements. Since the logger is capable of doing this I think I am missing something. Does anyone have an idea to point me in the right direction? Thanks in advance.
Architecture used: Win2K server, JBoss 3.2.3 (soon to be 3.2.4) and MS SQLServer 2000.