NHibernate, Oracle and sql instrumentation

Question

Hopefully I can express this in a coherent and meaningful way:

Two of our DBA's came up to me today after an email I sent explaining why we were using NHibernate and the benefits of an ORM framework. They have been pushing hard for refactoring our stored procs to include instrumentation like this:

BEGIN DBMS_APPLICATION_INFO.set_module(module_name => 'Human Resources' ,action_name => 'Get Employees');

{sql here}

DBMS_APPLICATION_INFO.set_module(NULL, NULL);

My questions really stem around how could we accomplish this, are there any huge caveats that would recommend against finding an implementation for this, if this is too painful, are there alternatives.

Thank you in advance, -sean

This is a good start in the absence of any other instrumentation, but it is unclear to me where you are considering the calls - PL/SQL stored procedures or Java-side code? — dpbradley
– dpbradley, Commented Jul 20, 2010 at 0:09
That's the problem, the dba's would like the instrumentation to be on the database side but we're not using stored procs, just NHibernate's generated SQL. Can we add the instrumentation to the NHibernate SQL? — Sean
– Sean, Commented Jul 21, 2010 at 14:21
Don't know how it fits in with NHibernate (and that's why I'd like to see an example), but the ODP documentation has Module/Action in as Connection properties download.oracle.com/docs/html/E15167_01/… — Gary Myers
– Gary Myers, Commented Jul 22, 2010 at 4:46
I can't actually give any examples as I'm trying to figure it out but it would basically be like asking NHibernate to prepend and append calls to DBMS_APPLICATION_INFO.set_module before it does anything with the underlying datastore. — Sean
– Sean, Commented Aug 4, 2010 at 18:51

Community · Accepted Answer · 2017-05-23 10:27:43Z

0

Seems like what you need is auditing? Maybe Data Auditing in NHibernate and SqlServer and http://www.shawnduggan.com/?p=89 can help you out

edited May 23, 2017 at 10:27

CommunityBot

11 silver badge

answered Jul 26, 2010 at 6:22

Zabba

65.6k48 gold badges183 silver badges213 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sean Over a year ago

This is definitely heading in the right direction. The event api in NHibernate might just be what they are asking for. I will post what I find after some more experimentation. Thank you.

Collectives™ on Stack Overflow

NHibernate, Oracle and sql instrumentation

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related